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 2 Comments
… 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 …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…make this transaction to be applied on the slave before INSERT… SELECT statement and possibly result…not cause long enough locks to cause the problems. To complete this article I should show how wait caused by this statement will look in SHOW INNODB STATUS: —TRANSACTION 0 …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…Would this be related to long INNODB recovery time, to…) 080625 23:53:28 [Note] Slave SQL thread initialized, starting replication…master of 1a mysql> show master status; +————+———-+——————————————-+——————+ | File | Position | Binlog_Do_DB | Binlog_…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… those which take less than 1s. Now long_query_time is in microseconds and you …that behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY EXECUTION …see many per-session statistics for operations with SHOW SESSION STATUS, but that does not include those of…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… 2 rows in set (53.78 sec) session10 > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables …long running transaction. As the slave tried to execute the rename query it would simply block waiting for the long…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… statement level replication. You need to set long_query_time=0 and log_slave_slow_statements=1 for this method to work…. 3) Processlist Polling This method is simple – the Slave thread has different status in Show Processlist depending on if it processes query or…, so the master writes more binary logs than slave can process they will show number close to 1. the method 4 however…
