Running mysqladmin -p proc reports:
too many connections...
That's why I can't diagnose it.
I'm logging in as root. How else would I get process_priv? I haven't changed
any parameters so I should be able to get in but I cannot.
What am I doing wrong?
Hunter
> From: "Andrew Schmidt" <[EMAIL PROTECTED]>
> Date: Wed, 25 Apr 2001 14:46:48 -0400
> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
> <[EMAIL PROTECTED]>
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
> 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
