Shulou(Shulou.com)06/01 Report--

When you start mysql at one time, you will not get up and report the following error:

[root@red2 fonts] # / etc/init.d/mysqld start

Starting MySQL..The server quit without updating PID file (/ opt/mysql/data/red2.pid). [FAILED]

1, the system is Red Hat Enterprise Linux Server release 5.8, the database is mysql 5.6.32, the hard disk size is 100g, and the memory is 4G.

2. It is suspected that there is not enough memory and disk. When I look at the memory, I find that there is available space in the memory. Check the hard drive and find that the root directory has been used up, and the available value is 0%.

3, at this time, there are two solutions, one is to add a hard disk, the other is to find a large file to delete. Because this database is a test database, there is not much data, so the second method is adopted.

4. Use the du-sh / * command to find the directory that takes up the largest amount of disk and find that the largest directory is the / var directory.

5, use the same method (du-sh / var/*) to find the largest file at one level and always find the largest file is / var/log/messages.1. We know that this file is the log information of the system, and there is no problem with the system.

So we just rm-rf / var/log/messages.1 to delete the file.

6, then start mysql again and find that it is up now.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.