May 24, 2012

Comment: Side load may massively impact your MySQL Performance

http://bugs.mysql.com/bug.php?id=45015 (InnoDB buffer pool can be severely affected by table scans)

Comment: ext4 vs xfs on SSD

… short-sighted in the extreme. Take a look at the bug list Red Hat at ant one point — the list is… long. For that matter look at the bug list or patch list for MySQL/InnoDB at any one point in time. The…

Comment: MariaDB 5.3 is released as GA!

… some closed stuff. The bug tracker otoh is clearly an Oracle thing, we expected it to happen (InnoDB bugs were never public) and…

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

… 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads 120548 102948 76882 102672 76832 Innodb_data….89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239… not make sense to me. Probably its due to a bug in how counter is calculated inside MariaDB? Other Observations Sometimes…

Post: Percona Server 5.5.21-25.1 released!

… available. Bugs Fixed: Fixed a memory corruption regression introduced in 5.5.18-23.0. Bug fixed #915814 (Alexey Kopytov). Fixed InnoDB compilation warnings on CentOS 5. Bug fixed #962940 (Laurynas Biveinis). Fixed MySQL upstream bug #64160 that…

Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

… is a bug in InnoDB. Can you file one at bugs.mysql.com with details from the mysqld error log? AFAIK, InnoDB is snapshot… and log files are on the same filesystem. But MySQL/InnoDB is not snapshot safe if DDL operations are in flight because DDL between MySQL (frm files) and InnoDB is not atomic and some failures are not recoverable (which…

Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

… to find the bug if it is the bug or user error. I think the innodb data from the backup where Innodb fails to… your support provider for investigation. It might be related to Innodb itself or how XFS plays with LVM or something. As…

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

…-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: Percona XtraDB Cluster Feature….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…

Comment: MariaDB 5.3 is released as GA!

Unfortunately that’s not true Henrik. Take for example the InnoDB plugin that has changed frequently throughout a release. http://www… even within MySQL 5.5 GA we’ve gone from InnoDB plugin version 1.1.4->1.1.8. Also, take… should be recompiled against the 5.5.10 client library. (Bug #60061, Bug #11827366)” With Linux distributions like Debian or RedHat, a…

Comment: Connecting orphaned .ibd files

…#P#p_1″ If doesn’t work please file a bug here https://bugs.launchpad.net/percona-data-recovery-tool-for-innodb