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.
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.