- Add performance_schema=1 to my.cnf
- For table stats: select * from table_io_waits_summary_by_table
- For user stats: select * from events_statements_summary_by_account_by_event_name
Tuesday, May 30, 2017
Short guide on using performance_schema for user & table stats
It took me too long to figure this out while reading the chapter on PS in the MySQL manual. Hopefully this saves me time the next time I need to figure it out. I think it gives me the equivalent of the data I get from IS.user_statistics and IS.table_statistics when using FB MySQL. From a few tests I ran the overhead from the PS was small, maybe less than 5%, while collecting this data.