Thank for coming back, You means this machine we can limit only 1,000, it not possible to fix it to 4030 and machine not listen max_connections variable ?
if possible if i set variable max_connections: 4030 it should be fixed.
Please advice us.
Thanks.
Thanks.
On Monday, 1 March 2021 at 21:39:10 UTC+7 George (Cloud Platform Support) wrote:
The page linked-to above indicates that the maximum limit for the db-g1-small machine type is 1,000; by contrast, you indicate max_connections: 4030. You should fix this discrepancy.On Friday, 26 February 2021 at 21:06:29 UTC-5 Rattanachai Wongwatkit wrote:Hi'Thank for your reply.
MySQL Type (db-g1-small)Version: MySQL 5.6vCPUs: 2 vCPUMemory: 7.5 GBSQL variablemax_connections: 4030max_connect_errors: 100max_user_connections: 0concurrent_insert: AUTOMy max_connections now set to: 4030, it high, I don't know it correct setting ?Thanks.On Friday, 26 February 2021 at 23:03:10 UTC+7 Aref Amiri (Cloud Platform Support) wrote:Hello,Based on the info you've provided, there is a high number of connections. According to this documentation, every machine has a default value for concurrent connection. What type of machine you have selected for your Cloud SQL instance?On Thursday, February 25, 2021 at 11:41:01 AM UTC-5 Rattanachai Wongwatkit wrote:I'm new for Google Cloud SQL, I try to query something heavy than normally, Especially write, After that my Cloud SQL Down. I don't know how to debug, fixed or reason why SQL Server is down. Because CPU, Ram graph it show normally.CPU (not overload)RAM (not full)SQL Queries (It look high 200,000/S)Active Connections (it look high)Write process it look highI think my script it heavy, but it cannot make Sql Server down because CPU and RAM is enough, Please advice us please.
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/29e76238-9de1-4262-8b7a-3f196d9dc600n%40googlegroups.com.
No comments:
Post a Comment