I have checked Apache's log. There is no refused connection. And also with MySQL I have set it to 999 connections and view the processes. Maximum connection ever reached was only around 200. What I'm thinking now is. Is it because of I use one time connection method? I mean every time the script's called I create new connection and disconnect it after execute the query. Thanks
sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 27, 2010, at 7:28 PM, Nigel Wood wrote: > On Mon, 2010-09-27 at 11:25 +0100, Willy Mularto wrote: >> Hi, >> I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a >> simple query that searches matched row id and update the field via HTTP GET >> query. On a low load it succeed update the row. But on high traffic >> sometimes it failed to update some rows. No errors return by the script. >> What usually cause this and how to solve this problem? Thanks >> >> > 1.) Are you sure the script is executed under those conditions? Is > Apache refusing the request because to many children have been forked? > > 2.) Are you sure the script will report if MySQL fails with too many > connections? > >> >> sangprabv >> sangpr...@gmail.com >> http://www.petitiononline.com/froyo/ >> >> >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
