MySQL, PHP low-load problems

From: Date: Sat, 21 Apr 2001 03:19:27 +0000
Subject: MySQL, PHP low-load problems
Groups: php.general 
Request: Send a blank email to php-general+get-49634@lists.php.net to get a copy of this message
Hi all, Live is strange sometimes, and so is this error we have here. I have a large forum (more then 300.000 pageviews a day) running. We are using php-4.04pl1 (with the Zend/zend_list.c file patched) and we are using MySQL 3.23.36-log. We are using the following piece of code to connect to the dbase: if(!mysql_pconnect($db[$no]["host"],$db[$no]["user"],$db[$no]["pass"])){ if(!mysql_connect($db[$no]["host"],$db[$no]["user"],$db[$no]["pass"])){ die(error(55)); under normal circumstances this is running normal, not to much error #55's. But, when the load on the forum is lowering, the ammount of errors is increasing. This is very annoying (i mean, under high-load it is working perfect, but at nights when the load is low you'll get error after error. as example: hour #errors 19 56 20 45 21 60 22 49 23 41 0 65 1 105 2 146 3 304 4 277 (4:00 ~ 4:50) error we receive: 2006: MySQL server has gone away The configuration i use: http://gathering.tweakers.net: FreeBSD Arshia.webmagix.net 4.3-BETA FreeBSD 4.3-BETA #0: running on an Tbird 1GHz with 512MB ram MySQL 3.23.36 server is running on an dual PIII-1 GHz with 1.5G ram php-config: ./configure --with-apache=../apache_1.3.19 --enable-track-vars \ --enable-magic-quotes --with-gd=/usr/local --with-mysql --with-zlib=../zlib- 1.1.3 I still don't know who is wrong, PHP or MySQL, i hope some of you can give me more clarity in this strange behauvior. tia, Kees Hoekzema kees@tweakers.net http://gathering.tweakers.net

« previous php.general (#49634) next »