… available for viewing over at percona.com. My apologies if we weren’t… to the lower-level slaves. You can also use the slave_compressed_protocol option in…plenty of other MySQL and OS-level status variables that you might want to …-running queries in the output of SHOW PROCESSLIST that might be a sign…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show_relaylog_eventsblogpercona.commanual Com_show_slave_hostsblogpercona.commanual Com_show_slave_statusblogpercona.commanual Com_show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_show_logs’, ’0′ ‘Com_show_master_status‘, ’105′ ‘Com_show_ndb_status‘, ’0′ ‘Com_show_new_master’, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One… master; slave1> source test.sql; slave1> start slave; slave1> show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Conclusion With the new GTID…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
…show slave status\G *************************** 1. row *************************** [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] With “–delay=10m” I’m asking the tool to lag the slave…this technique will be included natively: http://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… of slave thread in master logs at all. Here is some old post of mine about it: http://www.mysqlperformanceblog.com/2008… 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…
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… not new, it was taken from TransactionalReplication http://code.google.com/p/google-mysql-tools/wiki/TransactionalReplication patch and http://bugs…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… executed the looping statements and pick up a position from SHOW MASTER STATUS on the master still replicating, change the master with… 6: the slave position on the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4…://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…in http://bugs.mysql.com/bug.php?id=34058,…mysql-bin.000002 —round 2— show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | … error log (snipped): InnoDB: In a MySQL replication slave the last master binlog …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…smm.so datadir=/var/lib/mysql wsrep_slave_threads=2 wsrep_cluster_name=pxctest …21:19 Percona XtraDB (http://www.percona.com) 1.1.8-rel25.3 started; …you have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | …
