Okay... Since I modified the process_priv() stuff I was able to get in and
see what was going on when the server ran out of connections.
It had 257 threads, all executing select statements that were in a "Locked"
state. There was one Update at the top of the list.
I'm going to go back and read all the table locking stuff in the manual...
Do updates/inserts lock the table so that others can't read it? If so, is
there a way to make an update/insert fail if it just takes too long?
Hunter
> From: "Sander Pilon" <[EMAIL PROTECTED]>
> Date: Wed, 25 Apr 2001 22:51:06 +0200
> To: "'Hunter Hillegas'" <[EMAIL PROTECTED]>, "'mySQL List'"
> <[EMAIL PROTECTED]>
> Subject: RE: MySQL 3.23.36 STILL Having Major Problems
>
>
>> OS: Red Hat Linux 6.0 / Intel
>> 1GB RAM
>>
>> MySQL 3.23.36
>> PHP4.0.4PL1
>> Linux kernel 2.4.3
>> Using the my.cnf for medium sized sites
>>
>> mySQL starts with safe_mysqld and there are three threads
>> running. Queries come in and out and it's quite fast. Using
>> mysqladmin proc status shows no queries running.
>>
>> After about 12 hours, the number of mySQL threads visible in
>> ps have shot to about 75. At this point the server reports
>> "No More Connections", both through PHP and from mysqladmin.
>>
>> What's going on here? I can't figure it out. I can't even get
>> in to diagnose the problem, since the server is out of
>> connections. 99% of my queries are SELECT's.
>>
>> It sounds like something is hanging on to connections and not
>> returning them... I'm using mysql_connect() in the PHP scripts.
---------------------------------------------------------------------
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
