Your problem is that you shouldn't be using mysql_pconnect(). That
comment is for persistent connections, which you really don't want. What is
likely happening is the php thread ends, aborting what MySQL thought would
be a persistent connection.
Try changing it to mysql_connect()
here's some more info...
http://www.php.net/manual/features.persistent-connections.php
----- Original Message -----
From: "Chris Parker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 7:56 PM
Subject: Too many Aborted Connects
Hi,
We are getting too many Aborted_connects using
mySQL version 3.22.32 on SunOS 5.8.
Users connect to our site via an Apache/1.3.12
server to a PHP Verion 4.0.4pl1 website which
connects to the mySQL database (which is on the
same machine) via the PHP mysql_pconnect()
command.
Aborted_connects are currently 669514 grow by
about 100 a second. Also some of the other variables
seem to be rather large.
Can any one suggest how I can stop this problem ?
Thanks,
Chris Parker
Results from 'show status'
Variable_name Value
Aborted_clients 0
Aborted_connects 669514
Created_tmp_tables 141
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 1683
Handler_read_first 54
Handler_read_key 720335
Handler_read_next 13528528
Handler_read_rnd 1269249023
Handler_update 8853
Handler_write 16416
Key_blocks_used 9567
Key_read_requests 5735748
Key_reads 9487
Key_write_requests 27404
Key_writes 19706
Max_used_connections 116
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 341
Open_files 92
Open_streams 1
Opened_tables 347
Questions 244772
Running_threads 87
Slow_queries 5282
Uptime 7822
---------------------------------------------------------------------
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
