MySQL Forums
Forum List  »  InnoDB

Mysql Restart after every 5 seconds !!
Posted by: shahzaib cb
Date: November 05, 2013 04:01AM

Our server was crashed 2 days ago and after reboot mysql is keep on restarting with every 5 seconds. Following is mysqladmin status :

Uptime: 4 Threads: 1 Questions: 2 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.500

Following is the mysqld.log which is keep popping up the following error :

131105 12:51:53 mysqld_safe Number of processes running now: 0
131105 12:51:53 mysqld_safe mysqld restarted
131105 12:51:53 InnoDB: Initializing buffer pool, size = 64.0M
131105 12:51:53 InnoDB: Completed initialization of buffer pool
131105 12:51:53 InnoDB: Started; log sequence number 0 44233
131105 12:51:53 [Note] Event Scheduler: Loaded 0 events
131105 12:51:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution


/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
innodb_buffer_pool_size=64M
query_cache_size=16M
thread_cache_size=8
max_allowed_packet=16M
wait_timeout=600
net_read_timeout=600
max_connect_errors=5000
#innodb_force_recovery=1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


I am using zpanel for this vps. Also Ram is not the issue for it.

Regards.
Shahzaib

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Restart after every 5 seconds !!
2348
November 05, 2013 04:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.