Timeout Parameters

The following table lists the GaussDB(for MySQL) timeout parameters.

**Table 1** Parameter description
Parameter	Reboot Required	Description
connect_timeout	No	Number of seconds that GaussDB(for MySQL) waits for a connection packet before responding with Bad handshake. If the network quality is poor, you can increase the value of this parameter.
innodb_flush_log_at_timeout	No	How frequently the log buffer flushes to disk, in seconds. This parameter is valid only when innodb_flush_log_at_trx_commit is set to 2.
innodb_lock_wait_timeout	No	Length of time in seconds an InnoDB transaction waits for a row lock before giving up.
parallel_queue_timeout	No	Waiting time for the parallel execution. If the number of parallel-executed threads in the system is still greater than the value of parallel_max_threads after the waiting time, new queries will be executed in single-thread mode.
lock_wait_timeout	No	Timeout in seconds for attempts to acquire metadata locks
net_read_timeout	No	Number of seconds to wait for more data from a connection before aborting the read
net_write_timeout	No	Number of seconds to wait for a block to be written to a connection before aborting the write
interactive_timeout	No	Number of seconds the server waits for activity on an interactive connection before closing it
wait_timeout	No	Number of seconds the server waits for activity on a non-interactive connection before closing it