…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…send_long_…innodb_status_…
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… ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long_data’, ’0′ ‘Com_truncate’, ’0′ ‘Com_unlock_…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… may take quite a while to complete on systems with long queries. Problems with data on multiple volumes If you have… process you can clone slaves from the slaves without stopping them – you just need to use SHOW SLAVE STATUS instead of SHOW MASTER STATUS to find out appropriate binary log position. Be careful however – cloning slave from the slave also clones…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… not detected for a long period of time or not detected at all. We needed an active master/slave connection check. And… 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: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… 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… be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others. In… logs on the master are OK you can just run SHOW SLAVE STATUS on slave experiencing error and use CHANGE MASTER TO to re…
Comment: Getting use of Slave in MySQL Replication
February 15, 2007 By 15 Comments
I use another concept: On master, I issue SHOW MASTER STATUS after write, save File and Position to session variable and … the slave. So master is exclusively used for writting and slave for writting. With this concept, it could take long for the slave to catch up. Thus instead of MASTER_POS_WAIT(), there could be SHOW SLAVE STATUS and if (Master…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be a daunting task. This talk will show you how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from…% off the Regular Registration price. This offer won’t last long so register today!
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… synchronized. If we speak about backup and you can execute SHOW SLAVE STATUS command you can get reliable information about current state, but… they are stored on client side OS/NFS cache for long time. As solution we can do patch to execute fsync… available in error-log output, so you can repoint your slave to correct position by executing CHANGE MASTER command. Currently patch…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… the graphs you need. If you’re looking at SHOW INNODB STATUS this is how you can see Insert Buffer Size: Ibuf… of course their workload is very different. On one hand slave has all updates going from one thread so it has… slave for very long queries which may make long transactions reasons a lot more likely. So it can be both – either master or slave…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…rebuilds the whole table, it may last way too long for your 150 GB table! If you have …that table on a separate computer, maybe a replication slave. Can you make the reorganization run in a …lookups or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash …
