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)- A69% (9)
- B15% (2)
- C8% (1)
- F8% (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.