Not the answer you need?
Register and ask your own question!

Sampling with pt-table-checksum

shandrewshandrew EntrantCurrent User Role Beginner
A long while back, pt-table-checksum supported "--probability" and "--modulo" options that let you select a sampling of rows. This is quite useful for large tables. What options do we have to do something similar today (aside from --where )?



  • shandrewshandrew Entrant Current User Role Beginner
    It was somewhat trickier and probably much slower, but using a --where clause on an indexed field had similar functionality.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.