Mysql Restart after every 5 seconds !!
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
Subject
Views
Written By
Posted
Mysql Restart after every 5 seconds !!
2348
November 05, 2013 04:01AM
840
November 05, 2013 07:09AM
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.