Who are web users logging in as? Take away their process_priv if they have
it (unless they need it).
Also, what version of php are you running? As old versions contained leaks
in connections
In the change log for php 4.0.4
<cut>
Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they
weren't properly closing the SQL connections (Zeev)
<cut>
regards,
-- Andrew
----- Original Message -----
From: "Hunter Hillegas" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>; "mySQL List"
<[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 3:04 PM
Subject: Re: MySQL 3.23.36 STILL Having Major Problems
> 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
