adamsfamily February 2016

'events_statements_summary_by_digest table' is missing

In my MySQL 5.6.27 default installation the 'events_statements_summary_by_digest' table is missing in the 'performance_schema' database.

In fact, I think more tables are missing. Did I something wrong during the installation? How can I fix this?

use performance_schema;
show tables;
+----------------------------------------------+
| Tables_in_performance_schema                 |
+----------------------------------------------+
| cond_instances                               |
| events_waits_current                         |
| events_waits_history                         |
| events_waits_history_long                    |
| events_waits_summary_by_instance             |
| events_waits_summary_by_thread_by_event_name |
| events_waits_summary_global_by_event_name    |
| file_instances                               |
| file_summary_by_event_name                   |
| file_summary_by_instance                     |
| mutex_instances                              |
| performance_timers                           |
| rwlock_instances                             |
| setup_consumers                              |
| setup_instruments                            |
| setup_timers                                 |
| threads                                      |
+----------------------------------------------+
17 rows in set (0.00 sec)

Answers


Rick James February 2016

The changelog for 5.6.9 says

"If you upgrade to this release of MySQL from an earlier version, you must run mysql_upgrade (and restart the server) to incorporate this change into the performance_schema database. (Bug #14075527)"

events_statements_summary_by_digest was added in 5.6.5.

Post Status

Asked in February 2016
Viewed 2,794 times
Voted 6
Answered 1 times

Search




Leave an answer