From 51a66299f3f34947baee2cf39fc9c25f01baab19 Mon Sep 17 00:00:00 2001 From: Daniel Black Date: Fri, 18 Mar 2016 11:50:41 +1100 Subject: CHECKSUM TABLE to calculate in multiple column chunks Checksum implementations contain optimizations for calculating checksums of larger blocks of memory. This optimization calls my_checksum on a larger block of memory rather than calling on multiple adjacent memory as its going though the table columns for each table row. --- mysql-test/t/myisam.test | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/t/myisam.test') diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 9ac49a9063d..4db7c279e82 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -552,6 +552,8 @@ insert t2 select * from t1; checksum table t1, t2, t3 quick; checksum table t1, t2, t3; checksum table t1, t2, t3 extended; +alter table t1 add d int default 30, add e bigint default 300000, add f decimal(30) default 442; +checksum table t2; #show table status; drop table t1,t2; -- cgit v1.2.1