On Tue, Jan 03, 2006 at 12:29:14PM -0500, James Tu wrote: > I used phpMyAdmin to look at the stats for this mysql server. > > http://www.2-bit-toys.com/db_info/server_status.html > > What concerns me mainly are the stats at the top-right...'Failed > attempts' and 'Aborted.' > When would these situations occur? Is it normal to see these? This is more of a mysql issue, a nice google of 'mysql connections aborted' works pretty good [1]. > I'm using PHP's mysql_pconnect for all my scripts. Could this be > causing the failed/aborted attempts? What is not clear is if > mysql_pconnect will open another connection if the current one is > being used. Becareful with pconnect: http://php.net/mysql_pconnect http://php.net/manual/en/features.persistent-connections.php Historically, both _connect and _pconnect will reuse an existing connection based on the username, password and server it is connecting to, within the same script so if you have $dbh = mysql_pconnect('localhost', 'username', 'password'); $dbh2 = mysql_pconnect('localhost', 'username', 'password'); Both $dbh and $dbh2 are using the same resource. mysql_connect has an option to remove this feature/flaw/annoyance. As far as the 'Aborted' connections, and how php could affect the value is with the _pconnect.... Consider you have a peak hour and you have 100 requests (at one time), php now has reserved 100 connections to the db. And after the peak, you just get about 10-50 requests. Those other 50-90 connections that php had made a connection to earlier become stale (based on the mysql's wait_timeout or interactive_timeout setting [1]) so an aborted connection is registered when a stale connection is accessed. [1] http://dev.mysql.com/communication-errors.html HTH, Curt. -- cat .signature: No such file or directory -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
