MySQL server shutting down rapidlly please help!!

hostmk

Registered
Oct 14, 2013
1
0
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,260
463
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:

130506 20:18:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,260
463
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.