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

Popular posts from this blog

c# - SharpSsh Command Execution -

python - Specify path of savefig with pylab or matplotlib -

How to run C# code using mono without Xamarin in Android? -