Re: Why is Mysqld is crashing every few hours
Posted by: Masud Akhtar Ahmed
Date: May 23, 2018 08:25AM


I had the same experiences before, through my frequent research I found the solution.

This could be happen due to two reasons:

mysqld is trying to write logs to the disk, which is full.
mysqld is trying to write logs to the file but it doesn't have appropriate permissions.

Here you see my system research and development result:

root@localhost:~$ service mysqld restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL............................................... ERROR! Manager of pid-file quit without updating
root@localhost:~$ service mysqld status
ERROR! MySQL is running but PID file could not be found

root@localhost:~$ /var/lib/mysql$ ps aux | grep -i mysql
root 1599 0.0 0.0 3712 1308 ? S May03 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/
mysql 1666 0.0 0.9 130000 19356 ? Sl May03 0:08 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/mysql-bin.err --pid-file=/var/lib/mysql/
root 11452 0.0 0.0 3224 776 pts/0 S+ 08:07 0:00 grep -i mysql

Then I Tried the following:

kill -15 1666
kill -15 1599
rm /var/lib/mysql/
rm /var/lib/mysql/

root@localhost:~$ service mysqld start

root@localhost:~$ service mysqld status

mysqld (pid 1556) is running...

Options: ReplyQuote

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.