{"id":126363,"date":"2023-03-06T09:40:49","date_gmt":"2023-03-06T09:40:49","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=126363"},"modified":"2024-09-02T06:08:11","modified_gmt":"2024-09-02T06:08:11","slug":"database-page-corruption-on-disk-or-a-failed-file-read-of-a-page-in-mysql","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/database-page-corruption-on-disk-or-a-failed-file-read-of-a-page-in-mysql\/","title":{"rendered":"Database Page Corruption on Disk or a Failed File Read of a Page in MySQL"},"content":{"rendered":"

One of the important tasks of IT administrators is to constantly verify and check the hard disks. If there is any issue, they need to replace the hard drives to make sure that the database is fine.<\/p>

If the hard disk gets damaged, it may affect the pages in MySQL. The pages in MySQL are units to store data in databases. Other factors that can affect the hard drive are software problems and malware attacks on the system.<\/p>

Verify MySQL Database Page using the CHECKSUM Command<\/h2>

CHECKSUM is a command in MySQL that can be used to verify if the database is fine. This command checks the integrity of the database.<\/p>

The following example shows how to use the CHECKSUM command:<\/strong><\/p>

CHECKSUM TABLE StellarTable<\/strong><\/p>

Note:<\/strong> This function is slow because it works row-by-row.<\/p>

Verify MySQL Database Page using the Mysqlcheck Command<\/h2>

Mysqlcheck command not only works with a single table but also with the entire database. With this command, you can not only check but also repair a database. The following example shows how to check a database named stellardb using this command.<\/p>

mysqlcheck --check stellardb<\/code><\/strong><\/p>

Optionally, you can use the -c option (see the below example).<\/p>

mysqlcheck -c stellardb<\/code><\/strong><\/p>

If you want to check multiple databases, you can use the following command:<\/p>

mysqlcheck --check --all-databases<\/code><\/strong><\/p>

Note:<\/strong> If you have huge database or several databases, this command may take a long time.<\/p>

How to repair database page corruption using the mysqlcheck command?<\/h2>

The following example shows how to repair a MySQL database named stellardb using the mysqlcheck command.<\/p>

mysqlcheck --repair stellardb<\/code><\/strong><\/p>

How to repair database page corruption using the repair command?<\/h2>

In addition, you can use the REPAIR command to repair a specific table in MySQL. The following example illustrates how to repair a table named StellarTable using this command:<\/p>

REPAIR TABLE StellarTable;<\/code><\/strong><\/p>

The REPAIR TABLE command has multiple options. The first option is to run Quick. This is a fast repair option. The following example shows the faster way to repair the table using the REPAIR TABLE command:<\/p>

REPAIR TABLE StellarTable quick;<\/code><\/strong><\/p>

You can also use the EXTENDED option. This option is slower. Use this option, if the damage is severe and the QUICK option did not work.<\/p>

REPAIR TABLE StellarTable EXTENDED;<\/code><\/strong><\/p>

In addition, there is recover option which is used for crashed databases.<\/p>

REPAIR TABLE StellarTable RECOVER;<\/code><\/strong><\/p>

The USE_FRM option can be used to use the file with frm extension to rebuild the table structure. If your table is corrupted and the frm file is fine, this option will work.<\/p>

The frm files contain the table definition of a table.<\/p>

REPAIR TABLE StellarTable USE_FRM;<\/code><\/strong><\/p>

Finally, there is FORCE option that continues repairing even if there are errors during the execution. Some errors that are ignored by the FORCE command are duplicated keys, record-size errors, problems with the index merge, keys out of order, and connection loss.<\/p>

REPAIR TABLE StellarTable FORCE;<\/code><\/strong><\/p>

The Log File<\/h2>

The error.log can be used to verify database corruption problems.<\/p>

The following command will show you the location of the error.log.<\/p>

SHOW VARIABLES LIKE 'log_error';<\/code><\/strong><\/p>

Once you are there, search for phrases like page corruption and page wrong in the file.<\/p>

Use Stellar Repair for MySQL<\/h2>

If the above options fail to fix the corruption, then you can use a third-party software, such as Stellar Repair for MySQL<\/a> – a software specialized in repairing corrupt databases.<\/p>

This software works for MySQL and MariaDB. It is compatible with Windows OS (servers and workstations) and also the following Linux versions:<\/p>