Is there a timeout setting that impacts large query?

[Bobbo]

I've got a php direct execution page that supposed to return the results of a large query however it appears to be timing out (probably due to the size of the result set) and returns a Database Error page.

Invalid SQL:

REPLACE INTO cache
SET cacheid = 'vbcms_rendered_73',
expires = 0,
created = 1278511804,
locktime = 0,

...

MySQL Error : MySQL server has gone away
Error Number : 2006

....



I'm not sure if there is a MySQL variable that impacts this, a PHP setting, or what. Any ideas?

Thanks,

B

[KProjects]

What is your wait_timeout set at in your my.cnf? I was getting mysql has gone away errors and it was because the wait_timeout was set pretty low by default..