Don't give process privilege to anyone else, tht way a connection will be
reserved.
On Wed, 25 Apr 2001, Hunter Hillegas wrote:
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
