mysql| Data | Database Ideally, MySQL has been running smoothly since the first installation. Sometimes, however, problems can occur for a variety of reasons, ranging from power outages to hardware failures to abnormally shutting down MySQL servers (
The first is the fastest, which is used to fix the most common problems, and the last is the slowest, which is used to fix problems that cannot be fixed by other methods.Check and repair MySQL Data FilesIf the above method cannot repair a damaged
Introduction of Mysqlcheck
The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables.
Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD
The first is the fastest, to fix the most common problems, and the last one is the slowest to fix problems that some other methods cannot fix. Review and repair MySQL data filesIf the above method cannot fix a damaged table, you can try these two
0x001 Issue BackgroundMySQL executes the relevant MySQL command (we performed, show procedure status) When prompted Mysql.proc table crashed, cannot be repaired (marked as crashed and last (automatic?) Repair failed)Error message: MySQL table is
One: MySQL myisam table damage Reason summary:
1, the server suddenly power off causing data file corruption, forced shutdown, did not first shut down the MySQL service; the mysqld process was killed while writing the table.2, disk damage.3, the
MYSQL checks the data table and repairs the data table. when the database is running, data corruption may occur due to human factors or some force majeure factors. Therefore, to protect data security and minimize downtime, we need to develop a
The following article describes how to correctly check and maintain the MySQL database table, as well as the specific descriptions of the matters worth your attention in the actual operations of checking and maintaining MySQL database tables, we
I. Summary of the causes of MyISAM Table Corruption in MySQL:
1. The data file is damaged due to a sudden power failure on the server. The mysql service is forcibly shut down without being shut down first. The mysqld process is killed when writing a
This article mainly introduces mysql table optimization, analysis, check and repair methods, and analyzes MySQL table optimization in detail in the form of instances, various common commands and usage skills for analysis and repair operations. you
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.