My Oracle Support Banner

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

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