List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:May 14 2001 2:54pm
Subject:Re[2]: Mysql shutdwon very long
View as plain text  
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

Thread
Bug in CAPI of My SqlVVM Ravikumar Sarma Chengalvala13 May
  • Re: Bug in CAPI of My SqlSinisa Milivojevic13 May
    • Re: Bug in CAPI of My SqlVVM Ravikumar Sarma Chengalvala14 May
      • Re: Bug in CAPI of My SqlSinisa Milivojevic14 May
        • Re: Bug in CAPI of My SqlVVM Ravikumar Sarma Chengalvala14 May
          • Re: Bug in CAPI of My SqlSinisa Milivojevic14 May
            • Mysql shutdwon very longBAUMEISTER Alexandre14 May
            • Re: Bug in CAPI of My SqlVVM Ravikumar Sarma Chengalvala14 May
              • Re: Bug in CAPI of My SqlSinisa Milivojevic15 May
            • my sql_escape_string()--Bug?VVM Ravikumar Sarma Chengalvala14 May
              • Re: my sql_escape_string()--Bug?Sinisa Milivojevic15 May
Re:Mysql shutdwon very longHeikki Tuuri14 May
  • Re[2]: Mysql shutdwon very longBAUMEISTER Alexandre14 May