…MySQL manual, especially the option and variable reference table…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…table. Works with table locks so again practically applies to MYISAM and MEMORY tables. preload_buffer_size – Buffer used for Key preloading, which works for MYISAM tables…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of… index scan queries. Full table scan queries allow to preload table data ether in storage engine caches or in OS cache. You can save these…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… packed rows – quite possible scenario for MyISAM tables. Now if we take the same… the table. The times for full table scan vs range scan by index: mysql> select …preload them to memory before join so there is no random IO needed to populate the caches. With proper application architecture and table…
Comment: Beware of MyISAM Key Cache mutex contention
August 14, 2008 By 10 Comments
…MyISAM tables with one thread and two threads. table_cache=495, Open_tables=120, Opened_tables=133. 1. Two threads and one table…preload_keys | status | OK | | lps.user_2 | preload_keys | status | OK | | lps.user_3 | preload_keys | status | OK | | lps.user_4 | preload…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…table‘, ’0′ ‘Com_lock_tables‘, ’102′ ‘Com_optimize’, ’0′ ‘Com_preload…MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache…
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
…. The ‘deadly’ combination: MyISAM mutex on the key cache, FreeBSD scheduler, and multiple cores (on different CPUs!) (AMD) MySQL would go (once a… swiches are much higher. Also creating one key cache for each high concurrency table and preloading indexes helped lower the contention. Moving to…
