On Tue, 2009-01-20 at 17:51 +0100, Jan G.B. wrote: > 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 > I think there's a setting in the php.ini that lets you define how many simultaneous connections it can make with mysql. the mysql directives are towards the bottom of the ini file, so check them out and see if tweaking a few of them fixes things? Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
