…InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… features of InnoDB is the row level locking. This feature provides better concurrency under …lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 …information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE …
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…threads) thread thrashing could be still observed even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency… frequently than innodb_thread_concurrency setting. if you have innodb_flush_logs_at_trx_commit=1 and do not …
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… value is best for MySQL 5.1 and for MySQL 5.0 respectively ? Both versions do their best with innodb_thread_concurrency=0 and 5.0 is slightly but… for MySQL 5.1. You can’t really use this results to tell MySQL 5.1 will be winner in cases when small values of innodb_thread_concurrency get…
Comment: kernel_mutex problem. Or double throughput with single variable
December 27, 2011 By 17 Comments
… manual of 5.1 and manual of 5.5 5.1 innodb_thread_concurrency the default value is 8 http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_thread_concurrency 5.5 the default value is 0 http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_thread_concurrency if…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… limit concurrency in many cases can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1… them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or parallel…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=8 innodb_read_io_threads=8 innodb…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not…usage drop means concurrency issues it does not mean CPU increase does not mean concurrency issues too. You…either everything waits so there is not enough runnable threads to cause full CPU usage, or you …
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
…5.1. To refresh, the most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB…are: – InnoDB IO threads – Adaptive…MySQL-5.1.43 vs percona-5.1.43. The results made for TPCE configuration with 2000 customers and 300 tradedays and 16 concurrent…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… some unique fixes such as different innodb_thread_concurrency handling and other optimization. Should we take Innodb from MySQL 5.4 and merry it with unique… MySQL 5.0 ? How useful would you find it ? Currently we see a lot of customers not quite ready to update to MySQL 5.1…
