You should probably read Marc Alff’s post about configuring Performance Schema in MySQL 5.6.
We wrote another guide, how to start using user/table/index statistics first introduced in Google patch, now part of various MySQL branches and forks:
- Start MySQL
Doesn’t work for Percona Server :( step two is needed –
SET @@userstat=ON;
Need part 2, manual for querying performance data:
1) select * from IS.user_statistics where user_name = ‘whoami’
2) select * from IS.table_statistics where table_schema = ‘foo’ and table_name = ‘bar’