In MySQL 5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, again). Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB. It’s… MySQL versions below 5.0.8 for unlimited threads you had to set innodb_thread_concurrency over 500 (and default value for innodb_thread_concurrency was 8 ). Starting with MySQL 5…
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… 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…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQL 5… – Concurrent Innodb data file extension – Non-Recursive Deadlock Detection – Faster Locking Primitives – Improved Innodb Thread Concurrency – Multiple background Purge Threads – …
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: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex (or rw…. Reducing number of competing threads (such as limiting number of Apache Children) as well as adjusting innodb_thread_concurrency and doing other server tuning…
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… instead we get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4 with relevant…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…€™s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested … ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Thread declared inside InnoDB 400″ means thread is running inside Innodb kernel and still has 400 tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… when innodb_thread_concurrency is greater than zero. On a stock install of MySQL, here are some example queries and the corresponding number of concurrency… matched: 1 Changed: 1 Warnings: 0 mysql> ALTER TABLE test_table ADD INDEX (id); — 5 Tickets Used Query OK, 3 rows affected…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5… / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency…
