… case safe-slave-backup-timeout was reached when using the safe-slave-backup option, SQL_THREAD was left in stopped state causing the slave thread to lag behind. This was fixed by checking the initial SQL_THREAD state…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE…SLAVE STATUS output after an error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave_SQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona.commanual Slave_heartbeat_periodblogpercona.commanual slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona.commanual Slave…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_create_table’, ’31′ ‘Com_dealloc_sql‘, ’0′ ‘Com_delete’, ’348788′ ‘Com_delete_…’ ‘Com_show_warnings’, ’8′ ‘Com_slave_start’, ’0′ ‘Com_slave_stop‘, ’0′ ‘Com_stmt_close’,… ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads‘, ’0′ ‘…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… you will break your replication and the SQL process will stop with an error. Example: mysql> CREATE FUNCTION … server it gets replicated to the slave with the DISABLE ON SLAVE option. Thanks to that the Event … server id 1 end_log_pos 319 Query thread_id=12 exec_time=0 SET TIMESTAMP=1323896046/*!*/; …
Comment: Thoughts on MySQL Replication
October 16, 2008 By 18 Comments
…playback of SQL statements, one query can delay replication… each unique database (only one thread pulling from each specific database queue…). I’ve never liked that replication stops with aborted queries on the master… replication queries running on the slave simultaneous rather than as today (running…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… then ensure the master and slave are in sync (once the test load is stopped). The team at Percona …two reasons: My attempts at copying the Facebook multi-threaded python load-generation code seemed very, very slow …-12-21T14:25:02 bindir is mysql-5.5/sql # 2011-12-21T14:25:02 core is “kewpie/randgen…
