Wednesday, February 14, 2018

[google-cloud-sql-discuss] Re: Increasing the open db connection on MySQL CloudSQL instance(MySQL 2nd Gen 5.7)

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.

You should also noted that the latest version of MySQL which is supported by Cloud Platform is version 5.6.

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.


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2dd45c0d-d546-47cb-8b3f-05c6b7442539%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment