Increasing the open db connection on MySQL CloudSQL instance(MySQL 2nd Gen 5.7)

[Shashank Tyagi]

Hello All,

We need to increase the maximum number of open connections on our MySQL 2nd Gen 5.7 database instance.   We need to know is there a way to set the desired maximum concurrent value on the database. Our DB stops respondiong as soon as the max concurrent connection s reaches 45.
Any help on the same will be highly appreciated.

Thanks
Shashank

[Katayoon (Cloud Platform Support)]

For the Second Generation instances, the maximum number of concurrent connections for MySQL is 4000 and it depends on the machine type of SQL instance. For better performance, you may modify the machine type configuration and storage to hold your largest table.

For diagnosing the issue occurring when your concurrent connections reach 45, you may check this documentation ( For example you can use SHOW PROCESSLIST command from a MySQL client to find out what is happening on an instance)

If you still have some questions with regards to Cloud SQL, you may check this link for the Cloud SQL FAQ. For specific technical questions, I recommend that you ask your question on Stack Overflow using one of the tags monitored by our community technical support team[4], since there would be more visibility on it.

Edit: I removed my second paragraph which was saying “the latest version of MySQL which is supported by Cloud Platform is version 5.6”. Pia is correct. Cloud SQL supports MySQL 5.6 and 5.7.

[Pia Chamberlain]

Cloud SQL supports MySQL 5.6 and 5.7. The most recent minor upgrade, listed in the release notes, was to 5.6.