Oracle
1Z0-883 · Question #51
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles…
The correct answer is A. Disconnecting idle localhost client sessions. See the full explanation below for the reasoning.
Question
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?
Options
- ADisconnecting idle localhost client sessions
- BImplementing storage engine data compression options
- CRelocating your data and log files to separate storage devices
- DActivating the MySQL Enterprise thread pool plugin
How the community answered
(46 responses)- A83% (38)
- B11% (5)
- C2% (1)
- D4% (2)
Community Discussion
No community discussion yet for this question.