pt-tables-checksum: 3.5.5
mysql server: 5.7.25
command: pt-table-checksum --no-check-replication-filter --recursion-method=hosts --databases=xxxx S=/var/run/mysqld/mysqld.sock,u=root,p=xxxxx
but just show like this
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
then i add PTDEBUG=1 show like this
pt_table_checksum:12593 2924260 Sleep 1.25 waiting for chunks
pt_table_checksum:12537 2924260 Getting last checksum on node2
pt_table_checksum:12540 2924260 node2 max chunk: undef
pt_table_checksum:12593 2924260 Sleep 1.25 waiting for chunks
pt_table_checksum:12537 2924260 Getting last checksum on node2
pt_table_checksum:12540 2924260 node2 max chunk: undef
pt_table_checksum:12593 2924260 Sleep 1.25 waiting for chunks
pt_table_checksum:12537 2924260 Getting last checksum on node2
pt_table_checksum:12540 2924260 node2 max chunk: undef
pt_table_checksum:12593 2924260 Sleep 1.25 waiting for chunks
pt_table_checksum:12537 2924260 Getting last checksum on node2
pt_table_checksum:12540 2924260 node2 max chunk: undef
pt_table_checksum:12593 2924260 Sleep 1.25 waiting for chunks
I don’t understand what is max chunk on node2?
node2 is mysql slave server,so i check document for mysql or percona toolkits,
can’t which is def max chunk?
Hi @yyu0378
Since you’re using --recursion-method=hosts it will try to check all the replicas that this command shows:
SHOW SLAVE HOSTS;
Please see the replicas shown in the output and confirm you are able to connect to that IP from the same server where you’re running the command.
yes.I can connect slave server by hostname
SHOW SLAVE HOSTS; command can get slave hosts,like this
| Server_id | Host | Port | Master_id | Slave_UUID |
±----------±------±-----±----------±-------------------------------------+
| 2 | node2 | 3306 | 1 | 73e5d4f5-666e-11ee-89e3-00505697151d
when use PTDEUG=1,get this log
$DBD::mysql::VERSION: 4.050 $DBI::VERSION: 1.643
MasterSlave:5589 3882868 DBI::db=HASH(0x56005eb2a9c8) SHOW MASTER STATUS
MasterSlave:5593 3882868 Position=51068858 Binlog_Do_DB= Executed_Gtid_Set= Binlog_Ignore_DB=mysql File=mysql-bin.000003
MasterSlave:5533 3882868 DBI::db=HASH(0x56005eabe838) SHOW SLAVE STATUS
VersionParser:4351 3882868 VersionParser got a dbh, trying to get the version
VersionParser:4399 3882868 InnoDB support: DEFAULT
VersionParser:4411 3882868 InnoDB version: 5.7.25
MasterSlave:5630 3882868 DBI::db=HASH(0x56005eabe838) SELECT MASTER_POS_WAIT(‘mysql-bin.000003’, 51068858, 60 )
MasterSlave:5636 3882868 Result of waiting: 1
MasterSlave:5637 3882868 Waited 1 seconds
Active dbh: DBI::db=HASH(0x56005eb2a9c8)
Active sth: DBI::st=HASH(0x56005ee52fe0) SHOW MASTER STATUS
pt_table_checksum:12519 3882868 SELECT MAX(chunk) FROM percona.checksums WHERE db=‘staging’ AND tbl=‘acq_acquire_event’ AND master_crc IS NOT NULL
pt_table_checksum:12537 3882868 Getting last checksum on node2
pt_table_checksum:12540 3882868 node2 max chunk: undef
pt_table_checksum:12593 3882868 Sleep 0.25 waiting for chunks
pt_table_checksum:12537 3882868 Getting last checksum on node2
pt_table_checksum:12540 3882868 node2 max chunk: undef
pt_table_checksum:12593 3882868 Sleep 0.5 waiting for chunks
pt_table_checksum:12537 3882868 Getting last checksum on node2
pt_table_checksum:12540 3882868 node2 max chunk: undef
there is SHOW SALVE STATUS,get mysql version is 2.5.7-25,so i not sure this version is get from slave service.