nerdexam
Oracle

1Z0-908 · Question #62

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

The correct answer is D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS. https://blog.pythian.com/mysql-log-rotation/

Monitoring

Question

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

Options

  • AExecute SET GLOBAL log_error = `<new error log file>'.
  • BExecute SET GLOBAL max_error_count = <number of messages at point to rotate>.
  • CExecute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
  • DRename the error log file on disk, and then execute FLUSH ERROR LOGS.

How the community answered

(58 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    3% (2)
  • D
    93% (54)

Explanation

https://blog.pythian.com/mysql-log-rotation/

Topics

#error log#FLUSH ERROR LOGS#log rotation#log management

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice