… 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… zero.) Once it’s pretty low, you can perform the shutdown and there’ll be a lot less unfinished work to…
Post: How long Innodb Shutdown may take
September 2, 2010 By 8 Comments
… 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…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… to keep the InnoDB buffer pool in memory between restarts of MySQL servers. This can result in a significant decrease in warmup… variable innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use… rows to be purged. Bug #607449 – Fixes a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with…
