On performance schemas

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:

  1. Start MySQL
This entry was posted in mysql. Bookmark the permalink.

3 Responses to On performance schemas

  1. Laurynas says:

    Doesn’t work for Percona Server :( step two is needed –
    SET @@userstat=ON;

  2. mdcallag says:

    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’

  3. Pingback: 30 configuration options and counting | Ramblings

Comments are closed.