Announcement

Announcement Module
Collapse
No announcement yet.

Server shutdown problem

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Server shutdown problem

    Hi All,

    I shutdown our mysql server with service mysql shutdown as normal however I had this problem:

    110922 4:34:08 [Note] /usr/sbin/mysqld: Normal shutdown
    110922 4:34:08 [Note] Event Scheduler: Purging the queue. 0 events
    110922 4:34:10 InnoDB: Starting shutdown...
    110922 4:51:58 [Note] Plugin 'FEDERATED' is disabled.
    110922 4:52:04 InnoDB: Database was not shut down normally!
    110922 4:56:35 InnoDB: Starting an apply batch of log records to the database...

    This same issue also happened earlier today with a normal shutdown.

    What could be causing this?

    Thanks in advance

  • #2
    To elaborate on this I shut the server down normally with out any errors however when I start it starts doing recovery and I can't tell why.

    Comment


    • #3
      Does the error log say anything else at startup?

      What is your setting for:
      innodb_fast_shutdown

      You can try setting this variable to 0 (which you can change on a running server) to force InnoDB to perform a complete flush at shutdown (but note that that can take a lot of time if you have a large highly volatile database).

      Comment

      Working...
      X