Thank you for your help! If the status of the bug report you submitted changes, you will be notified. You may return here and check on the status or update your report at any time. That URL for your bug report is: http://bugs.mysql.com/85119.
Bug #85119 Innodb needs an instant checksum.
Submitted: 22 Feb 2017 3:08 Modified: 15 Mar 2022 15:38
Reporter: yun chen Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.6 5.7 OS:Any
Assigned to: CPU Architecture:Any

[22 Feb 2017 3:08] yun chen 
Description:
Our business has a heavy use of mysql, from master-slave, HA group , to self sharded-routed mysql cluster, mysql group replication(dev and test). An eager requirement is in shrink, scale or rebalance, redo cases, how can we make a quick check about data consistency. 
The original "checksum table xxx" is full-table and very slow. 
So I am wondering the possibility of some thing like 'checksum table xxx instant'. 
Below is an immature idea: 
<0> some conf item like 'instant-checksum = true' in my.cnf. requirements: gtid, innodb. 

<1> first mysql startup phase: 
a new table mysql.checksums (id, table_name, schema_name, gtid_set, value, created_at, updated_at) 
fill mysql.checksums with 'checksum table xxx' concurrently, it may be very slow. 
<2> transaction goes on phase: 
DDL case: 
create table: insert mysql.checksums 
drop table: delete mysql.checksum or set value to NULL 
alter table column: update value with 'checksum table xxx', it may be slow. 
alter table column type/column name, alter table character set: may be no need to do anything. 
DML case: 
insert: add row-crc of this row without carry. 
update: add after-row-crc and decrease before-row-crc without carry 
delete: decrease before-row-crc without carry. 
I think there will be a performance decrease , but it's acceptable in my case, at least. 
I also think this feature is very useful to make new feature like 'group replication' popular, for people can check consistency without pain.

How to repeat:
checksum table xxx is very slow.
[14 Mar 2017 3:06] yun chen 
Anyone cares?
[15 Mar 2022 15:38] MySQL Verification Team 
HI Mr. chen,

Unfortunately, your idea is not feasible.

Your idea would actually take much more time then the current checksum command.

Actually, off-line checksum utility is very , very fast ......

Not a viable feature request.