I have a somewhat tangential topic about InnoDB shutdown. I have a number of servers which in the somewhat … leak memory. MySQL on these servers takes a very long time to shutdown. Recently we “kill -9″ an instance long after it…. Is there any good way to know when InnoDB is shutdown when MySQL is not yet?
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… Tsarev)  innodb_fast_shutdown – Sleeping threads could cause a delay of up to 10 seconds during InnoDB shutdown. The sleeping state…€œgcc atomic built-in†function isn’t provided, so response_time_distribution now uses the native atomic API on FreeBSD. (Oleg… #673562 – Debug build was broken due a to failing compile-time assertion in mysqld.cc. (Alexey Kopytov) Bug #673567 – Compiler could…
Comment: How to decrease InnoDB shutdown times
April 16, 2009 By 20 Comments
… the application online and responding for some portion of that time, while dirty pages are flushed from the buffer pool. The… of time that the server is *actually* shutting down and restarting, by *preparing* it for shutdown. Kevin, can you post your shutdown script…
Comment: Mystery Performance Variance with MySQL Restarts
February 21, 2013 By 18 Comments
This definitively adds more spice to performance tuning. Is the shutdown + restart part of the same script, in which case this… does this happen also with a manual shutdown and manual restart (with presumably some idle time in between) ? Not an explanation by…
Comment: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… I’ve written, part of openark-kit, called oak-prepare-shutdown, which safely closes down replication (verifying no temporary tables remain… be: oak-prepare-shutdown –user=root –ask-pass -v && /etc/init.d/mysql stop I did not have time yet to write…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
The feature I announced some time ago http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible-… going to do it online, no needs to lock or shutdown server. To export table you need XtraBackup, and you can… of non-prepared transactions completed 090730 23:25:32 InnoDB: Shutdown completed; log sequence number 3 852825486 When it’s done…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…), ‘# User@Host: ‘, user_host, CHAR(10), ‘# Query_time: ‘, TIME_TO_SEC(query_time), ‘ Lock_time: ‘, TIME_TO_SEC(lock_time), ‘ Rows_sent: ‘, rows_sent, ‘ Rows_examined…_time), ‘;’, CHAR(10), IF(FIND_IN_SET(sql_text, ‘Sleep,Quit,Init DB,Query,Field List,Create DB,Drop DB,Refresh,Shutdown,Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual…_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads_runningblogpercona.commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona.commanual timestampblogpercona.commanual tmp_table_sizeblogpercona.commanual…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… power can go down which all mean similar things – MySQL Shutdown is unexpected and there could be various inconsistences. And this… make sure all improperly closed MyISAM tables are checked first time it is accessed. This option is however rather painful to… honest “try again later” message, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… is enabled. (Oleg Tsarev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev) innodb… a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an incorrect time. Bug #610525…
