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 Sabbi <nicola.sa...@poste.it> wrote: > 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 I'm running 150 databases, 12415 tables 1694 users > and 173682 grants. > > The servers are configured to use 1GB of innodb_buffer_pool_size, > innodb_log_buffer_size =8M > innodb_log_file_size =5M > out of 4 GB available. Both run on hardware scsi raid. > > What does the shutdown times depend on, and how can I reduce it? > > > Thanks, > Nico > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com > > -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
