Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about abnormal mysql5.7.21 startup. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Troubleshooting process:

In the earliest startup message, there are no errors, only a line of [ERROR] Aborting prompt, as follows:

Then my colleagues used the innodb_force_recovery=6 method, and there were more than the following error prompts, but still could not start successfully, at this time, I decided to take a look.

Filter startup log, grep ERROR / data/mysql/3306/mysql_run.err

As you can see, all the errors are as follows:

Most of the reasons why MySQL cannot be started are due to the system database, and this seems to be no exception.

Try to log in to the system with-- skip-grant-tables, and it turns out to be successful.

/ usr/local/mysql/bin/mysqld_safe-defaults-file=/data/mysql/3306/my.cnf-user=mysql-skip-grant-tables &

Then, check the innodb as soon as possible and execute:

Innochecksum ibdata1

It was found that there was no output.

Then mysqlcheck was executed, and sure enough, some of the table errors under the mysql library were fixed. The system is then rebooted in a normal manner and the MySQL returns to normal.

Mysqlcheck-u root-p-- repair-A

Summary:

1. MySQL is not that fragile, and it is not necessary to restore it by backup and recovery when it is damaged, which is time-consuming and laborious.

2. During startup, you can set-skip-grant-tables or innodb_force_recovery (this parameter is to modify the cnf file) to let MySQL skip some checks to make the instance start successfully.

3. After startup, you can perform data backup or export data, and try to repair the instance

4. This problem occurs in this example because Huai Ning is related to the improper parameter setting of real-time disk storage.

This is the end of the article on "what to do with abnormal mysql5.7.21 startup". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.