SHOW RELAYLOG EVENTS [IN 'log_name
'] [FROMpos
] [LIMIT [offset
,]row_count
]
Shows the events in the relay log of a replication slave. If you
do not specify
'
, the
first relay log is displayed. This statement has no effect on
the master.
log_name
'
The LIMIT
clause has the same syntax as for
the SELECT
statement. See
Section 12.2.9, “SELECT
Syntax”.
Issuing a SHOW RELAYLOG EVENTS
with no LIMIT
clause could start a very
time- and resource-consuming process because the server
returns to the client the complete contents of the relay log
(including all statements modifying data that have been
received by the slave).
User Comments
Add your own comment.