Friday, November 16, 2018

[google-cloud-sql-discuss] PDO connexion to Cloud SQL with unix_socket very slow

Hi,

I'm trying to deploy a PHP55 application to GAE (standard instances) with cloud SQL connexion. 

I'm using unix_socket DSN connexion as shown in documentation, but the connexion time to cloud sql instance is very very slow (it can take up to 200ms sometimes), and have a serious impact in application response time (it should answer in 50ms, but actually have an 150ms average response time) :
"timer (seconds)": {
            "begin": 0,
            "app": 0.043889999389648,
            "pdoinit": 0.000070095062255859,
            "pdook": 0.20270991325378,
            "pdoutf8": 0.037790060043335,
            "controller": 0.062999963760376,
            "preparequery": 0.015130043029785,
            "executequery": 0.0024099349975586,
            "return": 0.0051000118255615,
            "returnok": 0.00011014938354492
        }

My application & Cloud SQL instance is on the same location id. So no problem here.

Got another app accessing cloud SQL from compute engine in same region, without any problem.

Maybe there is another connexion method i did not see in documentation ? I saw lot of people having problem like this. Maybe app engine is not the right solution ?

thanks a lot for your help !

--
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/70c232fb-e724-4ffc-8ba1-3d01b0402290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment