Name

SET GLOBAL SQL_SLAVE_SKIP_COUNTER

Synopsis

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = number

This statement skips the given number of events from the master. It is used for fine-tuning a recovery. It returns an error if the slave thread is running. Here is an example:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=10;

Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial