How well does your table fits in innodb buffer pool ?

(Peter Zaitsev) 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.

Read More - Register for Free Membership