… very small table_cache – this could be possible cause of the problems as removing table from table cache requires key blocks flush. Try higher values, something like 1024. Few more things you can keep in mind – MySQL 4.1 has multiple key caches – you can create separate key cache allocated to this table and possibly relax pressure on it. You also can disable key_cahce…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 27, 2011 By 11 Comments
… of internal mutexes in the system around things like the key cache that essentially serialized access. That, in turn, led to really… the key cache. These were on large 128G boxes with 16G of key cache and about 70G of free buffer space (for OS disk cache… could have milked a little more out of it with multiple key caches and whatnot, but it just didn’t make sense in…
Comment: Using Multiple Key Caches for MyISAM Scalability
February 19, 2009 By 8 Comments
Hi Peter, How can we monitor performance of multiple key caches, like for monitoring global key cache we use “show status like ‘key_read%’; ” but how i can see same information for new created key cache.
Comment: High Rate insertion with MySQL and Innodb
January 9, 2011 By 17 Comments
… corruption in case of crash. If you use Multiple tables and multiple key caches (or segmented key cache in MariaDB) you should be able to get…
Comment: Getting annoyed with MyISAM multiple key caches.
January 12, 2010 By 11 Comments
…, but multiple Key Caches help a bit, and helped me in a very bad mysql deadlock issue. I created ten tailored key caches for the… is on the concurrent access to the same table by multiple threads at once. Anybody has suspects on the OS as…
Comment: What to tune in MySQL Server after installation
October 4, 2006 By 118 Comments
…, I am attempting multiple key_cache‘s, it’s just a matter of determining which tables to assign to the alternate cache. One thing I noticed is that the primary cache, when set to 4GB, usage never… back to 1.8GB or so. After adding a second key_cache, I’ve notice it go past that 2GB mark. Thanks…
Comment: Beware: key_buffer_size larger than 4G does not work
April 25, 2007 By 17 Comments
… MySQL have a limit to the max size of the key_buffer_size, which is set to 4G. http://dev.mysql… are ways around this limitation, you can add additional key buffers or (CACHE INDEXs) for individual tables after the server starts. You… here: http://dev.mysql.com/doc/refman/5.0/en/multiple-key-caches.html Later! –Dave
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time and we….5 and this is what I used for start. Using multiple buffer pools with innodb_buffer_pool_instances=8 was very…
Comment: Beware: key_buffer_size larger than 4G does not work
March 14, 2007 By 17 Comments
Peter, Is there a way to monitor the usage and efficency of multiple key caches? Perhaps something similar ‘key_reads’ and ‘key_read_requests’.
Comment: Getting annoyed with MyISAM multiple key caches.
May 7, 2009 By 11 Comments
Multiple key caches are great when you know what your problem is and how extra caches can be utilized. Also handy for a server that is also a slave of another, since you can limit the cache dilution of the slave process.
