nerdexam
Oracle

1Z0-908 · Question #72

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently. Which two sets of actions when completed will accomplish this? (Choose two.)

The correct answer is A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server. D. Use SET PERSIST binlog_expire_logs_seconds=<value>. https://severalnines.com/database-blog/my-mysql-database-out-disk-space

Replication

Question

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently. Which two sets of actions when completed will accomplish this? (Choose two.)

Options

  • AUse SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
  • BSet binlog_expire_logs_seconds in my.cnf.
  • CSet binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
  • DUse SET PERSIST binlog_expire_logs_seconds=<value>.
  • EUse PURGE BINARY LOGS to <binlog_name>.
  • FUse SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS

How the community answered

(13 responses)
  • A
    69% (9)
  • B
    15% (2)
  • C
    8% (1)
  • F
    8% (1)

Explanation

https://severalnines.com/database-blog/my-mysql-database-out-disk-space

Topics

#binary logs#binlog_expire_logs_seconds#PURGE BINARY LOGS#log space management

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice