….5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6… what this optimization actually is and what benefits it brings. Multi Range Read With traditional secondary index lookups, if the columns… not make sense to me. Probably its due to a bug in how counter is calculated inside MariaDB? Other Observations Sometimes…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying… project Bug reports Previous posts on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying… project Bug reports Previous posts on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master…
Post: Multi-Column IN clause - Unexpected MySQL Issue
April 4, 2008 By 20 Comments
… and it looks like a bug or missing optimizer feature. I should not be surprised though as multi-column in is not… forget about the issue and MySQL team gets yet another bug to deal with. What worries me again is – this is…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… match the one you would expect from multi versining engine – all the meaning of multi versioning is to allow you to perform… wait why is it waiting if it suppose to be multi versioning system ? Test 3: Phantom rows: before test: mysql> select… this option Strange error message. This is probably one more bug which hopefully be resolved in further versions. Test 5: UPDATE…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel …XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: Benchmarking Galera replication …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc… buffer pool? PZ: I guess it may be bug in the status or bug in implementation. I’ll check with Alexander or…
Comment: Bug fix of InnoDB scalability problem
November 15, 2006 By 13 Comments
… actually care about 4.1 Now about 4.0 and multi cores. No one is speaking about 4.0 only 4… it to multi core CPUs is nothing else but a trick to hide complete failure of MySQL/Innodb fixing this bug which… however existed for long time… it is just only with multi-cores they came to commodity market so amount of complaints…
Post: Returning to InnoDB scalability
July 28, 2006 By 42 Comments
… returning to InnoDB scalability and related bug #15815 as it hurts many users and customers using multi-cpu servers. Short intro into… global mutex is accessed for each scanned rows, what in multi-CPU/multi-threading enviroment results in “mutex ping-pong” problem. Looking…
Comment: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… post, there seems to be a similar bug open — https://bugs.launchpad.net/percona-server/+bug/805805 — “attaching to percona-server with gdb…, the fault is with ltrace in this case. Ltracing a multi threaded process (try with your firefox) kills it instantly (with…
