Updated on 2023-10-19 GMT+08:00

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