… it is not MySQL problem, might be even not problem with your MySQL configuration, queries and …Do push concurrency too high Many developers will test script with multiple level of concurrency and find …. It also often helps with monopolizing replication thread. For example if I need to delete …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb…InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but…, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 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: 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 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… 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… use this results to tell MySQL 5.1 will be winner in cases when small values of innodb_thread_concurrency get best performance. The…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…€™s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested…_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: 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…concurrent inserts happening to the same table. This was born same as bunch of others due to statement level MySQL…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
…to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing threads (such as limiting number of Apache Children) as well as adjusting innodb_thread_concurrency and doing other server …
