… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… #1168540. Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb…). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…delete any data (though you can create or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error… after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed… temporary table into a non-temporary InnoDB table: master > delimiter // master > create procedure test_temp() begin -> start transaction; -> create temporary table test….
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such…table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table…surprising how often a server crashes, perhaps even cycling through crashes, and is not detected…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…innodb-tables…InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…`,`thumb_width`,`thumb_height`) ) ENGINE=InnoDB; Why did I use this solution compared to others: Innodb Tables – This table is getting much more reads… dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB‘s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to prevent access to…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… days after crash. Sometimes corrupted tables may be reason for further crashes or hangs, and corruption may spread itself further in the table. You… MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables…
