…the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. … variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted …thread waiting for InnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola). Handling of the network issues in Galera …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… imagine plenty of concurrent clients attempting to modify… one node If your issue is really the… get less than 5 people who do out…if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements …
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not… this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower… I say CPU usage drop means concurrency issues it does not mean CPU increase does not mean concurrency issues too. You can have 2…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…issue which is not easy to fix, But why is not it mentioned in MySQL 4.1 to 5.0…MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE … If the tablespace has been created with MySQL 5.0 or older, importing that table could crash… fixed #713481 (George Ormond Lorch III). Fixed issue where innodb_blocking_lru_restore did …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…MySQL as only one query is ran concurrently, same can be told about 8 hard drives which this box had. MySQL…MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…). MySQL 5.5.8 now has features related to having several buffer pool instances that are supposed to fix the buffer pool scalability issue…_size=4096 innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… as locked in “IX” in SHOW ENGINE INNODB STATUS while concurrent updates to this table will be prevented until it is… issues with Innodb chances are it is row level locks or auto increment table level lock (mostly with MySQL 5.0 and older MySQL versions). MySQL level locks are entirely different story. Explicitly locking tables on MySQL level will prevent tables…
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
… MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL…interested what is issue in scaling over 16 threads, that in current benchmarks – this is concurrency on rollback …–init-rng=1 –num-threads=$i –max-requests=0 –oltp-dist-type=uniform –max-time=180…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… original implementation which appeared in MySQL 4.0 Query Cache was designed …”cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query …. This especially applies to reads issued to Slaves – because these are …What MySQL will do ? It will allow all of them to execute concurrently …
