Global Transactions Identifiers are one of the new features regarding replication … not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere… by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… the receive queue (visible via the wsrep_local_recv_queue global status variable). Donor/Desynced nodes do not apply flow control, though… happening and where it is coming from There are two global status variables you can check to see what flow control is… fraction of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control is effect, regardless of which node caused…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…- Start the new slave from that GTID position: slave1 > SET GLOBAL gtid_purged=”c777888a-b6df-11e2-a604-080027635ef5:1-4″; slave1…=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this… you’re writing scripts to look at SHOW INNODB STATUS it is much better to use global counters and get averages manually. They… which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS, such as statement which is being executed, query id, query status etc. Next section…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… go over some of the status variables and metrics being tracked there with the aim to show folks what they should be… before, myq_status gives an iostat-like output of your server. This tool takes what are usually global counters in SHOW GLOBAL STATUS and calculates… — This is the amount of time since the last time SHOW GLOBAL STATUS was run that replication was paused due to flow control…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
… | | 888ba838661aff00bbbce114a2a22423 | +———————————-+ 2 rows in set (0.39 sec) mysql> show status like “Handler%”; +—————————-+——-+ | Variable_name | Value | +—————————-+——-+ | Handler_commit | 0 | | Handler… can do FLUSH STATUS to reset counters run the query (assiming your system does not do anything) and run SHOW STATUS to see… not have to any more. SHOW STATUS now will show per session counter increments and to get global counters SHOW GLOBAL STATUS needs to be used. Let…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
… is called when you run SHOW INNODB STATUS and SHOW STATUS. In this case for same of monitoring SHOW GLOBAL STATUS was run every couple of seconds… pile up waiting on locked innodb buffer pool mutex, so SHOW STATUS shows high number of running threads. This theory can be confirmed… happy to give up Innodb_buffer_pool_pages_latched n SHOW STATUS output
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… should check if you have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size… /usr/share/haproxy user haproxy group haproxy daemon defaults log global mode http option tcplog option dontlognull retries 3 option redispatch…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…, but it is not how it happens in practice. mysql> show global status like “key%”; +————————+———+ | Variable_name | Value | +————————+———+ | Key_blocks_not_flushed | 6516… so what if we set key buffer to 128M ? mysql> show global status like “key%”; +————————+———+ | Variable_name | Value | +————————+———+ | Key_blocks_not_flushed | 49361…
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
… ‘vadim’@'localhost’; and under user ‘vadim’ Before query execution: mysql> show global status like ‘qcache%’; +————————-+———-+ | Variable_name | Value | +————————-+———-+ | Qcache_free_memory | 67091176 | | Qcache…; +——+ | id | +——+ | 5 | +——+ 1 row in set (0.00 sec) mysql> show global status like ‘qcache%’; +————————-+———-+ | Variable_name | Value | +————————-+———-+ | Qcache_free_memory | 67089640 | | Qcache…
