June 18, 2013

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864. Other bug fixes: bug fixed #1184695, bug fixed #1184512, bug fixed #1183585, bug fixed

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed… client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read…

Post: Percona Server for MySQL 5.5.30-30.2 now available

…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed… client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read…

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

corruption and server crash. Bug fixedInnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola). Handling of the network issues in Galera has been improved. Bug fixed #1153727 (Teemu Ollakka). Fixed

Post: Innodb Recovery Update - The tricks what failed.

… dump tables with innodb_force_recovery=4 was confirmed to be added in 5.0.33, meaning you could not really recover corrupted Innodb tables… have some impact. Innodb tables rarely become corrupt Indeed even if you leave out crashes in my experience Innodb tables become corrupted more seldom than MyISAM… example for so they can be fixed. Corruption usually happens in secondary index, so simple ALTER TABLE fixes it This also seems to be…

Post: Data Corruption, DRBD and story of bug

… the tablespace! InnoDB: The tablespace free space info is corrupt. InnoDB: You may need to dump your InnoDB tables and recreate the whole InnoDB: database! Trash state means that InnoDB won’t… is technical problem with ChangeLog process and it will be fixed soon, but I reported it so it is not lost…

Post: Heikki Tuuri answers to Innodb questions, Part II

…HT: You are right, bugs that cause data corruption, crashes, or wrong query results get the … greatly to spot scalability problems and find fixes for them. The work continues. I believe… have a fairly large Innodb table (150GB) that is showing poor performance for full table scans. using O_DIRECT…

Post: Add an option to Fail on Innodb Initialize failure, Please ?

…not stop if Innodb storage engine failed to initialize but starts properly… just having Innodb tables unavailable. I … to get out quickly and fix things. But it gets worse. Innodb failed initialization is not … message and think it is indeed .frm corruption – trying to restore .frm from backup or …

Post: Presentations Announcement: 2010 O'Reilly MySQL Conference & Expo

…Operating System For MySQL Author: Peter Zaitsev Diagnosing and Fixing MySQL Performance Problems Author: Baron Schwartz, Morgan Tocker EXPLAIN…Write Splitting Author: Baron Schwartz Recovery of lost or corrupted InnoDB tables Author: Aleksandr Kuzminsky Scaling Applications with Caching Sharding and…

Post: Percona sessions at the MySQL conference

… Here’s a list: Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems Peter Zaitsev: Scaling Applications with Caching, … Hot Backups and More Aleksandr Kuzminsky: Recovery of Lost or Corrupted InnoDB Tables Ryan Lowe: Achieving PCI Compliance with MySQL Yves Trudeau: How…