I have a find() call which sometimes takes a long time to complete,
depending on the date range selected by the user. This can sometimes cause
the server to time out (2006: MySQL server has gone away), causing the
find() to fail. I have tried altering the timeout value using the following:
ini_set('mysql.connect_timeout', 5);
My presumption is that this is failing because I cannot override the server
settings on the hosting package.
I was advised by the hosting company to use the following code:
SET @@session.wait_timeout=60
I would be very grateful for any advice on increasing the MySQL server
timeout through CakePHP.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
