“events_statements_summary_by_digest表”缺失

Question

在我的MySQL 5.6.27默认安装中，'performance_schema‘数据库中缺少performance_schema表。

事实上，我想还有更多的桌子不见了。我在安装过程中出了什么问题吗？我怎么才能解决这个问题？

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)

Answer 1

5.6.9的变化量是：

如果从早期版本升级到此版本的MySQL，则必须运行mysql_upgrade (并重新启动服务器)才能将此更改合并到performance_schema数据库中。(Bug #14075527)

在5.6.5中加入events_statements_summary_by_digest。