Update Table

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



sangprabv
sangprabv@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Update Table

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
> sangprabv@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=gcdmg-mysql-2@m.gmane.org

Re: Persistent Connection VS One Time Connection Was Update Table

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
sangprabv@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
>>=20
>>=20
> 1.) Are you sure the script is executed under those conditions? Is
> Apache refusing the request because to many children have been forked?
>=20
> 2.) Are you sure the script will report if MySQL fails with too many
> connections?
>=20
>>=20
>> sangprabv
>> sangprabv@gmail.com
>> http://www.petitiononline.com/froyo/
>>=20
>>=20
>>=20
>=20
>=20


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg