Number of instances increase without control and reach max "quota" without being able to to anything.

[bb]

Hi,

we have an application in GAE/CloudSQL Number: 853102160359

I don't understand the price it cost daily.

The number of instances required for almost 0 process is not reasonable.

There is probably something wrong in our configuration but I don't know how to check it.

The actual settings makes Google Interface more than thousand times more expensive than the OVH private server that we use before.

To have an idea to compare with Google, a unique private server cost $750/year with the same results in therms of page rendering and speed in the US, France and Spain at the same time.

Where Google cost $20/day in Cloud SQL and between $15 and $80 per day! in GAE.

In this beta website, we are talking about less than 100 Unique Visitor per day...

In my humble opinion, or our configuration is wrong and we can improve our settings to get competitive prices with other server providers, or your prices or conf. are not optimized to match with the real client consuming.

(a fare target for your KPIs could be an average cost per client GAE+Cloud SQL to $10/day). 

If we want to use Google Servers it's for scalability, but scalability doesn't mean using a Porche for a bicycle race.

Can you have a look to the project GAE project 853102160359 and tell me if something goes wrong ?

Thanks

 ,

Brice

[Razvan Musaloiu-E.]

A Cloud SQL instance stays up if there is traffic and that includes idle connections over IP. I currently see the instance associated with 853102160359 having two connections over IP. Note: you can see the active connections by connecting with mysql client and issuing 'SHOW PROCESSLIST' [1]. You can also force the instance to stop using the 'Restart' button from Cloud Console.

[1] http://dev.mysql.com/doc/refman/5.5/en/show-processlist.html

-- Razvan ME

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/94aa7b6f-dd5e-4a30-a260-462469886394%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Razvan Musaloiu-E.]

One thing I forgot to mention: you can use the 'KILL ...' command [1] to terminate a particular connection.

[1] http://dev.mysql.com/doc/refman/5.5/en/kill.html

-- Razvan ME