markr@db1a:~$ PTDEBUG=1 pt-table-checksum --recursion-method dsn=h=127.0.0.1,D=percona,t=dsns --ask-pass --ignore-databases=mysql,test,percona # /usr/bin/perl 5.024001 # Linux db1a 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u6 (2018-10-08) x86_64 GNU/Linux # Arguments: _[--recursion-method]_ _[dsn=h=127.0.0.1,D=percona,t=dsns]_ _[--ask-pass]_ _[--ignore-databases=mysql,test,percona]_ # OptionParser:1994 32507 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:2003 32507 =item --ask-pass # OptionParser:2030 32507 Short help: Prompt for a password when connecting to MySQL # OptionParser:2003 32507 =item --channel # OptionParser:2030 32507 Short help: Channel name used when connected to a server using replication channels # OptionParser:2003 32507 =item --[no]check-binlog-format # OptionParser:2030 32507 Short help: Check that the binlog_format is the same on all servers # OptionParser:2003 32507 =item --binary-index # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: This option modifies the behavior of --create-replicate-table such that the replicate table's upper and lower boundary columns are created with the BLOB data type # OptionParser:2003 32507 =item --check-interval # OptionParser:2030 32507 Short help: Sleep time between checks for --max-lag # OptionParser:2003 32507 =item --[no]check-plan # OptionParser:2030 32507 Short help: Check query execution plans for safety # OptionParser:2003 32507 =item --[no]check-replication-filters # OptionParser:2030 32507 Short help: Do not checksum if any replication filters are set on any replicas # OptionParser:2003 32507 =item --check-slave-lag # OptionParser:2030 32507 Short help: Pause checksumming until this replica's lag is less than --max-lag # OptionParser:2003 32507 =item --[no]check-slave-tables # OptionParser:2030 32507 Short help: Checks that tables on slaves exist and have all the checksum --columns # OptionParser:2003 32507 =item --chunk-index # OptionParser:2030 32507 Short help: Prefer this index for chunking tables # OptionParser:2003 32507 =item --chunk-index-columns # OptionParser:2030 32507 Short help: Use only this many left-most columns of a --chunk-index # OptionParser:2003 32507 =item --chunk-size # OptionParser:2030 32507 Short help: Number of rows to select for each checksum query # OptionParser:2003 32507 =item --chunk-size-limit # OptionParser:2030 32507 Short help: Do not checksum chunks this much larger than the desired chunk size # OptionParser:2003 32507 =item --chunk-time # OptionParser:2030 32507 Short help: Adjust the chunk size dynamically so each checksum query takes this long to execute # OptionParser:2003 32507 =item --columns # OptionParser:2030 32507 Short help: Checksum only this comma-separated list of columns # OptionParser:2003 32507 =item --config # OptionParser:2030 32507 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:2003 32507 =item --[no]create-replicate-table # OptionParser:2030 32507 Short help: Create the --replicate database and table if they do not exist # OptionParser:2003 32507 =item --databases # OptionParser:2030 32507 Short help: Only checksum this comma-separated list of databases # OptionParser:2003 32507 =item --databases-regex # OptionParser:2030 32507 Short help: Only checksum databases whose names match this Perl regex # OptionParser:2003 32507 =item --defaults-file # OptionParser:2030 32507 Short help: Only read mysql options from the given file # OptionParser:2003 32507 =item --disable-qrt-plugin # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: Disable the QRT (Query Response Time) plugin if it is enabled # OptionParser:2003 32507 =item --[no]empty-replicate-table # OptionParser:2030 32507 Short help: Delete previous checksums for each table before checksumming the table # OptionParser:2003 32507 =item --engines # OptionParser:2030 32507 Short help: Only checksum tables which use these storage engines # OptionParser:2003 32507 =item --explain # OptionParser:2030 32507 Short help: Show, but do not execute, checksum queries (disables --[no]empty-replicate-table) # OptionParser:2003 32507 =item --float-precision # OptionParser:2030 32507 Short help: Precision for FLOAT and DOUBLE number-to-string conversion # OptionParser:2003 32507 =item --force-concat-enums # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: The NibbleIterator in Percona Toolkit can detect indexes having ENUM fields and if the items it has are sorted or not # OptionParser:2003 32507 =item --function # OptionParser:2030 32507 Short help: Hash function for checksums (FNV1A_64, MURMUR_HASH, SHA1, MD5, CRC32, etc) # OptionParser:2003 32507 =item --help # OptionParser:2030 32507 Short help: Show help and exit # OptionParser:2003 32507 =item --host # OptionParser:2030 32507 Short help: Host to connect to # OptionParser:2003 32507 =item --ignore-columns # OptionParser:2030 32507 Short help: Ignore this comma-separated list of columns when calculating the checksum # OptionParser:2003 32507 =item --ignore-databases # OptionParser:2030 32507 Short help: Ignore this comma-separated list of databases # OptionParser:2003 32507 =item --ignore-databases-regex # OptionParser:2030 32507 Short help: Ignore databases whose names match this Perl regex # OptionParser:2003 32507 =item --ignore-engines # OptionParser:2030 32507 Short help: Ignore this comma-separated list of storage engines # OptionParser:2003 32507 =item --ignore-tables # OptionParser:2030 32507 Short help: Ignore this comma-separated list of tables # OptionParser:2003 32507 =item --ignore-tables-regex # OptionParser:2030 32507 Short help: Ignore tables whose names match the Perl regex # OptionParser:2003 32507 =item --max-lag # OptionParser:2030 32507 Short help: Pause checksumming until all replicas' lag is less than this value # OptionParser:2003 32507 =item --max-load # OptionParser:2030 32507 Short help: Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than the threshold # OptionParser:2003 32507 =item --password # OptionParser:2030 32507 Short help: Password to use when connecting # OptionParser:2003 32507 =item --pause-file # OptionParser:2030 32507 Short help: Execution will be paused while the file specified by this param exists # OptionParser:2003 32507 =item --pid # OptionParser:2030 32507 Short help: Create the given PID file # OptionParser:2003 32507 =item --plugin # OptionParser:2030 32507 Short help: Perl module file that defines a pt_table_checksum_plugin class # OptionParser:2003 32507 =item --port # OptionParser:2030 32507 Short help: Port number to use for connection # OptionParser:2003 32507 =item --progress # OptionParser:2030 32507 Short help: Print progress reports to STDERR # OptionParser:2003 32507 =item --quiet # OptionParser:2030 32507 Short help: Print only the most important information (disables --progress) # OptionParser:2003 32507 =item --recurse # OptionParser:2030 32507 Short help: Number of levels to recurse in the hierarchy when discovering replicas # OptionParser:2003 32507 =item --recursion-method # OptionParser:2030 32507 Short help: Preferred recursion method for discovering replicas. pt-table-checksum performs several REPLICA CHECKS before and while running # OptionParser:2003 32507 =item --replicate # OptionParser:2030 32507 Short help: Write checksum results to this table # OptionParser:2003 32507 =item --[no]replicate-check # OptionParser:2030 32507 Short help: Check replicas for data differences after finishing each table # OptionParser:2003 32507 =item --replicate-check-only # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: Check replicas for consistency without executing checksum queries # OptionParser:2003 32507 =item --replicate-check-retries # OptionParser:2030 32507 Short help: Retry checksum comparison this many times when a difference is encountered # OptionParser:2003 32507 =item --replicate-database # OptionParser:2030 32507 Short help: USE only this database # OptionParser:2003 32507 =item --resume # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: Resume checksumming from the last completed chunk (disables --[no]empty-replicate-table) # OptionParser:2003 32507 =item --retries # OptionParser:2030 32507 Short help: Retry a chunk this many times when there is a nonfatal error # OptionParser:2003 32507 =item --run-time # OptionParser:2030 32507 Short help: How long to run # OptionParser:2003 32507 =item --separator # OptionParser:2030 32507 Short help: The separator character used for CONCAT_WS() # OptionParser:2003 32507 =item --skip-check-slave-lag # OptionParser:2030 32507 Short help: DSN to skip when checking slave lag # OptionParser:2003 32507 =item --slave-user # OptionParser:2030 32507 Short help: Sets the user to be used to connect to the slaves # OptionParser:2003 32507 =item --slave-password # OptionParser:2030 32507 Short help: Sets the password to be used to connect to the slaves # OptionParser:2003 32507 =item --set-vars # OptionParser:2030 32507 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:2003 32507 =item --socket # OptionParser:2030 32507 Short help: Socket file to use for connection # OptionParser:2003 32507 =item --slave-skip-tolerance # OptionParser:2030 32507 Short help: When a master table is marked to be checksumed in only one chunk but a slave table exceeds the maximum accepted size for this, the table is skipped # OptionParser:2003 32507 =item --tables # OptionParser:2030 32507 Short help: Checksum only this comma-separated list of tables # OptionParser:2003 32507 =item --tables-regex # OptionParser:2030 32507 Short help: Checksum only tables whose names match this Perl regex # OptionParser:2003 32507 =item --trim # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: Add TRIM() to VARCHAR columns (helps when comparing 4.1 to >= 5.0) # OptionParser:2003 32507 =item --truncate-replicate-table # OptionParser:2022 32507 Option has no attributes # OptionParser:2030 32507 Short help: Truncate the replicate table before starting the checksum # OptionParser:2003 32507 =item --user # OptionParser:2030 32507 Short help: User for login if not current user # OptionParser:2003 32507 =item --version # OptionParser:2030 32507 Short help: Show version and exit # OptionParser:2003 32507 =item --[no]version-check # OptionParser:2030 32507 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:2003 32507 =item --where # OptionParser:2030 32507 Short help: Do only rows matching this WHERE clause # OptionParser:2070 32507 Parsing opt spec: spec => ask-pass group => Connection attributes => HASH(0x564d9e201ec8) desc => Prompt for a password when connecting to MySQL # OptionParser:2109 32507 ask-pass type: undef # OptionParser:2070 32507 Parsing opt spec: group => default desc => Channel name used when connected to a server using replication channels attributes => HASH(0x564d9f02f998) spec => channel=s # OptionParser:2109 32507 channel type: s # OptionParser:2070 32507 Parsing opt spec: spec => check-binlog-format! group => default attributes => HASH(0x564d9f021560) desc => Check that the binlog_format is the same on all servers (default yes) # OptionParser:2109 32507 check-binlog-format type: undef # OptionParser:2116 32507 check-binlog-format default: yes # OptionParser:2070 32507 Parsing opt spec: spec => binary-index group => default attributes => HASH(0x564d9f035a80) desc => This option modifies the behavior of --create-replicate-table such that the replicate table's upper and lower boundary columns are created with the BLOB data type # OptionParser:2109 32507 binary-index type: undef # OptionParser:2070 32507 Parsing opt spec: group => Throttle attributes => HASH(0x564d9f035c48) desc => Sleep time between checks for --max-lag (default 1) spec => check-interval=m # OptionParser:2109 32507 check-interval type: m # OptionParser:2116 32507 check-interval default: 1 # OptionParser:2070 32507 Parsing opt spec: spec => check-plan! group => default desc => Check query execution plans for safety (default yes) attributes => HASH(0x564d9f035d08) # OptionParser:2109 32507 check-plan type: undef # OptionParser:2116 32507 check-plan default: yes # OptionParser:2070 32507 Parsing opt spec: spec => check-replication-filters! attributes => HASH(0x564d9f040248) desc => Do not checksum if any replication filters are set on any replicas (default yes) group => Safety # OptionParser:2109 32507 check-replication-filters type: undef # OptionParser:2116 32507 check-replication-filters default: yes # OptionParser:2070 32507 Parsing opt spec: spec => check-slave-lag=s group => Throttle attributes => HASH(0x564d9f040338) desc => Pause checksumming until this replica's lag is less than --max-lag # OptionParser:2109 32507 check-slave-lag type: s # OptionParser:2070 32507 Parsing opt spec: group => Safety desc => Checks that tables on slaves exist and have all the checksum --columns (default yes) attributes => HASH(0x564d9f0403e0) spec => check-slave-tables! # OptionParser:2109 32507 check-slave-tables type: undef # OptionParser:2116 32507 check-slave-tables default: yes # OptionParser:2070 32507 Parsing opt spec: spec => chunk-index=s group => default desc => Prefer this index for chunking tables attributes => HASH(0x564d9f040800) # OptionParser:2109 32507 chunk-index type: s # OptionParser:2070 32507 Parsing opt spec: spec => chunk-index-columns=i desc => Use only this many left-most columns of a --chunk-index attributes => HASH(0x564d9f040740) group => default # OptionParser:2109 32507 chunk-index-columns type: i # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f040680) desc => Number of rows to select for each checksum query (default 1000) group => default spec => chunk-size=z # OptionParser:2109 32507 chunk-size type: z # OptionParser:2116 32507 chunk-size default: 1000 # OptionParser:2070 32507 Parsing opt spec: group => Safety attributes => HASH(0x564d9f0405a8) desc => Do not checksum chunks this much larger than the desired chunk size (default 2.0) spec => chunk-size-limit=f # OptionParser:2109 32507 chunk-size-limit type: f # OptionParser:2116 32507 chunk-size-limit default: 2.0 # OptionParser:2070 32507 Parsing opt spec: spec => chunk-time=f attributes => HASH(0x564d9f0404b8) desc => Adjust the chunk size dynamically so each checksum query takes this long to execute (default 0.5) group => default # OptionParser:2109 32507 chunk-time type: f # OptionParser:2116 32507 chunk-time default: 0.5 # OptionParser:2070 32507 Parsing opt spec: group => Filter desc => Checksum only this comma-separated list of columns attributes => HASH(0x564d9f0408f0) spec => columns|c=a # OptionParser:2109 32507 columns type: a # OptionParser:2070 32507 Parsing opt spec: group => Config attributes => HASH(0x564d9f040938) desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line spec => config=A # OptionParser:2109 32507 config type: A # OptionParser:2070 32507 Parsing opt spec: desc => Create the --replicate database and table if they do not exist (default yes) attributes => HASH(0x564d9f040ad0) group => default spec => create-replicate-table! # OptionParser:2109 32507 create-replicate-table type: undef # OptionParser:2116 32507 create-replicate-table default: yes # OptionParser:2070 32507 Parsing opt spec: spec => databases|d=h attributes => HASH(0x564d9f040f68) desc => Only checksum this comma-separated list of databases group => Filter # OptionParser:2109 32507 databases type: h # OptionParser:2070 32507 Parsing opt spec: desc => Only checksum databases whose names match this Perl regex attributes => HASH(0x564d9f040e78) group => Filter spec => databases-regex=s # OptionParser:2109 32507 databases-regex type: s # OptionParser:2070 32507 Parsing opt spec: spec => defaults-file|F=s group => Connection attributes => HASH(0x564d9f040da0) desc => Only read mysql options from the given file # OptionParser:2109 32507 defaults-file type: s # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f040cb0) desc => Disable the QRT (Query Response Time) plugin if it is enabled group => default spec => disable-qrt-plugin # OptionParser:2109 32507 disable-qrt-plugin type: undef # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f040c08) desc => Delete previous checksums for each table before checksumming the table (default yes) group => default spec => empty-replicate-table! # OptionParser:2109 32507 empty-replicate-table type: undef # OptionParser:2116 32507 empty-replicate-table default: yes # OptionParser:2070 32507 Parsing opt spec: group => Filter attributes => HASH(0x564d9f040b30) desc => Only checksum tables which use these storage engines spec => engines|e=h # OptionParser:2109 32507 engines type: h # OptionParser:2070 32507 Parsing opt spec: spec => explain+ desc => Show, but do not execute, checksum queries (disables --[no]empty-replicate-table) (default 0) attributes => HASH(0x564d9f0410d0) group => Output # OptionParser:2109 32507 explain type: undef # OptionParser:2116 32507 explain default: 0 # OptionParser:2125 32507 Deferring check of disables rule for HASH(0x564d9f040bf0) disables --[no]empty-replicate-table) (default 0) # OptionParser:2070 32507 Parsing opt spec: group => default desc => Precision for FLOAT and DOUBLE number-to-string conversion attributes => HASH(0x564d9f041058) spec => float-precision=i # OptionParser:2109 32507 float-precision type: i # OptionParser:2070 32507 Parsing opt spec: spec => force-concat-enums attributes => HASH(0x564d9f046508) desc => The NibbleIterator in Percona Toolkit can detect indexes having ENUM fields and if the items it has are sorted or not group => default # OptionParser:2109 32507 force-concat-enums type: undef # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f046460) desc => Hash function for checksums (FNV1A_64, MURMUR_HASH, SHA1, MD5, CRC32, etc) group => default spec => function=s # OptionParser:2109 32507 function type: s # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f046610) desc => Show help and exit group => Help spec => help # OptionParser:2109 32507 help type: undef # OptionParser:2070 32507 Parsing opt spec: desc => Host to connect to (default localhost) attributes => HASH(0x564d9f046550) group => Connection spec => host|h=s # OptionParser:2109 32507 host type: s # OptionParser:2116 32507 host default: localhost # OptionParser:2070 32507 Parsing opt spec: spec => ignore-columns=H desc => Ignore this comma-separated list of columns when calculating the checksum attributes => HASH(0x564d9f046730) group => Filter # OptionParser:2109 32507 ignore-columns type: H # OptionParser:2070 32507 Parsing opt spec: group => Filter attributes => HASH(0x564d9f046760) desc => Ignore this comma-separated list of databases spec => ignore-databases=H # OptionParser:2109 32507 ignore-databases type: H # OptionParser:2070 32507 Parsing opt spec: spec => ignore-databases-regex=s attributes => HASH(0x564d9f046838) desc => Ignore databases whose names match this Perl regex group => Filter # OptionParser:2109 32507 ignore-databases-regex type: s # OptionParser:2070 32507 Parsing opt spec: spec => ignore-engines=H desc => Ignore this comma-separated list of storage engines (default FEDERATED,MRG_MyISAM) attributes => HASH(0x564d9f046a60) group => Filter # OptionParser:2109 32507 ignore-engines type: H # OptionParser:2116 32507 ignore-engines default: FEDERATED,MRG_MyISAM # OptionParser:2070 32507 Parsing opt spec: spec => ignore-tables=H attributes => HASH(0x564d9f0468f8) desc => Ignore this comma-separated list of tables group => Filter # OptionParser:2109 32507 ignore-tables type: H # OptionParser:2070 32507 Parsing opt spec: desc => Ignore tables whose names match the Perl regex attributes => HASH(0x564d9f046b08) group => Filter spec => ignore-tables-regex=s # OptionParser:2109 32507 ignore-tables-regex type: s # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f046c10) desc => Pause checksumming until all replicas' lag is less than this value (default 1s) group => Throttle spec => max-lag=m # OptionParser:2109 32507 max-lag type: m # OptionParser:2116 32507 max-lag default: 1s # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f046d00) desc => Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than the threshold (default Threads_running=25) group => Throttle spec => max-load=A # OptionParser:2109 32507 max-load type: A # OptionParser:2116 32507 max-load default: Threads_running=25 # OptionParser:2070 32507 Parsing opt spec: desc => Password to use when connecting attributes => HASH(0x564d9f046dc0) group => Connection spec => password|p=s # OptionParser:2109 32507 password type: s # OptionParser:2070 32507 Parsing opt spec: spec => pause-file=s group => default attributes => HASH(0x564d9f046e50) desc => Execution will be paused while the file specified by this param exists # OptionParser:2109 32507 pause-file type: s # OptionParser:2070 32507 Parsing opt spec: spec => pid=s group => default attributes => HASH(0x564d9f046f40) desc => Create the given PID file # OptionParser:2109 32507 pid type: s # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f0471e0) desc => Perl module file that defines a pt_table_checksum_plugin class group => default spec => plugin=s # OptionParser:2109 32507 plugin type: s # OptionParser:2070 32507 Parsing opt spec: spec => port|P=i desc => Port number to use for connection attributes => HASH(0x564d9f047120) group => Connection # OptionParser:2109 32507 port type: i # OptionParser:2070 32507 Parsing opt spec: spec => progress=a attributes => HASH(0x564d9f047030) desc => Print progress reports to STDERR (default time,30) group => default # OptionParser:2109 32507 progress type: a # OptionParser:2116 32507 progress default: time,30 # OptionParser:2070 32507 Parsing opt spec: spec => quiet|q+ group => default attributes => HASH(0x564d9f04cbe0) desc => Print only the most important information (disables --progress) (default 0) # OptionParser:2109 32507 quiet type: undef # OptionParser:2116 32507 quiet default: 0 # OptionParser:2125 32507 Deferring check of disables rule for HASH(0x564d9f047000) disables --progress) (default 0) # OptionParser:2070 32507 Parsing opt spec: desc => Number of levels to recurse in the hierarchy when discovering replicas attributes => HASH(0x564d9f04cee0) group => default spec => recurse=i # OptionParser:2109 32507 recurse type: i # OptionParser:2070 32507 Parsing opt spec: group => default attributes => HASH(0x564d9f04ce20) desc => Preferred recursion method for discovering replicas. pt-table-checksum performs several REPLICA CHECKS before and while running (default processlist,hosts) spec => recursion-method=a # OptionParser:2109 32507 recursion-method type: a # OptionParser:2116 32507 recursion-method default: processlist,hosts # OptionParser:2070 32507 Parsing opt spec: group => default desc => Write checksum results to this table (default percona.checksums) attributes => HASH(0x564d9f04cd48) spec => replicate=s # OptionParser:2109 32507 replicate type: s # OptionParser:2116 32507 replicate default: percona.checksums # OptionParser:2070 32507 Parsing opt spec: spec => replicate-check! group => default desc => Check replicas for data differences after finishing each table (default yes) attributes => HASH(0x564d9f047270) # OptionParser:2109 32507 replicate-check type: undef # OptionParser:2116 32507 replicate-check default: yes # OptionParser:2070 32507 Parsing opt spec: desc => Check replicas for consistency without executing checksum queries attributes => HASH(0x564d9f04d048) group => default spec => replicate-check-only # OptionParser:2109 32507 replicate-check-only type: undef # OptionParser:2070 32507 Parsing opt spec: spec => replicate-check-retries=i group => default attributes => HASH(0x564d9f04cfa0) desc => Retry checksum comparison this many times when a difference is encountered (default 1) # OptionParser:2109 32507 replicate-check-retries type: i # OptionParser:2116 32507 replicate-check-retries default: 1 # OptionParser:2070 32507 Parsing opt spec: spec => replicate-database=s desc => USE only this database attributes => HASH(0x564d9f04d3a8) group => default # OptionParser:2109 32507 replicate-database type: s # OptionParser:2070 32507 Parsing opt spec: group => default attributes => HASH(0x564d9f04d2e8) desc => Resume checksumming from the last completed chunk (disables --[no]empty-replicate-table) spec => resume # OptionParser:2109 32507 resume type: undef # OptionParser:2125 32507 Deferring check of disables rule for HASH(0x564d9f046370) disables --[no]empty-replicate-table) # OptionParser:2070 32507 Parsing opt spec: spec => retries=i group => default attributes => HASH(0x564d9f04d240) desc => Retry a chunk this many times when there is a nonfatal error (default 2) # OptionParser:2109 32507 retries type: i # OptionParser:2116 32507 retries default: 2 # OptionParser:2070 32507 Parsing opt spec: group => default attributes => HASH(0x564d9f04d168) desc => How long to run spec => run-time=m # OptionParser:2109 32507 run-time type: m # OptionParser:2070 32507 Parsing opt spec: spec => separator=s desc => The separator character used for CONCAT_WS() (default #) attributes => HASH(0x564d9f04d468) group => default # OptionParser:2109 32507 separator type: s # OptionParser:2116 32507 separator default: # # OptionParser:2070 32507 Parsing opt spec: desc => DSN to skip when checking slave lag attributes => HASH(0x564d9f04d600) group => default spec => skip-check-slave-lag=d # OptionParser:2109 32507 skip-check-slave-lag type: d # OptionParser:2070 32507 Parsing opt spec: spec => slave-user=s group => default attributes => HASH(0x564d9f04d528) desc => Sets the user to be used to connect to the slaves # OptionParser:2109 32507 slave-user type: s # OptionParser:2070 32507 Parsing opt spec: group => default desc => Sets the password to be used to connect to the slaves attributes => HASH(0x564d9f04d6d8) spec => slave-password=s # OptionParser:2109 32507 slave-password type: s # OptionParser:2070 32507 Parsing opt spec: group => Connection desc => Set the MySQL variables in this comma-separated list of variable=value pairs attributes => HASH(0x564d9f04d7c8) spec => set-vars=A # OptionParser:2109 32507 set-vars type: A # OptionParser:2070 32507 Parsing opt spec: spec => socket|S=s attributes => HASH(0x564d9f04d840) desc => Socket file to use for connection group => Connection # OptionParser:2109 32507 socket type: s # OptionParser:2070 32507 Parsing opt spec: group => default attributes => HASH(0x564d9f0538a8) desc => When a master table is marked to be checksumed in only one chunk but a slave table exceeds the maximum accepted size for this, the table is skipped (default 1.0) spec => slave-skip-tolerance=f # OptionParser:2109 32507 slave-skip-tolerance type: f # OptionParser:2116 32507 slave-skip-tolerance default: 1.0 # OptionParser:2070 32507 Parsing opt spec: group => Filter desc => Checksum only this comma-separated list of tables attributes => HASH(0x564d9f0537d0) spec => tables|t=h # OptionParser:2109 32507 tables type: h # OptionParser:2070 32507 Parsing opt spec: attributes => HASH(0x564d9f0536e0) desc => Checksum only tables whose names match this Perl regex group => Filter spec => tables-regex=s # OptionParser:2109 32507 tables-regex type: s # OptionParser:2070 32507 Parsing opt spec: spec => trim desc => Add TRIM() to VARCHAR columns (helps when comparing 4.1 to >= 5.0) attributes => HASH(0x564d9f04db10) group => default # OptionParser:2109 32507 trim type: undef # OptionParser:2070 32507 Parsing opt spec: spec => truncate-replicate-table group => default attributes => HASH(0x564d9f04da68) desc => Truncate the replicate table before starting the checksum # OptionParser:2109 32507 truncate-replicate-table type: undef # OptionParser:2070 32507 Parsing opt spec: group => Connection desc => User for login if not current user attributes => HASH(0x564d9f04d9c0) spec => user|u=s # OptionParser:2109 32507 user type: s # OptionParser:2070 32507 Parsing opt spec: spec => version group => Help desc => Show version and exit attributes => HASH(0x564d9f053968) # OptionParser:2109 32507 version type: undef # OptionParser:2070 32507 Parsing opt spec: spec => version-check! group => default attributes => HASH(0x564d9f053a58) desc => Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) # OptionParser:2109 32507 version-check type: undef # OptionParser:2116 32507 version-check default: yes # OptionParser:2070 32507 Parsing opt spec: group => default attributes => HASH(0x564d9f053bf0) desc => Do only rows matching this WHERE clause spec => where=s # OptionParser:2109 32507 where type: s # OptionParser:2131 32507 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:2187 32507 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:2163 32507 Strict mode disabled by rule # OptionParser:2187 32507 Participants for disables --[no]empty-replicate-table) : empty-replicate-table # OptionParser:2173 32507 Option resume disables empty-replicate-table # OptionParser:2187 32507 Participants for disables --progress) (default 0) : progress # OptionParser:2173 32507 Option quiet disables progress # OptionParser:2187 32507 Participants for disables --[no]empty-replicate-table) (default 0) : empty-replicate-table # OptionParser:2173 32507 Option explain disables empty-replicate-table # OptionParser:1913 32507 Parsing DSN OPTIONS # OptionParser:2003 32507 =item * A # OptionParser:2030 32507 Short help: Default character set # OptionParser:2003 32507 =item * D # OptionParser:2030 32507 Short help: DSN table database # OptionParser:2003 32507 =item * F # OptionParser:2030 32507 Short help: Defaults file for connection values # OptionParser:2003 32507 =item * h # OptionParser:2030 32507 Short help: Connect to host # OptionParser:2003 32507 =item * p # OptionParser:2030 32507 Short help: Password to use when connecting # OptionParser:2003 32507 =item * P # OptionParser:2030 32507 Short help: Port number to use for connection # OptionParser:2003 32507 =item * S # OptionParser:2030 32507 Short help: Socket file to use for connection # OptionParser:2003 32507 =item * t # OptionParser:2030 32507 Short help: DSN table table # OptionParser:2003 32507 =item * u # OptionParser:2030 32507 Short help: User for login if not current user # DSNParser:1431 32507 DSN option: dsn=charset, key=A, desc=Default character set, copy=1 # DSNParser:1431 32507 DSN option: copy=, desc=DSN table database, key=D, dsn=undef # DSNParser:1431 32507 DSN option: key=F, dsn=mysql_read_default_file, copy=1, desc=Defaults file for connection values # DSNParser:1431 32507 DSN option: dsn=host, key=h, desc=Connect to host, copy=1 # DSNParser:1431 32507 DSN option: key=p, dsn=password, copy=1, desc=Password to use when connecting # DSNParser:1431 32507 DSN option: key=P, dsn=port, copy=1, desc=Port number to use for connection # DSNParser:1431 32507 DSN option: copy=, desc=Socket file to use for connection, key=S, dsn=mysql_socket # DSNParser:1431 32507 DSN option: dsn=undef, key=t, desc=DSN table table, copy= # DSNParser:1431 32507 DSN option: dsn=user, key=u, desc=User for login if not current user, copy=1 # OptionParser:1957 32507 pt-table-checksum 3.0.12 # OptionParser:2297 32507 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:2297 32507 Cannot open /etc/percona-toolkit/pt-table-checksum.conf: No such file or directory # # OptionParser:2297 32507 Cannot open /home/markr/.percona-toolkit.conf: No such file or directory # # OptionParser:2297 32507 Cannot open /home/markr/.pt-table-checksum.conf: No such file or directory # # OptionParser:2259 32507 Got option recursion-method = dsn=h=127.0.0.1,D=percona,t=dsns # OptionParser:2259 32507 Got option ask-pass = 1 # OptionParser:2259 32507 Got option ignore-databases = mysql,test,percona # OptionParser:2495 32507 Nothing to validate for option recurse type i value undef # OptionParser:2495 32507 Nothing to validate for option slave-password type s value undef # OptionParser:2495 32507 Nothing to validate for option replicate-database type s value undef # OptionParser:2495 32507 Nothing to validate for option defaults-file type s value undef # OptionParser:2495 32507 Nothing to validate for option replicate-check-retries type i value 1 # OptionParser:2495 32507 Nothing to validate for option slave-skip-tolerance type f value 1.0 # OptionParser:2495 32507 Nothing to validate for option separator type s value # # OptionParser:2495 32507 Nothing to validate for option chunk-index-columns type i value undef # OptionParser:2495 32507 Nothing to validate for option chunk-size-limit type f value 2.0 # OptionParser:2495 32507 Nothing to validate for option slave-user type s value undef # OptionParser:2495 32507 Nothing to validate for option databases type h value undef # OptionParser:2495 32507 Nothing to validate for option chunk-time type f value 0.5 # OptionParser:2495 32507 Nothing to validate for option check-slave-lag type s value undef # OptionParser:2495 32507 Nothing to validate for option tables type h value undef # OptionParser:2495 32507 Nothing to validate for option columns type a value undef # OptionParser:2484 32507 Parsing option chunk-size as a size value # OptionParser:2495 32507 Nothing to validate for option host type s value localhost # OptionParser:2495 32507 Nothing to validate for option pid type s value undef # OptionParser:2495 32507 Nothing to validate for option port type i value undef # OptionParser:2437 32507 Parsing option check-interval as a time value # OptionParser:2443 32507 No suffix given; using s for check-interval (value: 1 ) # OptionParser:2451 32507 Setting option check-interval to 1 # OptionParser:2495 32507 Nothing to validate for option function type s value undef # OptionParser:2495 32507 Nothing to validate for option float-precision type i value undef # OptionParser:2495 32507 Nothing to validate for option ignore-databases-regex type s value undef # OptionParser:2495 32507 Nothing to validate for option where type s value undef # OptionParser:2495 32507 Nothing to validate for option plugin type s value undef # OptionParser:2495 32507 Nothing to validate for option pause-file type s value undef # OptionParser:2495 32507 Nothing to validate for option password type s value undef # OptionParser:2495 32507 Nothing to validate for option databases-regex type s value undef # OptionParser:2495 32507 Nothing to validate for option skip-check-slave-lag type d value undef # OptionParser:2495 32507 Nothing to validate for option user type s value undef # OptionParser:2495 32507 Nothing to validate for option replicate type s value percona.checksums # OptionParser:2495 32507 Nothing to validate for option engines type h value undef # OptionParser:2495 32507 Nothing to validate for option ignore-tables-regex type s value undef # OptionParser:2495 32507 Nothing to validate for option socket type s value undef # OptionParser:2495 32507 Nothing to validate for option chunk-index type s value undef # OptionParser:2495 32507 Nothing to validate for option run-time type m value undef # OptionParser:2495 32507 Nothing to validate for option retries type i value 2 # OptionParser:2437 32507 Parsing option max-lag as a time value # OptionParser:2451 32507 Setting option max-lag to 1 # OptionParser:2495 32507 Nothing to validate for option tables-regex type s value undef # OptionParser:2495 32507 Nothing to validate for option channel type s value undef # OptionParser:2896 32507 --set-vars: $VAR1 = { # innodb_lock_wait_timeout => { # default => 1, # val => '1' # }, # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:1447 32507 Setting set-vars property # OptionParser:2568 32507 Getting description and usage from SYNOPSIS in /usr/bin/pt-table-checksum # OptionParser:2829 32507 Parsing SYNOPSIS in /usr/bin/pt-table-checksum # OptionParser:2842 32507 Raw SYNOPSIS text: Usage: pt-table-checksum [OPTIONS] [DSN] # # pt-table-checksum performs an online replication consistency check by executing # checksum queries on the master, which produces different results on replicas # that are inconsistent with the master. The optional DSN specifies the master # host. The tool's L<"EXIT STATUS"> is non-zero if any differences are found, # or if any warnings or errors occur. # # # OptionParser:2573 32507 Description: pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master. The optional DSN specifies the master host. The tool's L<"EXIT STATUS"> is non-zero if any differences are found, or if any warnings or errors occur. # Usage: pt-table-checksum [OPTIONS] [DSN] # Daemon:7270 32507 Starting daemon # Daemon:7340 32507 Daemon running # DSNParser:1519 32507 DSN string made from options: h=localhost # DSNParser:1459 32507 Parsing h=localhost # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1459 32507 Parsing h=localhost # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults Enter MySQL password: # DSNParser:1572 32507 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:1621 32507 DBI:mysql:;host=localhost;mysql_read_default_group=client undef ****** ShowErrorStatement=>1, RaiseError=>1, PrintError=>0, mysql_enable_utf8=>0, AutoCommit=>1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f0d5148) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f0d5148) SET SESSION wait_timeout=10000 # DSNParser:1670 32507 DBI::db=HASH(0x564d9f0d5148) SELECT @@SQL_MODE # DSNParser:1680 32507 DBI::db=HASH(0x564d9f0d5148) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:1694 32507 DBH info: DBI::db=HASH(0x564d9f0d5148) $VAR1 = { # '@@hostname' => 'db1a', # 'CONNECTION_ID()' => 172569, # 'DATABASE()' => undef, # 'VERSION()' => '10.1.26-MariaDB-0+deb9u1' # }; # Connection info: Localhost via UNIX socket Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.041 $DBI::VERSION: 1.636 # Cxn:3675 32507 DBI::db=HASH(0x564d9f0d5148) Setting dbh # Cxn:3680 32507 DBI::db=HASH(0x564d9f0d5148) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3682 32507 DBI::db=HASH(0x564d9f0d5148) hostname: db1a 11 # pt_table_checksum:10060 32507 DBI::db=HASH(0x564d9f0d5148) SELECT @@SQL_MODE # pt_table_checksum:10067 32507 DBI::db=HASH(0x564d9f0d5148) SET SQL_MODE=',NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' # VersionParser:4304 32507 VersionParser got a dbh, trying to get the version # VersionParser:4352 32507 InnoDB support: DEFAULT # VersionParser:4364 32507 InnoDB version: 5.6.36-82.1 # pt_table_checksum:10082 32507 DBI::db=HASH(0x564d9f0d5148) SELECT @@binlog_format # pt_table_checksum:10084 32507 Original binlog_format: ROW # pt_table_checksum:10088 32507 DBI::db=HASH(0x564d9f0d5148) /*!50108 SET @@binlog_format := 'STATEMENT'*/ # pt_table_checksum:10115 32507 DBI::db=HASH(0x564d9f0d5148) SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ # Cxn:3663 32507 DBI::db=HASH(0x564d9f0d5148) Connected dbh to db1a h=localhost Checking if all tables can be checksummed ... # MySQLConfig:8784 32507 DBI::db=HASH(0x564d9f0d5148) SHOW /*!40103 GLOBAL*/ VARIABLES # MySQLConfig:9201 32507 MySQL version 10.1.26-MariaDB-0+deb9u1 Starting checksum ... # Percona::XtraDB::Cluster:3870 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:3872 32507 $VAR1 = [ # 'wsrep_on', # 'ON' # ]; # # Percona::XtraDB::Cluster:3861 32507 db1a SHOW VARIABLES LIKE 'wsrep_cluster_name' # VersionParser:4304 32507 VersionParser got a dbh, trying to get the version # VersionParser:4352 32507 InnoDB support: DEFAULT # VersionParser:4364 32507 InnoDB version: 5.6.36-82.1 # MasterSlave:5826 32507 DSN table DSN: h=127.0.0.1,D=percona,t=dsns # DSNParser:1459 32507 Parsing h=127.0.0.1,D=percona,t=dsns # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1519 32507 DSN string made from options: h=localhost # DSNParser:1459 32507 Parsing h=localhost # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1572 32507 DBI:mysql:percona;host=127.0.0.1;mysql_read_default_group=client # DSNParser:1621 32507 DBI:mysql:percona;host=127.0.0.1;mysql_read_default_group=client undef ****** mysql_enable_utf8=>0, PrintError=>0, ShowErrorStatement=>1, RaiseError=>1, AutoCommit=>1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f13e760) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f13e760) SET SESSION wait_timeout=10000 # DSNParser:1670 32507 DBI::db=HASH(0x564d9f13e760) SELECT @@SQL_MODE # DSNParser:1680 32507 DBI::db=HASH(0x564d9f13e760) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:1694 32507 DBH info: DBI::db=HASH(0x564d9f13e760) $VAR1 = { # '@@hostname' => 'db1a', # 'CONNECTION_ID()' => 172570, # 'DATABASE()' => 'percona', # 'VERSION()' => '10.1.26-MariaDB-0+deb9u1' # }; # Connection info: 127.0.0.1 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.041 $DBI::VERSION: 1.636 # Cxn:3675 32507 DBI::db=HASH(0x564d9f13e760) Setting dbh # Cxn:3680 32507 DBI::db=HASH(0x564d9f13e760) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3682 32507 DBI::db=HASH(0x564d9f13e760) hostname: db1a 11 # Cxn:3663 32507 DBI::db=HASH(0x564d9f13e760) Connected dbh to db1a h=127.0.0.1 # Percona::XtraDB::Cluster:3870 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:3872 32507 $VAR1 = [ # 'wsrep_on', # 'ON' # ]; # # Percona::XtraDB::Cluster:3861 32507 db1a SHOW VARIABLES LIKE 'wsrep_cluster_name' # Cxn:3671 32507 DBI::db=HASH(0x564d9f13e760) Already set dbh # Cxn:3663 32507 DBI::db=HASH(0x564d9f13e760) Connected dbh to db1a h=127.0.0.1 # MasterSlave:5847 32507 SELECT dsn FROM `percona`.`dsns` ORDER BY id # MasterSlave:5852 32507 DSN from DSN table: h=db1a,u=checksum,p=****** # DSNParser:1519 32507 DSN string made from options: h=localhost # DSNParser:1459 32507 Parsing h=localhost # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1459 32507 Parsing h=db1a,u=checksum,p=******* # DSNParser:1478 32507 Finding value for p # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1572 32507 DBI:mysql:;host=db1a;mysql_read_default_group=client # DSNParser:1621 32507 DBI:mysql:;host=db1a;mysql_read_default_group=client checksum ****** AutoCommit=>1, PrintError=>0, ShowErrorStatement=>1, RaiseError=>1, mysql_enable_utf8=>0 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f13e088) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f13e088) SET SESSION wait_timeout=10000 # DSNParser:1670 32507 DBI::db=HASH(0x564d9f13e088) SELECT @@SQL_MODE # DSNParser:1680 32507 DBI::db=HASH(0x564d9f13e088) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:1694 32507 DBH info: DBI::db=HASH(0x564d9f13e088) $VAR1 = { # '@@hostname' => 'db1a', # 'CONNECTION_ID()' => 172571, # 'DATABASE()' => undef, # 'VERSION()' => '10.1.26-MariaDB-0+deb9u1' # }; # Connection info: db1a via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.041 $DBI::VERSION: 1.636 # Cxn:3675 32507 DBI::db=HASH(0x564d9f13e088) Setting dbh # Cxn:3680 32507 DBI::db=HASH(0x564d9f13e088) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3682 32507 DBI::db=HASH(0x564d9f13e088) hostname: db1a 11 # Cxn:3663 32507 DBI::db=HASH(0x564d9f13e088) Connected dbh to db1a h=db1a # Percona::XtraDB::Cluster:3870 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:3872 32507 $VAR1 = [ # 'wsrep_on', # 'ON' # ]; # # Percona::XtraDB::Cluster:3861 32507 db1a SHOW VARIABLES LIKE 'wsrep_cluster_name' # MasterSlave:5852 32507 DSN from DSN table: h=db2a,u=checksum,p=***** # DSNParser:1519 32507 DSN string made from options: h=localhost # DSNParser:1459 32507 Parsing h=localhost # DSNParser:1478 32507 Finding value for p # DSNParser:1488 32507 Copying value for p from defaults # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1488 32507 Copying value for u from defaults # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1459 32507 Parsing h=db2a,u=checksum,p=****** # DSNParser:1478 32507 Finding value for p # DSNParser:1478 32507 Finding value for S # DSNParser:1488 32507 Copying value for S from defaults # DSNParser:1478 32507 Finding value for h # DSNParser:1478 32507 Finding value for A # DSNParser:1488 32507 Copying value for A from defaults # DSNParser:1478 32507 Finding value for u # DSNParser:1478 32507 Finding value for D # DSNParser:1488 32507 Copying value for D from defaults # DSNParser:1478 32507 Finding value for P # DSNParser:1488 32507 Copying value for P from defaults # DSNParser:1478 32507 Finding value for t # DSNParser:1488 32507 Copying value for t from defaults # DSNParser:1478 32507 Finding value for F # DSNParser:1488 32507 Copying value for F from defaults # DSNParser:1572 32507 DBI:mysql:;host=db2a;mysql_read_default_group=client # DSNParser:1621 32507 DBI:mysql:;host=db2a;mysql_read_default_group=client checksum ***** mysql_enable_utf8=>0, RaiseError=>1, ShowErrorStatement=>1, PrintError=>0, AutoCommit=>1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f0cd480) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:1780 32507 DBI::db=HASH(0x564d9f0cd480) SET SESSION wait_timeout=10000 # DSNParser:1670 32507 DBI::db=HASH(0x564d9f0cd480) SELECT @@SQL_MODE # DSNParser:1680 32507 DBI::db=HASH(0x564d9f0cd480) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:1694 32507 DBH info: DBI::db=HASH(0x564d9f0cd480) $VAR1 = { # '@@hostname' => 'db2a', # 'CONNECTION_ID()' => 296014, # 'DATABASE()' => undef, # 'VERSION()' => '10.1.26-MariaDB-0+deb9u1' # }; # Connection info: db2a via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.041 $DBI::VERSION: 1.636 # Cxn:3675 32507 DBI::db=HASH(0x564d9f0cd480) Setting dbh # Cxn:3680 32507 DBI::db=HASH(0x564d9f0cd480) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3682 32507 DBI::db=HASH(0x564d9f0cd480) hostname: db2a 12 # Cxn:3663 32507 DBI::db=HASH(0x564d9f0cd480) Connected dbh to db2a h=db2a # Percona::XtraDB::Cluster:3870 32507 db2a SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:3872 32507 $VAR1 = [ # 'wsrep_on', # 'ON' # ]; # # Percona::XtraDB::Cluster:3861 32507 db2a SHOW VARIABLES LIKE 'wsrep_cluster_name' # Cxn:3806 32507 Destroying cxn # Cxn:3816 32507 DBI::db=HASH(0x564d9f13e760) Disconnecting dbh on db1a h=127.0.0.1 # Cxn:3771 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 0 # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 0||11|AUTO|db1a|db1a # Cxn:3771 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 0 # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 0||11|AUTO|db1a|db1a # Cxn:3771 32507 db2a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 2 # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 2||12|AUTO|db2a|db2a # Cxn:3783 32507 Removing duplicates from db1a db1a db2a # Cxn:3771 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 0 # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 0||11|AUTO|db1a|db1a # Cxn:3789 32507 Server ID for db1a : 0||11|AUTO|db1a|db1a # Cxn:3771 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 0 # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db1a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 0||11|AUTO|db1a|db1a # Cxn:3789 32507 Server ID for db1a : 0||11|AUTO|db1a|db1a # Cxn:3795 32507 Removing db1a , ID 0||11|AUTO|db1a|db1a , because we've already seen it # Cxn:3771 32507 db2a SHOW VARIABLES LIKE 'wsrep_on' # Cxn:3739 32507 Got cluster wsrep_local_index: 2 # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'server\_id' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_node\_name' # Cxn:3743 32507 db2a SHOW VARIABLES LIKE 'wsrep\_node\_address' # Cxn:3752 32507 Generated unique id for cluster: 2||12|AUTO|db2a|db2a # Cxn:3789 32507 Server ID for db2a : 2||12|AUTO|db2a|db2a # Cxn:3806 32507 Destroying cxn # Cxn:3816 32507 DBI::db=HASH(0x564d9f13e088) Disconnecting dbh on db1a h=db1a # pt_table_checksum:10358 32507 1 slaves found # VersionParser:4304 32507 VersionParser got a dbh, trying to get the version # VersionParser:4352 32507 InnoDB support: DEFAULT # VersionParser:4364 32507 InnoDB version: 5.6.36-82.1 # pt_table_checksum:10498 32507 QRT plugin is not installed on slave h=db2a # pt_table_checksum:10518 32507 Will check slave lag on all slaves Not checking replica lag on db2a because it is a cluster node. # pt_table_checksum:10611 32507 Checking slave replication filters # MasterSlave:5481 32507 DBI::db=HASH(0x564d9f0cd480) SHOW MASTER STATUS # MasterSlave:5485 32507 # MasterSlave:5489 32507 Server on dbh DBI::db=HASH(0x564d9f0cd480) does not seem to be a master # MasterSlave:5435 32507 DBI::db=HASH(0x564d9f0cd480) SHOW SLAVE STATUS # MasterSlave:5466 32507 This server returns nothing for SHOW SLAVE STATUS # pt_table_checksum:11878 32507 Checking --replicate table `percona`.`checksums` # pt_table_checksum:11887 32507 SHOW DATABASES LIKE 'percona' # pt_table_checksum:11902 32507 CREATE DATABASE IF NOT EXISTS `percona` /* pt-table-checksum */ # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `percona` # TableParser:4624 32507 Checking `percona`.`checksums` # TableParser:4630 32507 SHOW TABLES FROM `percona` LIKE 'checksums' # TableParser:4645 32507 Table percona checksums exists # pt_table_checksum:11959 32507 --replicate table exists: yes # pt_table_checksum:12251 32507 Creating --replicate table `percona`.`checksums` # pt_table_checksum:12259 32507 DBI::db=HASH(0x564d9f0d5148) CREATE TABLE IF NOT EXISTS `percona`.`checksums` ( # db CHAR(64) NOT NULL, # tbl CHAR(64) NOT NULL, # chunk INT NOT NULL, # chunk_time FLOAT NULL, # chunk_index VARCHAR(200) NULL, # lower_boundary TEXT NULL, # upper_boundary TEXT NULL, # this_crc CHAR(40) NOT NULL, # this_cnt INT NOT NULL, # master_crc CHAR(40) NULL, # master_cnt INT NULL, # ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, # PRIMARY KEY (db, tbl, chunk), # INDEX ts_db_tbl (ts, db, tbl) # ) ENGINE=InnoDB DEFAULT CHARSET=utf8 # pt_table_checksum:12037 32507 Checking if db2a has repl table # TableParser:4624 32507 Checking `percona`.`checksums` # TableParser:4630 32507 SHOW TABLES FROM `percona` LIKE 'checksums' # TableParser:4645 32507 Table percona checksums exists # MySQLStatusWaiter:9313 32507 Parsing spec for max thresholds # MySQLStatusWaiter:9455 32507 Checking and setting values # pt_table_checksum:10730 32507 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:9471 32507 Wait if Threads_running >= 25 # MySQLStatusWaiter:9323 32507 Parsing spec for critical thresholds # VersionCheck:834 32507 FindBin::Bin: /usr/bin # VersionCheck:999 32507 SELECT CONCAT(@@hostname, @@port) # VersionCheck:1020 32507 MySQL instance: 23c7e718f2625bdb6868f8145330f2db db1a3306 $VAR1 = { # A => undef, # D => undef, # F => undef, # P => undef, # S => undef, # h => 'localhost', # p => '******', # t => undef, # u => undef # }; # # VersionCheck:999 32507 SELECT CONCAT(@@hostname, @@port) # VersionCheck:1020 32507 MySQL instance: 7ef6774d6e677809736f645294d0d153 db2a3306 $VAR1 = { # A => undef, # D => undef, # F => undef, # P => undef, # S => undef, # h => 'db2a', # p => '******', # t => undef, # u => 'checksum' # }; # # VersionCheck:814 32507 Version check file percona-version-check in /tmp # VersionCheck:934 32507 Version check file /tmp/percona-version-check contents: 0,1540973370 # 23c7e718f2625bdb6868f8145330f2db,1540973370 # 7ef6774d6e677809736f645294d0d153,1540973370 # VersionCheck:942 32507 Intsance 23c7e718f2625bdb6868f8145330f2db last checked 1540973370 now 1540975833 diff 2463 hours until next check 23.32 # VersionCheck:942 32507 Intsance 7ef6774d6e677809736f645294d0d153 last checked 1540973370 now 1540975833 diff 2463 hours until next check 23.32 # VersionCheck:942 32507 Intsance 0 last checked 1540973370 now 1540975833 diff 2463 hours until next check 23.32 # VersionCheck:862 32507 0 instances to check # RowChecksum:6099 32507 SELECT CRC32('test-string') # RowChecksum:6107 32507 Chosen hash func: CRC32 # RowChecksum:6147 32507 SELECT CRC32('a') bigint 10 # RowChecksum:6153 32507 crc_type: int length: 10 # Percona::XtraDB::Cluster:3870 32507 db1a SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:3872 32507 $VAR1 = [ # 'wsrep_on', # 'ON' # ]; # # Percona::XtraDB::Cluster:3861 32507 db1a SHOW VARIABLES LIKE 'wsrep_cluster_name' # SchemaIterator:7573 32507 Filter ignore-databases value: percona # SchemaIterator:7573 32507 Filter ignore-databases value: mysql # SchemaIterator:7573 32507 Filter ignore-databases value: test # SchemaIterator:7569 32507 Filter ignore-tables value: percona checksums # SchemaIterator:7573 32507 Filter ignore-engines value: federated # SchemaIterator:7573 32507 Filter ignore-engines value: mrg_myisam # SchemaIterator:7593 32507 Schema object filters: $VAR1 = { # 'ignore-databases' => { # mysql => 1, # percona => 1, # test => 1 # }, # 'ignore-engines' => { # federated => 1, # mrg_myisam => 1 # }, # 'ignore-tables' => { # percona => { # checksums => 1 # } # } # }; # # SchemaIterator:7704 32507 Getting next schema object from dbh DBI::db=HASH(0x564d9f0d5148) # SchemaIterator:7708 32507 SHOW DATABASES # SchemaIterator:7793 32507 Database information_schema is a system database, ignoring # SchemaIterator:7798 32507 Database mysql is in --ignore-databases list # SchemaIterator:7798 32507 Database percona is in --ignore-databases list # SchemaIterator:7793 32507 Database performance_schema is a system database, ignoring # SchemaIterator:7798 32507 Database test is in --ignore-databases list # SchemaIterator:7714 32507 Found 2 databases # SchemaIterator:7721 32507 Next database: phpmyadmin # SchemaIterator:7727 32507 SHOW /*!50002 FULL*/ TABLES FROM `phpmyadmin` # SchemaIterator:7745 32507 Found 19 tables in database phpmyadmin # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0d5148) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__bookmark` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `id`, `dbase`, `user`, `label`, `query` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`id`) # TableParser:4689 32507 PRIMARY key cols: `id` # TableParser:4711 32507 This key is the clustered key # SchemaIterator:7628 32507 Next schema object: phpmyadmin pma__bookmark # RowChecksum:5991 32507 Checksum strat: $VAR1 = { # crc_type => 'int', # crc_width => 16, # func => 'CRC32', # opt_slice => undef # }; # # RowChecksum:5973 32507 Row checksum: CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) # RowChecksum:6012 32507 Chunk checksum: COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__bookmark', # type => 'ALL' # }; # # NibbleIterator:6716 32507 One nibble: yes # NibbleIterator:6778 32507 Auto-selecting best index # TableParser:4565 32507 Indexes sorted best-first: PRIMARY # NibbleIterator:6811 32507 Best index: PRIMARY # NibbleIterator:6340 32507 One nibble statement: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__bookmark` /*checksum table*/ # NibbleIterator:6350 32507 Explain one nibble statement: EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__bookmark` /*explain checksum table*/ # OobNibbleIterator:7158 32507 Preparing out-of-bound statement handles # NibbleIterator:6858 32507 Preparing statement handles # TableParser:4624 32507 Checking `phpmyadmin`.`pma__bookmark` # TableParser:4630 32507 SHOW TABLES FROM `phpmyadmin` LIKE 'pma\_\_bookmark' # TableParser:4645 32507 Table phpmyadmin pma__bookmark exists # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0cd480) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__bookmark` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `id`, `dbase`, `user`, `label`, `query` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`id`) # TableParser:4689 32507 PRIMARY key cols: `id` # TableParser:4711 32507 This key is the clustered key # pt_table_checksum:10944 32507 Getting table row estimate on db2a # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__bookmark', # type => 'ALL' # }; # # pt_table_checksum:10980 32507 Table on db2a has 1 rows # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `percona` # pt_table_checksum:11046 32507 DELETE FROM `percona`.`checksums` WHERE db = ? AND tbl = ? # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `phpmyadmin` # NibbleIterator:6532 32507 init callback returned 1 # NibbleIterator:6568 32507 Nibble: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__bookmark` /*checksum table*/ params: # pt_table_checksum:12290 32507 EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__bookmark` /*explain checksum table*/ params: # pt_table_checksum:12300 32507 EXPLAIN plan: $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__bookmark', # type => 'ALL' # }; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Retry:8000 32507 Try 1 of 2 # pt_table_checksum:11669 32507 REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`dbase` using utf8mb4), convert(`user` using utf8mb4), convert(`label` using utf8mb4), CRC32(`query`))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__bookmark` /*checksum table*/ lower boundary: upper boundary: # pt_table_checksum:11690 32507 SHOW WARNINGS # Retry:8017 32507 Try code succeeded # pt_table_checksum:11161 32507 Nibble time: 0.0059349536895752 # NibbleIterator:6576 32507 0 rows in nibble 1 # NibbleIterator:6588 32507 No rows in nibble or nibble skipped # ReplicaLagWaiter:8652 32507 All slaves caught up # MySQLStatusWaiter:9413 32507 Checking status variables # pt_table_checksum:10730 32507 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:9416 32507 Threads_running = 1 # MySQLStatusWaiter:9443 32507 All var vals are low enough # OobNibbleIterator:7199 32507 Done nibbling past boundaries # NibbleIterator:6597 32507 Done nibbling # pt_table_checksum:11285 32507 Checking slave diffs # MasterSlave:5481 32507 DBI::db=HASH(0x564d9f0d5148) SHOW MASTER STATUS # MasterSlave:5485 32507 # MasterSlave:5489 32507 Server on dbh DBI::db=HASH(0x564d9f0d5148) does not seem to be a master # VersionParser:4304 32507 VersionParser got a dbh, trying to get the version # VersionParser:4352 32507 InnoDB support: DEFAULT # VersionParser:4364 32507 InnoDB version: 5.6.36-82.1 # OobNibbleIterator:7207 32507 Finish nibble_sth # OobNibbleIterator:7207 32507 Finish explain_nibble_sth 10-31T09:50:33 Error checksumming table phpmyadmin.pma__bookmark: Use of uninitialized value in concatenation (.) or string at /usr/bin/pt-table-checksum line 5521. TS ERRORS DIFFS ROWS DIFF_ROWS CHUNKS SKIPPED TIME TABLE 10-31T09:50:33 1 0 0 0 1 0 0.027 phpmyadmin.pma__bookmark # SchemaIterator:7704 32507 Getting next schema object from dbh DBI::db=HASH(0x564d9f0d5148) # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0d5148) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__central_columns` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `db_name`, `col_name`, `col_type`, `col_length`, `col_collation`, `col_isnull`, `col_extra`, `col_default` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`db_name`,`col_name`) # TableParser:4689 32507 PRIMARY key cols: `db_name`, `col_name` # TableParser:4711 32507 This key is the clustered key # SchemaIterator:7628 32507 Next schema object: phpmyadmin pma__central_columns # RowChecksum:5991 32507 Checksum strat: $VAR1 = { # crc_type => 'int', # crc_width => 16, # func => 'CRC32', # opt_slice => undef # }; # # RowChecksum:5973 32507 Row checksum: CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) # RowChecksum:6012 32507 Chunk checksum: COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__central_columns` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__central_columns', # type => 'ALL' # }; # # NibbleIterator:6716 32507 One nibble: yes # NibbleIterator:6778 32507 Auto-selecting best index # TableParser:4565 32507 Indexes sorted best-first: PRIMARY # NibbleIterator:6811 32507 Best index: PRIMARY # NibbleIterator:6340 32507 One nibble statement: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__central_columns` /*checksum table*/ # NibbleIterator:6350 32507 Explain one nibble statement: EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__central_columns` /*explain checksum table*/ # OobNibbleIterator:7158 32507 Preparing out-of-bound statement handles # NibbleIterator:6858 32507 Preparing statement handles # TableParser:4624 32507 Checking `phpmyadmin`.`pma__central_columns` # TableParser:4630 32507 SHOW TABLES FROM `phpmyadmin` LIKE 'pma\_\_central\_columns' # TableParser:4645 32507 Table phpmyadmin pma__central_columns exists # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0cd480) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__central_columns` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `db_name`, `col_name`, `col_type`, `col_length`, `col_collation`, `col_isnull`, `col_extra`, `col_default` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`db_name`,`col_name`) # TableParser:4689 32507 PRIMARY key cols: `db_name`, `col_name` # TableParser:4711 32507 This key is the clustered key # pt_table_checksum:10944 32507 Getting table row estimate on db2a # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__central_columns` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__central_columns', # type => 'ALL' # }; # # pt_table_checksum:10980 32507 Table on db2a has 1 rows # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `percona` # pt_table_checksum:11046 32507 DELETE FROM `percona`.`checksums` WHERE db = ? AND tbl = ? # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `phpmyadmin` # NibbleIterator:6532 32507 init callback returned 1 # NibbleIterator:6568 32507 Nibble: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__central_columns` /*checksum table*/ params: # pt_table_checksum:12290 32507 EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__central_columns` /*explain checksum table*/ params: # pt_table_checksum:12300 32507 EXPLAIN plan: $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__central_columns', # type => 'ALL' # }; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Retry:8000 32507 Try 1 of 2 # pt_table_checksum:11669 32507 REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', convert(`db_name` using utf8mb4), convert(`col_name` using utf8mb4), convert(`col_type` using utf8mb4), CRC32(`col_length`), convert(`col_collation` using utf8mb4), `col_isnull`, convert(`col_extra` using utf8mb4), CRC32(`col_default`), CONCAT(ISNULL(`col_length`), ISNULL(`col_extra`), ISNULL(`col_default`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__central_columns` /*checksum table*/ lower boundary: upper boundary: # pt_table_checksum:11690 32507 SHOW WARNINGS # Retry:8017 32507 Try code succeeded # pt_table_checksum:11161 32507 Nibble time: 0.00430488586425781 # NibbleIterator:6576 32507 0 rows in nibble 1 # NibbleIterator:6588 32507 No rows in nibble or nibble skipped # ReplicaLagWaiter:8652 32507 All slaves caught up # MySQLStatusWaiter:9413 32507 Checking status variables # pt_table_checksum:10730 32507 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:9416 32507 Threads_running = 1 # MySQLStatusWaiter:9443 32507 All var vals are low enough # OobNibbleIterator:7199 32507 Done nibbling past boundaries # NibbleIterator:6597 32507 Done nibbling # pt_table_checksum:11285 32507 Checking slave diffs # MasterSlave:5475 32507 Server on dbh DBI::db=HASH(0x564d9f0d5148) is not a master # OobNibbleIterator:7207 32507 Finish nibble_sth # OobNibbleIterator:7207 32507 Finish explain_nibble_sth 10-31T09:50:33 Error checksumming table phpmyadmin.pma__central_columns: I need a master_status argument at /usr/bin/pt-table-checksum line 5500. 10-31T09:50:33 1 0 0 0 1 0 0.017 phpmyadmin.pma__central_columns # SchemaIterator:7704 32507 Getting next schema object from dbh DBI::db=HASH(0x564d9f0d5148) # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0d5148) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__column_info` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `id`, `db_name`, `table_name`, `column_name`, `comment`, `mimetype`, `transformation`, `transformation_options`, `input_transformation`, `input_transformation_options` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`id`), # TableParser:4689 32507 PRIMARY key cols: `id` # TableParser:4711 32507 This key is the clustered key # TableParser:4669 32507 Parsed key: UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`) # TableParser:4689 32507 db_name key cols: `db_name`, `table_name`, `column_name` # SchemaIterator:7628 32507 Next schema object: phpmyadmin pma__column_info # RowChecksum:5991 32507 Checksum strat: $VAR1 = { # crc_type => 'int', # crc_width => 16, # func => 'CRC32', # opt_slice => undef # }; # # RowChecksum:5973 32507 Row checksum: CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) # RowChecksum:6012 32507 Chunk checksum: COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__column_info` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__column_info', # type => 'ALL' # }; # # NibbleIterator:6716 32507 One nibble: yes # NibbleIterator:6778 32507 Auto-selecting best index # TableParser:4565 32507 Indexes sorted best-first: PRIMARY, db_name # NibbleIterator:6811 32507 Best index: PRIMARY # NibbleIterator:6340 32507 One nibble statement: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__column_info` /*checksum table*/ # NibbleIterator:6350 32507 Explain one nibble statement: EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__column_info` /*explain checksum table*/ # OobNibbleIterator:7158 32507 Preparing out-of-bound statement handles # NibbleIterator:6858 32507 Preparing statement handles # TableParser:4624 32507 Checking `phpmyadmin`.`pma__column_info` # TableParser:4630 32507 SHOW TABLES FROM `phpmyadmin` LIKE 'pma\_\_column\_info' # TableParser:4645 32507 Table phpmyadmin pma__column_info exists # TableParser:4435 32507 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:4440 32507 DBI::db=HASH(0x564d9f0cd480) USE `phpmyadmin` # TableParser:4444 32507 SHOW CREATE TABLE `phpmyadmin`.`pma__column_info` # TableParser:4454 32507 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4486 32507 Table cols: `id`, `db_name`, `table_name`, `column_name`, `comment`, `mimetype`, `transformation`, `transformation_options`, `input_transformation`, `input_transformation_options` # TableParser:4653 32507 Storage engine: InnoDB # TableParser:4669 32507 Parsed key: PRIMARY KEY (`id`), # TableParser:4689 32507 PRIMARY key cols: `id` # TableParser:4711 32507 This key is the clustered key # TableParser:4669 32507 Parsed key: UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`) # TableParser:4689 32507 db_name key cols: `db_name`, `table_name`, `column_name` # pt_table_checksum:10944 32507 Getting table row estimate on db2a # NibbleIterator:6846 32507 EXPLAIN SELECT * FROM `phpmyadmin`.`pma__column_info` WHERE 1=1 # NibbleIterator:6848 32507 $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__column_info', # type => 'ALL' # }; # # pt_table_checksum:10980 32507 Table on db2a has 1 rows # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `percona` # pt_table_checksum:11046 32507 DELETE FROM `percona`.`checksums` WHERE db = ? AND tbl = ? # pt_table_checksum:12204 32507 use_repl_db # pt_table_checksum:12225 32507 USE `phpmyadmin` # NibbleIterator:6532 32507 init callback returned 1 # NibbleIterator:6568 32507 Nibble: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__column_info` /*checksum table*/ params: # pt_table_checksum:12290 32507 EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__column_info` /*explain checksum table*/ params: # pt_table_checksum:12300 32507 EXPLAIN plan: $VAR1 = { # extra => '', # id => 1, # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => 1, # select_type => 'SIMPLE', # table => 'pma__column_info', # type => 'ALL' # }; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Quoter:4123 32507 Serializing $VAR1 = []; # # Retry:8000 32507 Try 1 of 2 # pt_table_checksum:11669 32507 REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`, convert(`db_name` using utf8mb4), convert(`table_name` using utf8mb4), convert(`column_name` using utf8mb4), convert(`comment` using utf8mb4), convert(`mimetype` using utf8mb4), convert(`transformation` using utf8mb4), convert(`transformation_options` using utf8mb4), convert(`input_transformation` using utf8mb4), convert(`input_transformation_options` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `phpmyadmin`.`pma__column_info` /*checksum table*/ lower boundary: upper boundary: # pt_table_checksum:11690 32507 SHOW WARNINGS # Retry:8017 32507 Try code succeeded # pt_table_checksum:11161 32507 Nibble time: 0.00444889068603516 # NibbleIterator:6576 32507 0 rows in nibble 1 # NibbleIterator:6588 32507 No rows in nibble or nibble skipped # ReplicaLagWaiter:8652 32507 All slaves caught up # MySQLStatusWaiter:9413 32507 Checking status variables # pt_table_checksum:10730 32507 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:9416 32507 Threads_running = 1 # MySQLStatusWaiter:9443 32507 All var vals are low enough # OobNibbleIterator:7199 32507 Done nibbling past boundaries # NibbleIterator:6597 32507 Done nibbling # pt_table_checksum:11285 32507 Checking slave diffs # MasterSlave:5475 32507 Server on dbh DBI::db=HASH(0x564d9f0d5148) is not a master # OobNibbleIterator:7207 32507 Finish explain_nibble_sth # OobNibbleIterator:7207 32507 Finish nibble_sth 10-31T09:50:33 Error checksumming table phpmyadmin.pma__column_info: I need a master_status argument at /usr/bin/pt-table-checksum line 5500.