Re: mysql_query and my.cnf?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2009/1/20 Waynn Lue <waynnlue@xxxxxxxxx>:
> Hey guys,
>
> I've been noticing that large queries cause a connection lost to mysql
> server problem, so I'm trying to figure out what settings I need to tweak in
> my my.cnf file to get it to work.

Have you had a look on your (mysql) Logfiles and/or are you echo'ing
mysql_error() or $dbhandle->error in case of mysqli?
I guess there must be a hint for the reason of the connection lost.

> I know people change the
> max-allowed-packet variable, but I'm trying to figure out what the correct
> section of the my.cnf is.  Is it just [mysql]?

Try that.
http://tinyurl.com/9x3gws

Regards

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux