…also lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 is behind s1> select count(*) from t; +———-+ | count(*) | …the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…download from our repositories. Benchmark showing the impact of memory allocators…replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo … which does not honor wsrep status codes correctly. Bug fixed #1144911 (…Prabhu). In case CREATE TABLE AS SELECT statement was running in parallel…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…pagesblogpercona.commanual innodb_status_fileblogpercona.commanual …Select_rangeblogpercona.commanual Select_range_checkblogpercona.commanual Select_scanblogpercona.commanual server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 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…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status…use `test`; insert into test.ins select * from test.t *************************** 6. row ***************************…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…slave by truncating t1. After truncation: select count(*) from t1 as empty_table_on_the_slave; +———-+ | count(*) | …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…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… READ LOCK actually waits for all statements to complete, even selects. So be careful if you have any long running queries… 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: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… to create the function on your slave the replication will be broken. After executing a SHOW SLAVE STATUS you will see a message like… itself. So all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t…/860910. In a master-master setup a master can show a wrong ‘SHOW SLAVE STATUS‘ output when using SET user-variables and then using…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… is running INSERT .. SELECT statement. This would make this transaction to be applied on the slave before INSERT… SELECT statement and possibly result… complete this article I should show how wait caused by this statement will look in SHOW INNODB STATUS: —TRANSACTION 0 42304626, ACTIVE 14…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
…detect cluster nodes. My DSNs table contains: node4000> SELECT * FROM percona.dsns; +—-+———–+———————–+ | id | parent_id | dsn | +—-+———–+———————–+ | 1 | …nodes because SHOW SLAVE STATUS on a cluster node doesn’t work (because a node isn’t a slave) and…
