Advanced Settings for Database Connections

Last modified: December 26, 2023

dbForge Query Builder for MySQL offers a number of useful features to tune and better manage database connections, and reduce traffic.

Connection timeout

Specify the required time period after which dbForge Query Builder for MySQL stops its attempts to get response from the MySQL Server and open a connection. Note, zero means to wait infinitely.

Execute timeout

Specify the required time period after which dbForge Query Builder for MySQL stops its attempts to execute a query. Note, zero means to wait infinitely.

Encoding

By default, the client connection character set is UTF-8. You can select a different encoding from the drop-down list.

Detect MySQL character set

When selected, dbForge Query Builder for MySQL automatically identifies the character set used by the MySQL Server after the connection is created. Selecting this option is mandatory for MySQL Server 3.23-5.x.

Use compression

If selected, dbForge Query Builder for MySQL will use compression when exchanging data with the MySQL Server to reduce the traffic.

Keep connection alive

If selected, dbForge Query Builder for MySQL will ping the MySQL Server to validate the status of the open connection. It will notify you in case the connection is closed, saving your time and prompting to reconnect.