This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

13.4.2.4 MASTER_POS_WAIT() Syntax

SELECT MASTER_POS_WAIT('master_log_file', master_log_pos [, timeout])

This is actually a function, not a statement. It is used to ensure that the slave has read and executed events up to a given position in the master's binary log. See Section 12.15, “Miscellaneous Functions”, for a full description.

The following table shows the maximum permissible length for the string-valued options.

OptionMaximum Length
MASTER_HOST60
MASTER_USER16
MASTER_PASSWORD32
MASTER_LOG_FILE255
RELAY_LOG_FILE255
MASTER_SSL_CA255
MASTER_SSL_CAPATH255
MASTER_SSL_CERT255
MASTER_SSL_KEY255
MASTER_SSL_CIPHER511