Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 68

Which step or set of steps can be used to rotate the error log?

Execute SET GLOBAL log_error = ‘’.

Execute SET GLOBAL max_error_count = .

Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.

Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Correct Answer: D

To rotate the error log in MySQL, you should rename the error log file on disk and then execute FLUSH ERROR LOGS. This forces MySQL to create a new error log file and start logging errors there, effectively rotating the log.

Discussion

FelipeKOption: D

https://dev.mysql.com/doc/refman/8.0/en/error-log-rotation.html