Timeout Limitations

[T.J. Crowder]

Hi,

Fantastic news about Google Cloud SQL and the fact it's backed by such
a huge, well-recognized engine. And it's great that there are so few
restrictions on it!

The FAQ[1] mentions the parts of MySQL that aren't supported (very
short list) and the size limitation on a given request/response, which
is useful. Is there a time limit as well? E.g., what if a request
takes more than (say) 30 seconds to complete? Obviously one wants to
avoid having anything *like* that kind of turn-around on a DB call,
but just for those long administrative things, etc., surely there must
be some limit somewhere.

[1] http://code.google.com/apis/sql/faq.html

Thanks in advance,
--
T.J. Crowder
Independent Software Engineer
tj / crowder software / com
www / crowder software / com

[Ken Ashcraft]

On Oct 7, 1:52 am, "T.J. Crowder" <t...@crowdersoftware.com> wrote:
> The FAQ[1] mentions the parts of MySQL that aren't supported (very
> short list) and the size limitation on a given request/response, which
> is useful. Is there a time limit as well? E.g., what if a request
> takes more than (say) 30 seconds to complete? Obviously one wants to
> avoid having anything *like* that kind of turn-around on a DB call,
> but just for those long administrative things, etc., surely there must
> be some limit somewhere.

Good question, we'll update the FAQ.

Yes, there is a limit when the queries come from a GAE app. All DB
calls must finish within the http request limit:
http://code.google.com/appengine/docs/java/runtime.html#The_Request_Timer.
Offline requests (i.e. cron, tasks) have a higher limit. DB calls
made by a Backend have the same limit as offline requests.

Queries made by the command line tool do not have a limit.

Ken