… Aggregations by User, Host etc – - Network IO Instrumentation – - Show Host Cache Contents – - Improved File I/O Instrumentation – Improved EXPLAIN – -… Innodb Undo Logs – Fast Restart – Preloading Innodb Buffer Pool – Online DDL – Import/Export for Partitioned Tables – Remote Binlog Backup – Innodb…
Comment: Beware of MyISAM Key Cache mutex contention
August 14, 2008 By 10 Comments
… affect. Thread1 read data from t1, thread2 read data from innodb table test, the response time for thread1 is also about… table test (innodb) After that, we tried cache the table index by following, but things does not change: mysql> CACHE INDEX user_call…_1 | preload_keys | status | OK | | lps.user_2 | preload_keys | status | OK | | lps.user_3 | preload_keys | status | OK | | lps.user_4 | preload_keys…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…preload…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… large pages in general. Currently MyISAM and Innodb. Some SQL level items as Query Cache also could use this feature. low_priority… practically applies to MYISAM and MEMORY tables. preload_buffer_size – Buffer used for Key preloading, which works for MYISAM tables only. read… work for all storage engines but currently implemented only for Innodb. tmp_table_size This variable specifies maximum size implicit temporary…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_table’, ’0′ ‘Com_lock_tables’, ’102′ ‘Com_optimize’, ’0′ ‘Com_preload_keys’, ’0′ ‘Com_prepare_sql’, ’0′ ‘Com_purge’, ’0′ ‘Com…=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before. skip-locking innodb_data_home_dir=/db/disk2/data innodb_data…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database to… restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This may reduce performance…. Full table scan queries allow to preload table data ether in storage engine caches or in OS cache. You can save these into…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… simply test the case when data does not fit into cache partition). Please note in this configuration the benchmark is very… only rely on InnoDB in this case, and it takes about 30min+ to fill FlashCache. Solution there would be PRELOAD TABLE / INDEX… trash, but after restart FlashCache was able to attach previous cache, and MySQL was able to start and finish crash recovery…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…. What is often forgotten about is – depending if workload is cached or not different selectivity might show benefit from using indexes… index ranges are scanned. There are also clustered keys in Innodb which combine index access with data access, saving you IO… might want to preload them to memory before join so there is no random IO needed to populate the caches. With proper…
