… option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed…). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by… (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 XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… after a crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of them becoming corrupted during the crash… table or any other statement – it is table open which is important. There are other problems which you may experience related to MySQL Crash…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL… and made it to caught up you can use mk-table-checksum to ensure data is the same. It is possible… upgrades in time a bit so if something happens (like MySQL crashes) you have only one/few shard to deal with. P…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… buffering taking place and as MySQL crashes it does not store all data it could recover to MyISAM table. Using series of queries… use MyISAM table but fetch data to the script instead make sure to use LIMIT or PK Rangers when MySQL crashes you will… – you may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… if you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is… does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication… thing works. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is open and is then restarted, the temporary table doesn’t exist anymore, and…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… the randgen workload was having an effect on the test tables between crash/recovery/validate cycles. To examine this for yourself during… master-slave checksums after the master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug crashCommitAfter_test…
