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:

Goal

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.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.