… align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption]… Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with… #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug…(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug…(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… saved then ibdata1 should be valid, maybe with some corruption. The tables structure you can get from the dictionary as it is…. You can check the docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start… to find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… 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 the corrupt data…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… CHECK TABLE in INNODB is pretty useless. For my manually corrupted table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…to corruption and data loss. For the same reason we can’t make MySQL backup …mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are reachable: mysql… system checks that InnoDB files ibdata and ib_logfile* do exist Do not restart MySQL…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…is you can actually start MySQL Server on it and perform recovery, check tables or do whatever else you…is consistent. Backing up database which was already corrupted is very nasty problem you want to avoid…long running queries. If you’re using only Innodb tables and do not need to synchronize binary …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… use tiny script which moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk and moves them back to…. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables… table open which is important. There are other problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well table locks was the problem at…-checked tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL bugs but corruption…
