…concurrency SSB tests when Peter blogged about the importance of performance at low concurrency…Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1… is cold, but uses less CPU time when the database is hot…mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov… by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…/16 cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads)… much, because e.g. for 1024 concurrent threads each SELECT has to scan about…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov… by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey…
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, it… the confusion: # Try number of CPU‘s*2 for thread_concurrency Don’t try it. The problems with thread_concurrency are two: 1- It’s…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…well disabling it (innodb_thread_concurrency=0 since 5.0.19, more about default values). For Multiple CPU boxes (4+ CPU) situation is …limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of threads which can…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… 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… innodb_thread_concurrency is greater than zero. On a stock install of MySQL, here are some example queries and the corresponding number of concurrency…, you may want to give them a bit more dedicated CPU time so they execute that much faster (even at the…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model …physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, …size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 6 Comments
…Threads_running | 1 | | Threads_running | 11 | | Threads_running | 1 | This corresponds to what is expected to be stress load but we can see MySQL…thread_concurrency…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
…of threads waiting and the more CPU cores you have available the less CPU utilization …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…
