How do I fix the lost connection to MySQL server during query?

Open the MySQL Workbench Preferences. Check if the SSH Timeout and DBMS Timeout value is set to only a few seconds. Try to increase the default value of the connection timeouts. Save the settings, close the MySQL Workbench and reopen the connection to see if you are able to connect to the database.

Table of Contents

Why does MySQL lose connection?

The error above commonly happens when you run a long or complex MySQL query that runs for more than a few seconds. To fix the error, you may need to change the timeout-related global settings in your MySQL database server.

Can not reconnect to MySQL after 1 attempt’s ): MySQL server has gone away?

The MySQL server has gone away error, means that MySQL server (mysqld) timed out and closed the connection. By default, MySQL will close connections after eight hours (28800 seconds) if nothing happens.

How do I change the query timeout in MySQL workbench?

1 Answer

In the new version of MySQL WorkBench, you can change the specific timeouts.
For you, if it is under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600.
Then the value will be changed to 6000.
Also, uncheck the limit rows.

How do I change the connection timeout in MySQL?

Change the MySQL timeout on a server

Log in to your server by using Secure Shell® (SSH).
Use the sudo command to edit my.
Locate the timeout configuration and make the adjustments that fit your server.
Save the changes and exit the editor.

What is Wait_timeout in MySQL?

wait_timeout : The number of seconds the server waits for activity on a noninteractive connection before closing it. connect_timeout : The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

How do I keep MySQL alive?

Of possible approaches, I’ve considered:

Simply checking before each query to see whether the connection is still valid.
Pooling MySQL connections.
Periodically (every hour or so), execute a query, in case this is occurring due to inactivity.
Connect and disconnect before/after queries.

How do I fix MySQL shutdown unexpectedly?

So do next steps: Rename folder mysql/data to mysql/data_old. Make a copy of mysql/backup folder and name it as mysql/data….Hey I just did this and it worked:

exit Xampp server.
go to your C:pp\mysql\data directory.
delete the ibdata1 file.
restart xampp server.

How do I stop MySQL from timing out?

How can increase MySQL query execution time?

SET GLOBAL MAX_EXECUTION_TIME=1000; Then any SELECT statement run against this MySQL instance will be aborted if it takes more than 1 second to complete. The default for the GLOBAL variable is 0, which means that there is no global time limit.

How do I fix MySQL timeout expired?

The best way to fix it, is to increase the net_read_timeout (by default is only 30 seconds see mysql website) so, you allow the command sufficient seconds to read. If not, the connection will close, because net_read taked more time than the timeout setted.

https://www.youtube.com/watch?v=KPE0uMUkQ5I