Announcement

Announcement Module
Collapse
No announcement yet.

sql_slave_statement_skip_counter variable not found 5.5

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql_slave_statement_skip_counter variable not found 5.5

    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)

  • #2
    Could you execute this query?
    SHOW VARIABLES LIKE "%version%";

    When do you get that message? Do read the comment at http://dev.mysql.com/doc/refman/5.1/en/set-global-sql-slave- skip-counter.html

    Comment


    • #3
      mysql> SHOW VARIABLES LIKE "%version%";
      +-------------------------+--------------------------------- --------------------+
      | Variable_name | Value |
      +-------------------------+--------------------------------- --------------------+
      | innodb_version | 1.1.8-20.1 |
      | protocol_version | 10 |
      | slave_type_conversions | |
      | version | 5.5.16-55-log |
      | version_comment | Percona Server (GPL), Release rel22.0, Revision 189 |
      | version_compile_machine | x86_64 |
      | version_compile_os | Linux |
      +-------------------------+--------------------------------- --------------------+
      7 rows in set (0.00 sec)


      I want to use sql_slave_statement_skip_counter not sql_slave_skip_counter, sql_slave_skip_counter works fine but lose data.

      Comment

      Working...
      X