…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…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… the 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…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…SELECT * FROM tbl1 INFO OUTFILE ‘/tmp/tbl1.txt’; LOAD DATA INFILE ‘/tmp/tbl1.txt’ INTO TABLE tbl2; instead of: INSERT INTO tbl2 SELECT * from…show how wait caused by this statement will look in SHOW INNODB STATUS…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…Slave to Master we will need to do some steps to enable all the events replicated from…all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql>…a master-master setup a master can show a wrong ‘SHOW SLAVE STATUS‘ output when using SET user-variables…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…select * from antest; Query OK, 245760 rows affected (54.29 sec) Records: 245760 Duplicates: 0 Warnings: 0 mysql> show index from…status | OK | +——————–+———+———-+———-+ 1 row in set (0.00 sec) mysql> show index from…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G ***************************…) Processlist Polling This method is simple – the Slave thread has different status in Show Processlist depending on if it processes …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… reorganizing that table on a separate computer, maybe a replication slave. Can you make the reorganization run in a tolerable time… primary key lookups or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987… pool? PZ: I guess it may be bug in the status or bug in implementation. I’ll check with Alexander or…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
…. If you’re looking at SHOW INNODB STATUS this is how you can see … the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_… different. On one hand slave has all updates going from one thread so it…
