MySQL :: MySQL 5.6 リファレンスマニュアル :: 13.4.2.2 MASTER_POS

8.0 English
5.7 English
5.6 English
5.5 English

MySQL 5.6 リファレンスマニュアル / ... / MASTER_POS_WAIT() 構文

13.4.2.2 MASTER_POS_WAIT() 構文

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

これはステートメントではなく、実際には関数です。これは、スレーブがマスターのバイナリログ内の特定の位置までのイベントを読み取って実行したことを確認するために使用されます。完全な説明については、セクション12.18「その他の関数」を参照してください。

PREV HOME UP NEXT

User Comments

Posted by Nathan Tanner on August 9, 2003

NOTE: If you have a cyclical replication setup (ie. more then two servers in a replication chain) do *NOT* rely on 'SHOW MASTER STATUS' on the slave's MASTER for values to use in the master_pos_wait function. This is because if the slave had just finished executing a binlog event that didn't originally come from its own MASTER, the master_log_pos value to be used in this function won't work. I feel this is a bug, but it is apparently designed to work this way. Don't ask me why.

Posted by Jeff C on December 9, 2005

WARNING: does not block if slave errors.

If show slave status is reporting an error, function returns instantly.