Announcement Module
No announcement yet.

information_schema innodb inspections on more recent versions

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • information_schema innodb inspections on more recent versions

    This article give a query for generating a report that tells you how much % of each index fits in the buffer pool. I went back to give it a try on a 5.5.29 install of Percona Server but am greeted with the error "unknown column index_size". I guess there had been some information_schema renames or shuffling between versions. I'm not sure how this should be modified to work with a 5.5.9 information_schema.

    Anyone got any ideas?
    Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not – it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries. MySQL Server does not provide […]