…threads…InnoDB may perform differently under concurrency, which this benchmark does not cover. I will make a follow-up post about concurrency…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
….g. for 1024 concurrent threads each SELECT …innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache…mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… size of 1MB while in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which…’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…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…concurrently. It is very typical to hear complains about MySQL…mysql –num-threads=1 –max-requests=0 –oltp-dist-type=uniform –max-time=180 –oltp-read-only –mysql-host=localhost –mysql-table-engine=innodb –mysql…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… 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. …no difference. If you have a battery-backed disk controller cache, then the commit returns in less than 100 microseconds. …
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…thread->n_tickets_to_enter_innodb–; ENTER; } retry: if (entered_thread < innodb_thread_concurrency) { entered_threads++; thread->n_tickets_to_enter_innodb = innodb_concurrency_tickets; ENTER; } if (innodb_thread_sleep_delay > 0) { thread_sleep(innodb_thread…
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: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb…MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads…
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…
