How To Compare Table Data Among Different Storage Engines or Versions / Calculating Logical Table Checksum on MySQL Server / CHECKSUM TABLE Alternative
(Doc ID 2825516.1)
Last updated on JUNE 19, 2023
Applies to:MySQL Cluster - Version 7.2 and later
MySQL Server - Version 5.5 and later
Information in this document applies to any platform.
This document describes how to compare table data among different storage engines. MySQL Server has the command to calculate a checksum of table data; CHECKSUM TABLE. However, CHECKSUM TABLE produces checksum values based on physical data in tables. This causes different checksum values among different storage engines, or different versions. This document describes how to calculate storage engine or version independent table checksum values.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document