… InnoDB. Can you file one at bugs.mysql.com with details from the mysqld error log? AFAIK, InnoDB is snapshot safe as long as database files and log files are on the same filesystem. But MySQL…. I do use xtrabackup. It isn’t perfect but it continues to get better.
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… behavior on errors. By default these filesystems are configured to Continue when error (such as IO error or meta data inconsistency) is discovered which can continue… needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this partition anyway it just…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… two sets of eyes on things whenever possible. This also has value in case you decide to continue on to a longer relationship… –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30… errors about this.) There are a bunch of other things I’ll look at, including checking for default users in the mysql…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… STATUS’ on this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message… are bad on the master you would get the same error message again and can continue with investigation. What if logs on the master… the risks depending on applications (and on amount of events which were corrupted) you may want to let replication continue from the new…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…, LVM snapshots that don’t have enough copy-on-write space can fail before the backup completes… server will continue to function, however, because the file isn’t really deleted. The MySQL server keeps … don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… backup will be aborted. Sometimes you might run into the errors on this step, The most common one I’ve resently seen… to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, which is…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit …error, anyone?). If any of these problems happens, it’s too late–the commit is already permanent on…to the master. However, other transactions can continue committing and sending their changes to the …
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… 30 seconds with “Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/tightloop.php on line 5″ just… to print nice error message as well as to do some cleanup work – for example you can open another MySQL connection to kill the query which was running (otherwise query may well continue to run even if…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…portability: EXIT_SUCCESS on success and EXIT_FAILURE on a failure. (Aleksandr Kuzminsky…error message is printed instead of crashing. (Alexey Kopytov) Bug #688211 – Using the –password option with innobackupex to specify MySQL… failure in xtrabackup. Now it continues with a warning message about the…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm …you can take the risks and try to continue. Sometimes you might be able to manually … later” message, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb …
