… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it…. Bugs Fixed: Percona Server would crash on a DDL statement if an XtraDB internal SYS_STATS table was corrupted or overwritten. This… by detecting the corruption and creating a new SYS_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
March 15, 2012 By 37 Comments
… for MySQL? The most annoying for me part in Debian/Ubuntu is the /etc/mysql/debian-start and the ‘check_for_crashed_tables‘ function (found in /usr/share/mysql/debian-start.inc.sh) which, among other things, does nasty select from information_schema. On an instance having thousands+ of tables…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…, if not, you could potentially trigger crash recovery when an LSN mismatch occurs…mysql-bin.000022 | mysql mysql> select count(*) from salaries where emp_no = 10001; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> show tables; +———————+ | Tables…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… location, we bring up the new mysqld, which finds a crashed innodb, recovers this, and then it is being configured to…). We are using CentOS 5.x, LVM2, XFS and Oracle MySQL 5.5.x (x=16 on many boxes atm), but… experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… in the MySQL community are snobbish about using MyISAM (not using it that… If minimal to no loss of data on a system crash is going to be a show stopper – you should …the benefits of MyISAM which includes consistently faster query speeds, tables which are easily maintained, is more easily tuned and …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also if you’re doing FLUSH TABLES WITH…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ |…your MyISAM table you use for recovery after MySQL crashes to make …
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…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… MySQL so that it is killed forcibly (i.e. crashed) instead of gracefully shutting down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID… replica. The pt-table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table-checksum plugin can alert…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… case MySQL Server crashes. Value 2 only cause data loss with full OS crash. table_cache – Opening tables can be expensive. For example MyISAM tables mark MYI header to mark table as currently in…
