… allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size…: bug fixed #1184695, bug fixed #1184512, bug fixed #1183585, bug fixed #1178606, bug fixed #1177356, bug fixed #1160895, bug fixed #1182876, bug fixed #1180481, bug fixed #1163135, bug fixed #1157078, bug…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… excluding lost+found folder if found. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB… waiting for InnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola). Handling of the network issues in Galera has been improved. Bug fixed #1153727 (Teemu…
Comment: Why MySQL Performance at Low Concurrency is Important
March 29, 2013 By 8 Comments
… which are low concurrency, as well as ones at higher concurrency too, but mysql currently has a bug in which concurrent queries with joins, especially those that examine a lot of the same data degrade very quickly under concurrency. http://bugs.mysql.com/bug…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… problem originally reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov… userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other bug fixes: bug fixed #1146621 (Laurynas Biveinis), bug fixed #1050536 (Alexey Bychko), bug fixed #1144059 (Roel…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… problem originally reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov… userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other bug fixes: bug fixed #1146621 (Laurynas Biveinis), bug fixed #1050536 (Alexey Bychko), bug fixed #1144059 (Roel…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… creation. It was originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection… scan in MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in… list scan and it provides stable throughput even at 4096 concurrent connections. So both the general “trx descriptors” optimization introduced in…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… problems with thread_concurrency are two: 1- It’s deprecated and removed on 5.6.1 http://bugs.mysql.com/bug.php?id=55001 2- It only works on old Solaris versions < 9 The idea of thread_concurrency for…://www.mysqlperformanceblog.com/2010/05/24/tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a limit on the number of threads that…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… lower. Once thread entered – it receives innodb_concurrency_tickets tickets, so next innodb_concurrency_tickets times thread will not be checked, and… bug 15815 so do not think it is considered to be normal behavior. About innodb_commit_concurrency. As you saw innodb_thread_concurrency… limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of…
Post: Mess with innodb_thread_concurrency
May 12, 2006 By 1 Comment
… meaning of innodb_thread_concurrency variable was changed (yeah, again). Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB…, and concurrency checking will be disabled if the setting is greater than or equal to 20. But due to different bugs, in 5.0.19 the default value is 8 again, and 0 disables concurrency checking. So if you used innodb_thread_concurrency…
Post: Announcing Percona XtraBackup 2.0.4
December 4, 2012 By 2 Comments
… (Generally Available) stable release in the 2.0 series. Bugs Fixed: Bug fix for #932623 introduced the regression in XtraBackup 2.0… not normalized to the values used inside InnoDB. Bug fixed #1062684 (Sergei Glushchenko). Bug fix for #932623 introduced the regression in XtraBackup… the variable wasn’t set. Bug fixed #1068485 (Alexey Kopytov). XtraBackup Galera tests can now be run concurrently. Bug fixed #1077800 (Stewart Smith…
