> - use of mysql_pconnect (introduced in Novemeber)
> - use of fsockopen($Primary, 3306, &$errno,&$errstr,5) (closed by
> fclose()) to test if connection possible before attempting connection
> (introduced last week)
> - much high web activity causing recycling of httpd processes
You're putting more load on everything by opening the connection with
fsockopen. Simply do the following:
$db = @mysql_pconnect(...);
if (!$db)
die("connection failed");
> Can anyone shed any light on the causes of Aborted Clients and Connects,
> and whether mysql_pconnect and fsockopen would have an effect ?
I'd guess your fsockopen calls are causing Aborted Clients to rise. If you
still have problems after fixing that, then my first idea would be that PHP
does not clean up properly when a client aborts the page by pressing the
stop button. This would be rather easy to test.
If you're using Apache, you can also try setting MaxRequestsPerChild to
something like 10000, so that after a while the process will die and
hopefully close any open connections to the MySQL server. Or if you're
already doing this, try disabling it and seeing if it helps.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
