… with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The… shutdown time of about 1min per GB of buffer pool per hard drive. Baron has written a nice post how to decrease innodb shutdown time…
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 19 Comments
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages … even slower in stock InnoDB than the shutdown process, for a variety of reasons. One way to decrease the shutdown time is to pre-flush the dirty pages, like this: mysql> set global innodb_max_dirty_pages_pct…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
The feature I announced some time ago http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is… completed 090730 23:23:35 InnoDB: Rollback of non-prepared transactions completed 090730 23:25:32 InnoDB: Shutdown completed; log sequence number 3…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…. That is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate… –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex… going to save a lot of time and some headaches 
Instead of recovering all the InnoDB data we are going to recover…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
…. (Oleg Tsarev) Â innodb_fast_shutdown – Sleeping threads could cause a delay of up to 10 seconds during InnoDB shutdown. The sleeping state of…) Other Changes: None Bugs Fixed Bug #640576 – The false error “innodb_extra_undoslots option is disabled but it was enabled before… #673562 – Debug build was broken due a to failing compile-time assertion in mysqld.cc. (Alexey Kopytov) Bug #673567 – Compiler could…
Comment: How long Innodb Shutdown may take
September 2, 2010 By 8 Comments
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… crash recovery. Is there any good way to know when InnoDB is shutdown when MySQL is not yet?
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
… Pachev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg …innodb_doublewrite_file. (Yasufumi Kinoshita) Bug #643650 – Speeded up InnoDB shutdown when using shared memory buffer pool. (Yasufumi Kinoshita) Bug #643724 – Fixed an InnoDB…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… annoyance I see is that if you shutdown one node for short period of time for quick maintenance, after start, the node… for now is support of InnoDB-plugin, which as we know performs much better than standard InnoDB ®. So what is so interesting… independent, and it’s only matter of database drivers. For InnoDB currently it is set of patches, and I see it…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs…start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL first, then unmount the logical volume … cannot test restore your snapshots – they are one time use! However, if you can tolerate the …
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
… doing a basic insert into an InnoDB table. My database class starts a …attempting to insert takes 50 seconds to time-out with a “1205 – Lock wait …_in_progress = true; register_shutdown_function(array($this, “__shutdown_check”)); } public function __shutdown_check() { if ($this->transaction_in_…
