Bug #78733 CHECKSUM PARTITION

Submitted: 7 Oct 2015 11:01 Modified: 7 Oct 2015 11:03
Reporter: Daniël van Eeden Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: checksum, partitioning

[7 Oct 2015 11:01] Daniël van Eeden
Description:
CHECKSUM TABLE my_partitioned_table EXTENDED now returns one number.

It would be nice if I could do CHECKSUM PARTITIONS my_partitioned_table which then would show a per partition checksum, making it easier and more useful for situations where:
 - There is just one partition with has wrong data (e.g. after table copy to another server). Then that partition can be recopied to fix the issue.
 - When the table as one constantly changing active partition. Then the 'old' partitions can be checked more easily.

How to repeat:
See Description.
[7 Oct 2015 11:03] Daniël van Eeden
Work around for a table with 32 partitions:
for i in {0..31}; do echo "p${i}"; sudo mysql mydb -BNe "SELECT * FROM mytable1 PARTITION(p${i})" | md5sum; done | tee checksum.txt

Then the checksum.txt from source and target can be compared.
[18 Jun 2016 21:28] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.