What is the result?

A user executes the statement;
PURGE BINARY LOGS TO ‘mysql-bin.010’;
What is the result?

A user executes the statement;
PURGE BINARY LOGS TO ‘mysql-bin.010’;
What is the result?

A.
It deletes all binary log files, except ‘mysql-in.010’.

B.
It deletes all binary log files up to and including ‘mysql-bin.010’.

C.
It deletes all binary log files before ‘mysql-bin.010’.

D.
It deletes all binary log files after ‘mysql-bin.010’.

Explanation:
Reference: http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Ispanico

Ispanico

I agree C
The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name