Linux > Plesk

Unable to start MySQL because of lack of RAM: mysqld dead but subsys locked

(1/1)

vichithrakumart:
The following error is shown when querying the status of the service:


--- Code: ---# service mysqld status
mysqld dead but subsys locked
--- End code ---

it is required to remove /var/lock/subsys/mysqld file, free up some memory and start MySQL.

1. Log into the server via SSH

2. Remove /var/lock/subsys/mysqld file:


--- Code: ---# rm -f /var/lock/subsys/mysqld
--- End code ---

3. Check the amount of free memory with free -m command. In case there is more then 200M free, skip this step. In case amount of free memory is low, kill processes that consumes most of the memory. For example, stop the Apache temporary:


--- Code: ---# service httpd stop
--- End code ---

4. Try to start MySQL:


--- Code: ---# service mysqld start
--- End code ---

5. In case Apache is stopped on step 3, start it back:


--- Code: ---# service httpd start
--- End code ---

Navigation

[0] Message Index