Thanks Jerome.
With the high number of "aborted_clients", it seems like you might have
networking issues:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Dan
On Tuesday 15 May 2007 02:56, Dan Buettner wrote:
> Hi JM -
>
> Can you send us a few things?
>
> 1 - the exact error message you get
the error code it produced is (110) which according to perror is connection
time out..
> 2 - the output of "SHOW VARIABLES;" from a mysql session
+---
DB the server won't respond immediately
causing the conenct to time-out..
Does your script start with an information_schema query? The frist one
of those is painfully slow with MySQL.
Did you try set_time_limit( 0 )?
PB
-
JM wrote:
after trying it again ang again.. maybe for the 5th t
Hi JM -
Can you send us a few things?
1 - the exact error message you get
2 - the output of "SHOW VARIABLES;" from a mysql session
3 - the output of "SHOW STATUS;" from a mysql session
What have you tried so far in terms of troubleshooting that has been
unsuccessful?
Any recent changes on the
after trying it again ang again.. maybe for the 5th time.. PHP will now be
able to connect..
On Monday 14 May 2007 22:34, JM wrote:
> Hi,
>
> Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
> the
> DB the server won't respond immediately causing the conenct to time-o
Hi,
Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
the DB
the server won't respond immediately causing the conenct to time-out.. No
firewall issues and no network related issues. The only thing that I noticed
is that the server's average load is 60%.
Thanks,
