On Wednesday 15 April 2009 17:24:21 Baron Schwartz wrote:
> Hi!
>
> I just blogged about this:
> http://www.mysqlperformanceblog.com/2009/04/15/how-to-decrease-inno
>db-shutdown-times/
>
> Short version:
>
> mysql> set global innodb_max_dirty_pages_pct = 0;
>
> and wait until Innodb_buffer_pool_pag
Hi!
I just blogged about this:
http://www.mysqlperformanceblog.com/2009/04/15/how-to-decrease-innodb-shutdown-times/
Short version:
mysql> set global innodb_max_dirty_pages_pct = 0;
and wait until Innodb_buffer_pool_pages_dirty is smaller. Then shut down.
On Wed, Apr 15, 2009 at 9:10 AM, Nico
Hi,
after many years that I've been using mysql (with almost all Innodb
tables) I still can't make myself a reason of the unbearably long
shutdown times: almost everytime it takes at least 4 minutes to stop
completely and to kill the process; sometimes I even had to kill -9
mysqld.
Currently
