…show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show_relaylog_eventsblogpercona.commanual Com_show_slave_hostsblogpercona.commanual Com_show_slave…status…
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: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…/backup 6) Copy data to backup. Normally you can skip slow query logs and error log while taking backup. You also… 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: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
…Inada Naoki, DeNA Co., Ltd.) show_slave_status_nolock – Allows examination of slave status even when a lock prevents SHOW SLAVE STATUS from operating. (Oleg Tsarev) …Bug #676147 – The development environment test of option log_slow_slave_statements for row-based replication was not working correctly….
Post: Percona Server 5.1.54-12.5
January 11, 2011 By 9 Comments
…Kinoshita) Bugs Fixed Bug #689830 – The development environment tests of show_slave_status_nolock work only on statement-based replication. They were failing…#691234 – Boolean command line options and configuration variables in the slow_extended patch were not being processed properly. (Oleg Tsarev…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… performance (keeping data smaller) or can a bit slow it down. Plus there were bunch of micro … table on a separate computer, maybe a replication slave. Can you make the reorganization run in a … or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… graphs you need. If you’re looking at SHOW INNODB STATUS this is how you can see Insert Buffer Size:…max_purge_lag to make a threads doing modifications slow down if purge thread can’t keep up. This…likely. So it can be both – either master or slave can have it main tablespace growing larger than its…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… predecessor – to get more information about query execution logged into slow log, however the new version is loaded with a set… you to change that behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY EXECUTION Each query can… you to see many per-session statistics for operations with SHOW SESSION STATUS, but that does not include those of InnoDB, which…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE_THREAD]/’ > /tmp/report-slave.txt In the report you will…. 3) Processlist Polling This method is simple – the Slave thread has different status in Show Processlist depending on if it processes query or…
