This topic describes the timeout parameters of an ApsaraDB RDS for MySQL instance.
Note The value of each timeout parameter is in seconds.
Parameter | Description |
connect_timeout | This 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_timeout | This parameter specifies the period of time during which the system can wait for the INSERT statement to be executed. |
innodb_lock_wait_timeout | This 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_timeout | This 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_timeout | This 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_timeout | This 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. |