1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

mysql restarts

Discussion in 'Plesk for Linux - 8.x and Older' started by denhams, Mar 13, 2006.

  1. denhams

    denhams Guest

    0
     
    Hi,

    I'm running Plesk 7.5.4 (Linux). I've noticed that every now and again (3 or 4 times a day?) mysql restarts. The message in the mysqld.log file is below.

    I can see no reason for this. I've run mysql on other (non-Plesk) servers and it has always run 24x7 without restarting.

    I've already reinstalled the server once and have not changed my.cnf. Everything (including the databases) seems to work ok.

    Any ideas what might be happening?

    Regards,

    Stephen.



    Number of processes running now: 0
    060313 07:17:59 mysqld restarted
    060313 7:18:03 InnoDB: Out of memory in additional memory pool.
    InnoDB: InnoDB will start allocating memory from the OS.
    InnoDB: You may get better performance if you configure a bigger
    InnoDB: value in the MySQL my.cnf file for
    InnoDB: innodb_additional_mem_pool_size.
    060313 7:18:14 InnoDB: Database was not shut down normally.
    InnoDB: Starting recovery from log files...
    InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 638632
    InnoDB: Doing recovery: scanned up to log sequence number 0 638632
    060313 7:18:17 InnoDB: Flushing modified pages from the buffer pool...
    060313 7:18:19 InnoDB: Started
    /usr/libexec/mysqld: ready for connections
     
  2. wagnerch

    wagnerch Guest

    0
     
    Are you running watchdog? If so then dump it, alot of other people have said it restarts services for no apparent reason.
     
  3. denhams

    denhams Guest

    0
     
    Well, I wasn't running the watchdog but installed it later as I thought it might help!

    In the end I upgraded mysql to version 4 (from 3) and the problem seems to have gone away (so far!).

    I've still no idea what was causing version 3 to restart.

    Regards,

    Stephen.
     
  4. wagnerch

    wagnerch Guest

    0
     
    Hmm, odd. I am using mysql3 and it is solid.
     
Loading...