Hi All. I use: percona-toolkit-2.2.4-1.noarch Percona-Server-server-55-5.5.28-rel29.1.335.rhel6.x86_64 Percona-Server-shared-compat-5.5.28-rel29.1.335.rhel6.x86_64 Percona-Server-client-55-5.5.28-rel29.1.335.rhel6.x86_64 Percona-Server-shared-55-5.5.28-rel29.1.335.rhel6.x86_64 on Centos 6.3 2.6.32-279.14.1.el6.x86_64
I have created checksum table and tried to use --ignore-tables-regex to remove some tables from checking. pt-table-checksum --chunk-size-limit=9999 --nocheck-plan --replicate-check --ignore-tables-regex=^test.s_.*_tmp$ --ignore-tables=test.catalogsearch_fulltext,test.catalogsearch_result,test.report_event,test.report_viewed_product_index,test.z_crawler_log,test.z_logger_debug_ajax,test.z_crawler_queue,test.catalog_category_anc_categs_index_tmp,test.catalog_category_anc_products_index_tmp,test.catalog_category_product_index_enbl_tmp,test.catalog_category_product_index_tmp,test.catalog_product_index_eav_decimal_tmp,test.catalog_product_index_eav_tmp,test.catalog_product_index_price_bundle_opt_tmp,test.catalog_product_index_price_bundle_sel_tmp,test.catalog_product_index_price_bundle_tmp,test.catalog_product_index_price_cfg_opt_agr_tmp,test.catalog_product_index_price_cfg_opt_tmp,test.catalog_product_index_price_downlod_tmp,test.catalog_product_index_price_final_tmp,test.catalog_product_index_price_opt_agr_tmp,test.catalog_product_index_price_opt_tmp,test.catalog_product_index_price_tmp,test.cataloginventory_stock_status_tmp,test.z_I04_data_for_crawler,test.z_import_prices_mdk,test.z_import_prices_sku,test.z_import_translations,test.z_import_translations_model --recursion-method dsn=h=localhost,D=percona,t=dsns --user=percona --password=percona --nocheck-replication-filters --databases=test,mysql localhost But it does not work, for example table test.s_xxx_tmp gives error message: 09-18T03:10:47 Skipping table test.s_xxx_tmp because it has problems on these replicas: Table test.s_xxx_tmp does not exist on replica server.local This can break replication. If you understand the risks, specify --no-check-slave-tables to disable this check. 09-18T03:10:47 Error checksumming table test.s_xxx_tmp: DBD::mysql::db selectrow_hashref failed: Tab le 'test.s_xxx_tmp' doesn't exist [for Statement "EXPLAIN SELECT * FROM `test`.`s_xxx_tmp` WHERE 1=1"] at /usr/bin/pt-table-checksum line 6528. I've tried --ignore-tables-regex= multiple times: ^test.s_.*_tmp$ '^test.s_.*_tmp$' ^test.s_.\*_tmp$ ^test.s_\.\*_tmp$ but without good result. What is the correct syntax in this case? Best regards, Rafal Radecki.