ubuntu server - mysql performance_schema missing tables -
using mysql 5.6.19 on ubuntu box, installed sudo apt-get install , missing few tables (got alert workbench when trying use performance reports).
these tables have in performance_schema:
+----------------------------------------------+ | 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 | | session_connect_attrs | | setup_consumers | | setup_instruments | | setup_timers | | threads | +----------------------------------------------+ from checking the docs see missing following tables:
- performance_schema.events_statements_current
- performance_schema.events_statements_history
- performance_schema.events_statements_history_long
- performance_schema.events_stages_current
- performance_schema.events_stages_history
- performance_schema.events_stages_history_long
this output show engines:
mysql> show engines; ... *************************** 8. row *************************** engine: performance_schema support: yes comment: performance schema transactions: no xa: no savepoints: no ... can please post show create table statements can create them? , if notice table im missing appreciate show create table well
the tables have mysql 5.5, new tables in 5.6 missing.
please run mysql_upgrade.
Comments
Post a Comment