Bonjour Heikki,
HT> InnoDB will flush the buffer pool and do the purge of old versions
HT> at shutdown. It does these operations also when the database is
HT> running, but there may be remaining work to do at shutdown.
HT> How is the load of your database when you are running it?
HT> Does mysqld say?
HT> InnoDB: Starting shutdown...
HT> <then the time passes>
HT> InnoDB: Shutdown completed
Here is an example :
010514 16:08:56 /usr/local/mysql/libexec/mysqld: Normal shutdown
010514 16:08:56 Aborted connection 127 to db: 'cotations' user: 'dbuser' host:
`localhost' (Got timeout reading communication packets)
010514 16:08:56 Aborted connection 385 to db: 'cotations' user: 'root' host:
`localhost' (Got timeout reading communication packets)
010514 16:08:56 Aborted connection 384 to db: 'cotations' user: 'root' host:
`localhost' (Got timeout reading communication packets)
010514 16:11:41 /usr/local/mysql/libexec/mysqld: Forcing close of thread 416 user:
'root'
010514 16:11:41 /usr/local/mysql/libexec/mysqld: Forcing close of thread 407 user:
'root'
010514 16:11:41 /usr/local/mysql/libexec/mysqld: Forcing close of thread 385 user:
'root'
010514 16:11:41 /usr/local/mysql/libexec/mysqld: Forcing close of thread 384 user:
'root'
010514 16:11:41 /usr/local/mysql/libexec/mysqld: Forcing close of thread 109 user:
'dbuser'
010514 16:11:41 Aborted connection 109 to db: 'cotations' user: 'dbuser' host:
`localhost' (Got an error writing communication packets)
010514 16:12:49 Aborted connection 416 to db: 'cotations' user: 'root' host:
`localhost' (Got an error writing communication packets)
010514 16:12:55 Aborted connection 407 to db: 'cotations' user: 'root' host:
`localhost' (Got an error writing communication packets)
InnoDB: Starting shutdown...
<time passes too here. It would be great to have time reported in
the Starting shutdown and Shutdown complete isn't it ? >
InnoDB: Shutdown completed
010514 16:23:37 /usr/local/mysql/libexec/mysqld: Shutdown Complete
010514 16:23:37 mysqld ended
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
