Re: Find() failing due to '2006: MySQL server has gone away'

Perhaps you need to optimize your query/indexes. Have you considered
creating a (database) view?

On Wed, Mar 14, 2012 at 7:32 PM, Kro <yenohamoninorc@gmail.com> wrote:
> 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
> cake-php+unsubscribe@googlegroups.com For more options, visit this group at
> http://groups.google.com/group/cake-php

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php