Hello,
According to documentation,
*"When using this statement, it is important to understand that the binary
log is actually organized as a sequence of groups known as event groups.
Each event group consists of a sequence of events.
For transactional tables, an event group corresponds to a transaction.
For nontransactional tables, an event group corresponds to a single SQL
statement."*
*
When you use SET GLOBAL sql_slave_skip_counter to skip events and the result
is in the middle of a group, the slave continues to skip events until it
reaches the end of the group. Execution then starts with the next event
group.
**set global sql_slave_skip_counter=N;
*mean following:
*Skip N event from "event group", except situation, when skip N events from
"event group" doesn't reach end of group.
*
*
*"Event group" definition depends from binary log format.
What the replication binlog format?
1) Statement based replication.
One "event group" == "single transaction" for transactional tables.
One "event group" == "single statement" from non-transactional tables.
2) Row based repliation
One "event group" == "single transaction" for transcational tables.
One "event group" == "single row event" for non-transactional tables.
*but note*: If you have same events on the line ("Update_rows_log_event",
"Update_rows_log_event"), then this events was merged to single.
3) Mixed based replication.
Depends from format of current event.
Best regards, Oleg.
2011/6/11 Tim Dunphy <bluethundr@stripped>:
> hello!
>
> I am attempting to reset the error message on a slave. however when I try
to do this using the SET GLOBAL sql_slave_skip_counter = N command it is
having no effect. Replication is not broken on the slave and the binlog
pointer is keeping pace with the master.
>
>
>
>
> ## still seeing resolved replication errors
>
> Slave_IO_State: Waiting for master to send event
>
>
> Last_Errno: 1146
> Last_Error: Error 'Table 'jfwiki.site_stats' doesn't
exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
ss_total_views=ss_total_views+1'
> Skip_Counter: 0
> Exec_Master_Log_Pos: 41551
> Relay_Log_Space: 452249
> Until_Condition: None
>
> Last_SQL_Errno: 1146
> Last_SQL_Error: Error 'Table 'jfwiki.site_stats' doesn't
exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
ss_total_views=ss_total_views+1'
> Replicate_Ignore_Server_Ids:
>
>
> ## trying to reset the error
>
> mysql> stop slave;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> SET GLOBAL sql_slave_skip_counter = 1;
> Query OK, 0 rows affected (0.00 sec)
>
>
> mysql> start slave;
> Query OK, 0 rows affected (0.00 sec)
>
>
> ## error remains
>
>
> Slave_IO_State: Waiting for master to send event
>
>
> Last_Errno: 1146
> Last_Error: Error 'Table 'jfwiki.site_stats' doesn't
exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
ss_total_views=ss_total_views+1'
> Skip_Counter: 0
> Exec_Master_Log_Pos: 41551
> Relay_Log_Space: 452249
> Until_Condition: None
>
> Last_SQL_Errno: 1146
> Last_SQL_Error: Error 'Table 'jfwiki.site_stats' doesn't
exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
ss_total_views=ss_total_views+1'
> Replicate_Ignore_Server_Ids:
>
>
> ## binlog pointer is keeping pace with the master
>
> File: mysqld-bin.000002
> Position: 665042
>
> ---------------------------------
> Read_Master_Log_Pos: 665042
>
>
> Thank you for any tips you might be able to share on this!
>
> tim
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
http://lists.mysql.com/replication?unsub=1
>
>
--
Oleg Tsarev, Software Engineer, Percona Inc.
