Valid 1z0-883 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-883 Exam! ExamDiscuss.com now offer the newest 1z0-883 exam dumps, the ExamDiscuss.com 1z0-883 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-883 dumps with Test Engine here:
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?
Correct Answer: A,B
Explanation/Reference: A: To safely purge binary log files, follow this procedure: 1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading. 2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS. 3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list. 4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.) 5. Purge all log files up to but not including the target file. B: Syntax: PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } Reference: 13.4.1.1 PURGE BINARY LOGS Syntax