…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 18 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 10 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 3 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 21 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: 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 |…it can be both – either master or slave can have it main tablespace growing…
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… 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: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY …many per-session statistics for operations with SHOW SESSION STATUS, but that does not include those … # InnoDB_pages_distinct: 20 SET timestamp=1193841780; SELECT DISTINCT c from sbtest where id between…
