Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial, but… instance one time as as a slave, it will do so. In the function is_slave() the test for an output to… for to say that this server is a slave, but later the test of “Slave_SQL_Running: Yes” fails, because the server…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… if it is disable) and not print the position of slave thread in master logs at all. Here is some old… FLUSH TABLES WITH READ LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062 Relay…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… the Slave or you’re cloning the 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_IO…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show_relaylog_eventsblogpercona.commanual Com_show_slave_hostsblogpercona.commanual Com_show_slave… innodb_status_fileblogpercona….
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql-bin.000007′, master_log_pos=207; slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show_storage_engines’, ’0′ ‘Com_show_tables’, ’2842′ ‘Com_show_variables’, ’176825′ ‘Com_show_warnings’, ’8′ ‘Com_slave…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… the SLAVE IO Thread will disconnect and try to connect again. Here is the SHOW SLAVE STATUS output after an error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave_SQL_Running: Yes [...] Last_IO…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… slave, SHOW SLAVE STATUS now reports an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave… in combination with the slave relay log. Examining the output of SHOW SLAVE STATUS, we can see that the slave is currently executing at…
