…slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona.commanual Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… synced with Master. To discover the difference between Master and Slave you can use excellent Maatkit tool though if you you…_new; Query OK, 0 rows affected (0.01 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old, rep_new to rep; Query OK, 0 rows affected (0…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
…over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others…_Log_Pos: localhost:(none)> slave stop; Query OK, 0 rows affected (0.00 sec) …manually executed on the slaves. Skipping around event makes master and slave potentially inconsistent and you …
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… shared here mainly applies to logical level replication. MySQL 5.1 can use row level replication which alleviates some of these issues… you’re normally OK because you can use –skip-innodb on the filtering slave and default-storage-engine=BLACKHOLE to ensure all… It is in my todo to see how well MySQL 5.1 row based replication works and performs and I will be…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave…Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 744615652 Relay…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…to see how broad is it. We let Slave to replicate with skip-slave-errors=1105 to see if we get any …uses by default to check result sets. –compare-results-method rows helped to remove them and we were down to …us to simply to hook up old MySQL 5.0 and all it slaves as a slave off new master and keep …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… Cache” which is quite helpful for MySQL Performance optimization tasks but there …query which required processing millions of rows now can be instantly summoned from…with query lookup in cache if not – skips it. Does not support prepared … not distributed If you have 10 slaves and use query cache on …
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
… whenever statements produce the same results on the slave. ROW replication will complain about ROW not exist for UPDATE or DELETE operation. So…; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave-start…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads’, ’0′ ‘Slow_queries’, ’27405′ ‘Sort_merge_passes’, ’376′ ‘Sort_range’, ’56479689′ ‘Sort_rows…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… report differences with results like row counts, checksums, column count, …across the master and the slave with pt-table-checksum. Capture … 100 queries only # –no-report simply skips the overhead pt-query-digest had…are upgrading your hardware alongside your MySQL version, you should also consider…
