All Products
Search
Document Center

ApsaraDB RDS:Timeout parameters of an ApsaraDB RDS for MySQL instance

Last Updated:Aug 24, 2023

This topic describes the timeout parameters of an ApsaraDB RDS for MySQL instance.

Note The value of each timeout parameter is in seconds.
ParameterDescription
connect_timeoutThis parameter specifies the period of time during which the client can wait for a three-way handshake to complete when the client attempts to establish a connection to the RDS instance. If a connection times out because of poor network quality, we recommend that you increase the value of this parameter.
delayed_insert_timeoutThis parameter specifies the period of time during which the system can wait for the INSERT statement to be executed.
innodb_lock_wait_timeoutThis parameter specifies the period of time during which a transaction can wait for another transaction to release the shared or exclusive lock on the requested resource. A shared lock or an exclusive lock is different from a deadlock.
innodb_rollback_on_timeoutThis parameter controls the behavior of the transaction when lock waits or timeouts occur. If this parameter is set to ON, the entire transaction for the current session is rolled back. If this parameter is set to OFF, only the last statement on a transaction is rolled back.
interactive_timeout

wait_timeout

These parameters specify the period of time for which the RDS instance can wait before the RDS instance closes an interactive connection or a non-interactive connection. We recommend that you do not set these parameters to large values. If you set these parameters to large values, the maximum number of connections that are allowed by the RDS instance may be depleted.
lock_wait_timeoutThis parameter specifies the period of time after which a metadata lock times out.
net_read_timeout

net_write_timeout

These parameters specify the period of time for which the RDS instance can wait before the network packets sent from the client are received and specify the period of time for which the RDS instance can wait before the network packets destined for the client are sent. These parameters are valid only for TCP/IP connections and the threads in the Activity state.
slave_net_timeoutThis parameter specifies the period of time during which a secondary RDS instance can wait before it establishes a connection to synchronize data with its primary RDS instance. If the connection times out, ApsaraDB RDS re-establishes the connection.

References

Modify the parameters of an ApsaraDB RDS for MySQL instance