… you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User: replicant Master_Port: 3306 Connect_Retry: 60 Master…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and … | 2665 | Waiting for master to send event | NULL | | 801813 | system user | | NULL | Connect | 0 | Has read all relay log; waiting for the slave I/O thread to update it…
Comment: Reasons for MySQL Replication Lag
August 13, 2011 By 6 Comments
…Mysql Master to Master Replication Master A = In production Environment Master B = AT DR site Changes from Master A to B are not replicated while changes from Master B to…yes and the status is waiting for master to send event, But no changes are being replicated. This is a problem for me. How Can i …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before… how to send it 
What status variables do I have? The heartbeat check period time and the number of beats received. mysql_slave…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…for all three sites in one! abort_slave_event…master_tx_waitsblogpercona.commanual rpl_semi_sync_master_wait_no_slaveblogpercona.commanual Rpl_semi_sync_master_wait_pos_backtraverseblogpercona.commanual Rpl_semi_sync_master_wait…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… 3G right? To much to handle for 32 … ’0′ ‘Com_load_master_data’, ’0′ ‘Com_load_master_table’, ’0′…’, ’285487367′ ‘Com_show_binlog_events‘, ’0′ ‘Com_show_binlogs’, ‘…_reset’, ’0′ ‘Com_stmt_send_long_data’, ’0′ ‘Com_…to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait…
