The DIGEST And DIGEST_TEXT Columns In performance_schema.events_statements_current Are NULL Occasionally (Doc ID 2942753.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

In MySQL 5.7 and 5.6, even if the statements_digest consumer in the Performance Schema setup_consumers table is YES, the DIGEST and DIGEST_TEXT columns in the Performance Schema events_statements_current table are NULL without being populated sometimes. For example:

mysql> SELECT * FROM performance_schema.setup_consumers WHERE NAME='statements_digest';
+-----------------------+------------+
| NAME                     | ENABLED |
+-----------------------+------------+
| statements_digest  | YES        |
+-----------------------+------------+
1 row in set (0.00 sec)

mysql> SELECT THREAD_ID, EVENT_ID, DIGEST, DIGEST_TEXT, SQL_TEXT FROM performance_schema.events_statements_current\G
...

*************************** 2. row ***************************
  THREAD_ID: 1707042
   EVENT_ID: 77
     DIGEST: 92db53a79d639624f569ddc101e32dab              ---------------> populated
DIGEST_TEXT: SELECT * , `sleep` (?) FROM `test` . `t`     ---------------> populated
   SQL_TEXT: select *, sleep(30) from test.t
*************************** 3. row ***************************
  THREAD_ID: 1708056
   EVENT_ID: 4
     DIGEST: NULL                                            ---------------> NULL
DIGEST_TEXT: NULL                                         ---------------> NULL
   SQL_TEXT: select *, sleep(30) from test.t
   
...

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.