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 MAY 23, 2022

Applies to:

MySQL Cluster - Version 7.2 and later
MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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