… for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb. The tables…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_…8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb_flush_…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_…8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb_flush_…
Comment: Innodb Performance Optimization Basics
April 24, 2008 By 75 Comments
… (even after changing the innodb_buffer_pool_size). The MyISAM table finishes approximately 4 times faster than the InnoDB table. This is significant… MyISAM results: 1532.69 seconds. (25.54 minutes) InnoDB results: 6815.43 seconds. (1 hour, 53.59 minutes) I also changed the innodb_flush_method…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is … to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous… intervals) | Innodb_data_reads | 54561 | | Innodb_data_reads | 38277 | | Innodb_data_reads | 25895 | | Innodb_data_reads | 31363 | | Innodb_data_reads | 170816 | | Innodb_data_reads | 207432 | | Innodb_data…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…somewhere between MyISAM and InnoDB in both performance and features. The early version of PBXT was not fully durable (equivalent to innodb_flush_log… originally implementation by Heiki for InnoDB, and the latter, an excellent addition to XtraDB). Both methods improve the management of the …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for… below. However, in case you choose this method, then # start replication for the first time (… pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… getting faster. Check stats sampling settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is possible for stats to… whenever it seems to be executing same on low level. FLUSH STATUS; SHOW STATUS can show whenever internal operation is different…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
…(HY000): MyISAM table ‘a2′ is in use (most likely by a MERGE table). Try FLUSH TABLES. mysql> flush …PRIMARY KEY (`i`) ) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 INSERT_METHOD=LAST UNION=(`a1`,`a2`) | … for Merge Tables works differently from both MyISAM and Innodb tables and being similar to what …
