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..