PDO connexion to Cloud SQL with unix_socket very slow

[Thierry L]

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 !

[Yasser Karout (Cloud Platform Support)]

Hello,

I replied to your thread on your other duplicate post.