Re: mysql_query and my.cnf?
| From: | Jan G.B. | Date: | Tue, 20 Jan 2009 16:51:13 +0000 |
| Subject: | Re: mysql_query and my.cnf? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-286864@lists.php.net to get a copy of this message | ||
2009/1/20 Waynn Lue <waynnlue@gmail.com>:
> 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