check table from wcdb-slave2:
mysql root@localhost [wc_miehr_mhpc]> check table patient_pdups; +-----------------------------+-------+----------+-------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+-------+----------+-------------------------------------------------------------+ | wc_miehr_mhpc.patient_pdups | check | Warning | InnoDB: Index 'idx2' contains 3927 entries, should be 4069. | | wc_miehr_mhpc.patient_pdups | check | Warning | InnoDB: Index 'idx3' contains 3817 entries, should be 4069. | | wc_miehr_mhpc.patient_pdups | check | error | Corrupt | +-----------------------------+-------+----------+-------------------------------------------------------------+ 3 rows in set (0.01 sec)
check table from wcdb-slave2:
mysql root@localhost [wc_miehr_mhpc]> check table patient_pdups; ------- ------- ------- --+---- ---+--- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ------- --+---- ---+--- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------+ mhpc.patient_ pdups | check | Warning | InnoDB: Index 'idx2' contains 3927 entries, should be 4069. | mhpc.patient_ pdups | check | Warning | InnoDB: Index 'idx3' contains 3817 entries, should be 4069. | mhpc.patient_ pdups | check | error | Corrupt | ------- ------- ------- --+---- ---+--- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------+
+------
| Table | Op | Msg_type | Msg_text |
+------
| wc_miehr_
| wc_miehr_
| wc_miehr_
+------
3 rows in set (0.01 sec)