The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL server shutting down rapidlly please help!!

Discussion in 'Database Discussions' started by hostmk, Oct 14, 2013.

  1. hostmk

    hostmk Registered

    Joined:
    Oct 14, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,The mysql server shutting down rapidlly.
    My /etc/my.cnf
    Please help me,I run 10 websites

    VPS specs
    1 GB Dedicated memory
    40 GB Disk space
    1000 GB Monthly bandwidth
    1GBit/s node Internet port
    [mysqld]
    innodb_file_per_table=1
    open_files_limit=65000

    here is my errror log

    130506 20:18:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130506 20:18:29 [Note] Plugin 'FEDERATED' is disabled.
    130506 20:18:29 InnoDB: Initializing buffer pool, size = 8.0M
    130506 20:18:29 InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    130506 20:18:29 InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    130506 20:18:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    130506 20:18:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    130506 20:18:29 InnoDB: Started; log sequence number 0 0
    130506 20:18:29 [Note] Event Scheduler: Loaded 0 events
    130506 20:18:29 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.68-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    130506 20:18:31 [Note] /usr/sbin/mysqld: Normal shutdown

    130506 20:18:31 [Note] Event Scheduler: Purging the queue. 0 events
    130506 20:18:31 InnoDB: Starting shutdown...
    130506 20:18:35 InnoDB: Shutdown completed; log sequence number 0 44233
    130506 20:18:35 [Note] /usr/sbin/mysqld: Shutdown complete

    130506 20:18:35 mysqld_safe mysqld from pid file /var/lib/mysql/server.host-mk.me.pid ended
    130506 20:18:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130506 20:18:35 [Note] Plugin 'FEDERATED' is disabled.
    130506 20:18:35 InnoDB: Initializing buffer pool, size = 8.0M
    130506 20:18:35 InnoDB: Completed initialization of buffer pool
    130506 20:18:35 InnoDB: Started; log sequence number 0 44233
    130506 20:18:35 [Note] Event Scheduler: Loaded 0 events
    130506 20:18:35 [Note] /usr/sbin/mysqld: ready for connections.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,776
    Likes Received:
    663
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you verify that those same messages appear in your MySQL error log every time it's restarted? In particular, I am referring to:

    Also, could you elaborate on what's happening with MySQL? For instance, does it restart automatically, or is it simply failing consistently every few minutes?

    Thank you.
     
  3. hostmk

    hostmk Registered

    Joined:
    Oct 14, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,
    Here is all my log file please get it and loook up there more good,when the mysql shutdowns than dont start anymore just when i restart or reboot my root or mysqld server
    View attachment mysql server error logs.txt


    Thanks
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,776
    Likes Received:
    663
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You may want to review the active MySQL processes to see if there are any databases that are using up your resources. You can check this with a command such as:

    Code:
    mysqladmin processlist
    Thank you.
     
Loading...

Share This Page