Hi,
i want to use sql_slave_statement_skip_counter variable: http://www.percona.com/doc/percona-server/5.5/flexibility/re plication_skip_single_statement.html?id=percona-server:featu res:replication_skip_single_statement&redirect=1#sql_sla ve_statement_skip_counter
but percona says:
ERROR 1193 (HY000): Unknown system variable ‘sql_slave_statement_skip_counter’
I have centos 6 percona install via yum
Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64
Percona-Server-server-55-5.5.16-rel22.0.189.rhel6.x86_64
percona-release-0.0-1.x86_64
Percona-Server-client-55-5.5.16-rel22.0.189.rhel6.x86_64
Percona-Server-test-55-5.5.16-rel22.0.189.rhel6.x86_64
Percona-Server-devel-55-5.5.16-rel22.0.189.rhel6.x86_64
Percona-Server-shared-compat-5.5.16-rel22.0.189.rhel6.x86_64
mysql> SHOW VARIABLES LIKE ‘%skip%’;
±-----------------------±------+
| Variable_name | Value |
±-----------------------±------+
| skip_external_locking | ON |
| skip_name_resolve | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_skip_errors | OFF |
| sql_slave_skip_counter | 0 |
±-----------------------±------+
6 rows in set (0.00 sec)