I'm connecting to a ~30GB database on Google Cloud SQL using MySQL Workbench. However, when I try to query the data, I get the error: Error Code: 2013. Lost connection to MySQL server during query This error always occurs at 900 seconds, so it's only a concern for slower queries. I have increased DBMS connection read time out, but am not sure what else could be causing this.

Reputation: 35

Lost Connection to MySQL Server

I'm connecting to a ~30GB database on Google Cloud SQL using MySQL Workbench. However, when I try to query the data, I get the error:

This error always occurs at 900 seconds, so it's only a concern for slower queries.

I have increased DBMS connection read time out, but am not sure what else could be causing this.

Upvotes: 1

Reputation: 608

Google Cloud SQL could accept several "timeout" parameters.

Check actual parameter with this select :

mysql> show global variables like '%timeout%';

and try to raise it from DevConsole, modifying the CloudSQL tier

Upvotes: 1