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?
A.
Disconnecting idle localhost client sessions
B.
Implementing storage engine data compression options
C.
Relocating your data and log files to separate storage devices
D.
Activating the MySQL Enterprise thread pool plugin
Explanation:
Should be A, since one mysql table is mapping to one file, disconnect the idle session will release file handlers in use.
It’s A becouse connections from localhost are made by the socket and every connection is an open file.
D
+1 – D. Best answer
Some application context has to be considered in disconnecting “idle” connections.
{
nba 2k16 mt generator ps4 https://simply-communicate.com/nba-2k16-mt-play-video-games
D