Comment 3 for bug 882988

Revision history for this message
Oleg Tsarev (tsarev) wrote : Re: [Bug 882988] Re: Unknown system variable sql_slave_statement_skip_counter

This is really dangerous feature with really rarely usage.
Can you please describe the use-case where you REALLY requires this?
May be I omited some usefull scenarios, but from my point of view this
feature not very usefull and better to include another or RBR features
(and so spend time to it instead of this feature).

On Wed, Nov 2, 2011 at 9:25 AM, Adam Wróbel <email address hidden> wrote:
> when this will be available in the 5.5 series? This  feature is critical
> for replication.
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https://bugs.launchpad.net/bugs/882988
>
> Title:
>  Unknown system variable sql_slave_statement_skip_counter
>
> Status in Percona Server with XtraDB:
>  New
>
> Bug description:
>  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)
>
>
>  mysql> set global sql_slave_statement_skip_counter=1;
>  ERROR 1193 (HY000): Unknown system variable 'sql_slave_statement_skip_counter'
>
>  http://www.percona.com/doc/percona-
>  server/5.5/flexibility/replication_skip_single_statement.html?id
>  =percona-
>  server:features:replication_skip_single_statement&redirect=1#sql_slave_statement_skip_counter
>
>  This variable doesn't work?
>
>  I have enable:
>  server-id=2
>  relay-log=mysqld-relay-bin
>  plugin-load=rpl_semi_sync_master=semisync_master.so
>  plugin-load=rpl_semi_sync_slave=semisync_slave.so
>  rpl_semi_sync_master_enabled=1
>  rpl_semi_sync_slave_enabled=1
>  binlog_format=row
>
>  log-bin = /var/mysql/mysql_binlog/bin.log
>  log-slave-updates
>  log-bin-index = /var/mysql/mysql_binlog/log-bin.index
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/882988/+subscriptions
>

--
Oleg Tsarev, Software Engineer, Percona Inc.