用pt-table-checksum校验数据时有以下报错,是因为current chunk size大于默认chunk size limit=2.0 24636 rows
-02T20:: Skipping chunk of log_2017.log_wechat_down_content_2017_7 because it is oversized. The current chunk size limit is rows (chunk size= * chunk size limit=2.0), but MySQL estimates that there are rows in the chunk.
解决方法:
--chunk-size-limit,参数的默认值是2.0,修改成4.0,加上参数--chunk-size-limit=4.0。
参考
pt-table-checksum和pt-table-sync使用总结_蓝白_新浪博客 http://blog.sina.com.cn/s/blog_53b13d950102vrdp.html