… #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the event that… read operations as synchronous when they were actually asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… done some tests with concurrent load but did not see performance drops. It is reasonable that N threads doing concurrent load will be…
Comment: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… that I haven’t published results for 1 to 7 threads. Percona should publish more results on performance for less than 8 threads. I don’t think anybody disagrees with your point that low concurrency performance matters but you…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… the test on 5.6 and load data infile concurrently results for two threads is 20 times slower then 1 file after…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Andy, I used 32 concurrent threads to insert data. I plan benchmarks for SELECT, but it is later.
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… > 0) { 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_sleep_delay…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your time… really want to tune the number of threads that runs concurrently you should read about innodb_thread_concurrency: http://www.mysqlperformanceblog.com/2011/07…
Post: Mess with innodb_thread_concurrency
May 12, 2006 By 1 Comment
… 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….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…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as… | | Threads_running | 62 | | Threads_running | 62 | | Threads_running | 46 | In my experience most of the systems out in the field will run with concurrency…
