rewse/mysqlbackup.cron — Issue #1: should use --single-transaction
Author: rewse
Created: 2012-03-09 08:22:01+00:00
State: open

Currently this script uses --lock-all-tables but it should be change to --single-transaction.
Because the backup can't finish in a few seconds when Zabbix is using the database.

--single-transaction doesn't get any locks but can backup under transaction-safe for *InnoDB*.
Some tables for WordPress are MyISAM but it would not update frequently.

See also http://dev.mysql.com/doc/refman/5.1/ja/mysqldump.html