… ‘mysqlbinlog’ on the binary log), the slave‘s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem… binary log or slave‘s relay log, you will be able to know their names by issuing ‘SHOW SLAVE STATUS’ on this slave. This is relay relay log corruption….16 sec) localhost:(none)> slave start; Query OK, 0 rows affected (0.00 sec) This will purge existing relay logs re-fetch all events…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…relay_logblogpercona.commanual relay_log_indexblogpercona.commanual relay_log_info_fileblogpercona.commanual relay_log_purgeblogpercona.commanual relay_log_recoveryblogpercona.commanual relay_log…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…| | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 | 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb_5_5_30…DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | …
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
… buffer cache + pending IO from insert buffer + pending IO for purge thread). When the max is exceeded the server can favor…. It also includes a feature to keep the InnoDB transaction log and slave replication state in sync after a crash (transactional replication… would copy events into the relay log and the mirrored binlog. It allows hierarchical replication and transparent slave failover. We are trying to…
