Comments on: How to Handle pt-table-checksum Errors https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/ Tue, 13 Feb 2024 16:49:48 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Felix Ostmann https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/#comment-10969839 Fri, 19 Oct 2018 05:21:52 +0000 https://www.percona.com/blog/?p=25127#comment-10969839 There is also another solution for the “Too large chunk size or no good index” problem:
Increasing –slave-skip-tolerance from 1.0 (default). This option is a simple multiplier for the skip table check (see code below).
I changed this to 2 and every faulty skip has gone. For my setup it is no problem to run a query which perhaps check up to 2*rows as calculated.

if ( $n_rows and $n_rows > ($tbl->{chunk_size} * $chunk_size_limit) * $slave_skip_tolerance ) {
# skip with “Too large chunk size or no good index”-error
}

]]> By: lei https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/#comment-10969305 Thu, 21 Jun 2018 08:36:38 +0000 https://www.percona.com/blog/?p=25127#comment-10969305 Hi,i have some trouble in using pt-table-checksum tools,it can not work .by adding PTDBUG=1 ,it rase Database xxxxx is a system database, ignoring.

]]> By: Jagannath https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/#comment-10969202 Mon, 14 May 2018 10:09:24 +0000 https://www.percona.com/blog/?p=25127#comment-10969202 How to use pt-table-checksum and pt-table-sync in master-master replication with mixed binlog and both the servers are having differences?

]]> By: przemekmalkowski https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/#comment-10969071 Tue, 10 Apr 2018 07:15:05 +0000 https://www.percona.com/blog/?p=25127#comment-10969071 Marisela, it does: https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-checksum.html#percona-xtradb-cluster

]]> By: Marisela W. Kegley https://www.percona.com/blog/how-to-handle-pt-table-checksum-errors/#comment-10969064 Sat, 07 Apr 2018 08:29:34 +0000 https://www.percona.com/blog/?p=25127#comment-10969064 Does pt-table-checksum also support Galera plugin? Or only master-slave replication?

]]>