Register and ask your own question!
MEMORY table causing error in pt-table-checksum
I have a MEMORY table that is replicated and seems to be fine, but when I run pt-table-checksum on the database I receive this message: "Aborting table VXXX.JXXxxxx at chunk 1 because it is not safe to chunk. Chunking should use the PRIMARY index, but MySQL chose no index." The PRIMARY index is the only index on the table. I don't always monitor the output of ptc as it is produced, so I'm not sure if this is a recent development or has existed for some time. Is there a better set of parameters than " pt-table-checksum --replicate=percona.checksums --create-replicate-table --empty-replicate-table --user=xxx --password=xxxxxxxx --no-check-binlog-format --nocheck-replication-filters --nocheck-plan --chunk-size=50000 --recursion-method=hosts --recurse=1 --databases CXX,DXXDXX,PXX,SXX,VXX dbxx"? The table contains roughly 450K rows. Thanks for any assistance.