pingcap/tidb

Feature request: Support CHECKSUM TABLE command

Open

#1,895 opened on 2016年10月28日

GitHub で見る
 (10 comments) (2 reactions) (0 assignees)Go (6,186 forks)batch import
feature/discussinghelp wantedtype/compatibilitytype/enhancement

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (平均マージ 14d 4h) (30d で 346 merged PRs)

説明

When importing data into TiDB we want to be sure the data is correct. A convenient command in MySQL is CHECKSUM TABLE and this command is not currently supported by TiDB.

Adding it would make it easy to confirm if the data loaded in from an external source matches or not.

Example I did something like:

$ ssh mysqlhost sudo mysqldump test SomeTable | mysql -h tidbhost -P 4000 -u root -D test

MySQL 5.6:

root@mysqlhost [test]> checksum table SomeTable;
+-----------+------------+
| Table     | Checksum   |
+-----------+------------+
| SomeTable | 2867272629 |
+-----------+------------+
1 row in set (0.01 sec)

TiDB:

root@tidbhost [test]> checksum table SomeTable;
ERROR 1105 (HY000): line 0 column 8 near " table SomeTable"
root@tidbhost [test]> 

So providing some sort of CHECKSUM table command would be great.

コントリビューターガイド