MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Privileges Required
  • SUPER
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

SET GLOBAL SQL_SLAVE_SKIP_COUNTER Statement

This MySQL statement skips the given number of events from the master.

hits past month: 9 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Replication

Syntax

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = number

Explanation

This MySQL statement skips the given number of events from a master server running replication. It is used for fine tunning a recovery. It returns an error if the slave thread is running.

Examples

Below is an example of this MySQL statement:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=10;
Return to MySQL Replication page of our MySQL Documentation