Shulou(Shulou.com)06/01 Report--

Wait_timeout

Wait for timeout, so what is mysql waiting for? To be exact, mysql is waiting for a user's request (query). If it is found that a thread has been sleep for longer than wait_timeout, the thread will be cleaned up. This value shall prevail in both swap mode and non-swap mode. Wait_timeout is a session-level variable.

Net_write_timeout

"The number of seconds to wait for a block to be written to a connection before aborting the write." The timeout for waiting for a block to be sent to the client is usually when the network conditions are poor, or when the client takes a long time to process each block, the connection interruption caused by net_write_timeout is easy to occur.

Net_read_timeout

"The number of seconds to wait fprintfor more data from a connection before aborting the read." The waiting time for Mysql to read data is timed out, which may be due to a network exception or a busy client-side or server unable to send or receive processing packets in time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.