taken from the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W_PROCESSLIST
----
SHOW PROCESSLIST shows you which threads are running. You can also get this
information using the mysqladmin processlist command. If you have the
process privilege, you can see all threads. Otherwise, you can see only your
own threads. See section 7.27 KILL Syntax. If you don't use the FULL option,
then only the first 100 characters of each query will be shown.
This command is very useful if you get the 'too many connections' error
message and want to find out what's going on. MySQL reserves one extra
connection for a client with the Process_priv privilege to ensure that you
should always be able to login and check the system (assuming you are not
giving this privilege to all your users).
----
I believe you will want to do the second paragraph.
regards,
-- Andrew
----- Original Message -----
From: "Hunter Hillegas" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 11:21 AM
Subject: 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.
>
> Any ideas? This has taken my Web site out about 5 or 6 times in the last
two
> weeks. It's no fun. Anything anyone could do to help would be great.
>
> Hunter
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
