… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number may be…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… are still done similar way ? Other the years variables like innodb_thread_concurrency were added with rather complicated history of changes for meaning… or less understandable with value 0 meaning disabling Innodb internal thread queuing. Another one is innodb_flush_logs_at_trx_commit – initially it…
Post: kernel_mutex problem cont. Or triple your throughput
December 2, 2011 By 10 Comments
… workload as in previous post, 256 threads and with innodb_thread_concurrency=0,4,8,16,32,64 innodb_thread_concurrency Throughput 0 68369.02 4 137999… is with innodb_thread_concurrency=8. So now let’s compare results for innodb_thread_concurrency= 0 vs 8 for all range of threads: Threads innodb concurrency=0 innodb concurrency=8 1…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb…
Comment: Should MySQL update the default innodb_log_file_size?
November 24, 2011 By 37 Comments
… small” ” for innodb_thread_concurrency %lu.\n” “InnoDB: The combined size of ib_logfiles” ” should be bigger than\n” “InnoDB: 200 kB * innodb_thread_concurrency.\n” “InnoDB: To get mysqld to start up, set” ” innodb_thread_concurrency in my.cnf\n” “InnoDB: to a lower value…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…’re using innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot but will increase potential starvation of queued threads especially… innodb_thread_concurrency is 0 by default so this queuing feature is disabled. innodb_purge_threads is now 1 by default using dedicated background purge thread…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… were hundreds of queries stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which can be… pile up. This was also very interesting case about optimal innodb_thread_concurrency. I continue reading (and hearing at the conferences) conflicting recommendations…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… to compare results with different innodb_buffer_pool_size or innodb_flush_log_at_trx_commit but for innodb_thread_concurrency – you should be picking… benchmark run with innodb_thread_concurrency=1000 – This is exactly the value which you should never use. The limit of 1000 threads inside the…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_commit=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb_flush…
