Manager of PID-Files

[petterm]

Hi guys

Will you please check why such kind of error is generated : "Manager of pid-file quit without updating fi"

Guys if any one has any idea do let me know for the same.

[Jeffrey]

Originally Posted by petterm

Hi guys

Will you please check why such kind of error is generated : "Manager of pid-file quit without updating fi"

Guys if any one has any idea do let me know for the same.

I think this will defiantly help you for the solution and the below mentioned is as follows.
: When the user try to restart the mysql service on the server then above error is generated.

Such problem is being occurred due the “mysql ”. Some time the database do crashed and the user could be repaired . On the other hand the mysql is already got stopped on the server so we have to use some of the following command to repair and optimize the database when mysql service is down on the server.

If you want to Repair the “mysql ” database :
# find /var/lib/mysql/mysql -name '*.MYI' -exec myisamchk -r {} \;

The below mentioned stuff is For Optimize the complete database :
# find /var/lib/mysql -name '*.MYI' -exec myisamchk -o {} \;

[rocky123]

Originally Posted by Jeffrey

I think this will defiantly help you for the solution and the below mentioned is as follows.
: When the user try to restart the mysql service on the server then above error is generated.

Such problem is being occurred due the “mysql ”. Some time the database do crashed and the user could be repaired . On the other hand the mysql is already got stopped on the server so we have to use some of the following command to repair and optimize the database when mysql service is down on the server.

If you want to Repair the “mysql ” database :
# find /var/lib/mysql/mysql -name '*.MYI' -exec myisamchk -r {} \;

The below mentioned stuff is For Optimize the complete database :
# find /var/lib/mysql -name '*.MYI' -exec myisamchk -o {} \;

if the above things you have updated, make sure that you still have to few stuff you have to execute, with out which you would unable to do so which is as follows.

# ps -ef | grep mysql
# killall -KILL mysql
# /etc/init.d/mysql stop
# /etc/init.d/mysql start