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