inwl#6045we improved theinnochecksum tool so that it opens the tablespace file and validates the checksum for each page. it compares the calculated checksum to the stored checksum in the page and reports mismatches, if any. it can also now rewrite page checksums in the tablespace. it is an offline tool, however, so make sure that the mysql server is not using the tablespace files when running the innochecksum tool.
When InnoDB encounters a page checksum mismatch, it will cause an ASSERT and perform a forced shutdown. So rather than wait for InnoDB to encounter this in production, it is better to use the innochecksum tool to validate and correct any checksum issues ahead of time. You could perform these checks on yourMySQL Enterprise Backupfiles after a backup job completes, as an example.
Again, the innochecksum tool cannot be used on tablespace files that the server already has open. When the MySQL server is running, you can instead use theCHECK TABLEcommand.
Additional new features introduced in MySQL 5.7 for this tool include:
Conclusion
This post provided a brief introduction to the new features recently introduced in the innochecksum tool. For more information on the tool, please see the manualhere.
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号