> 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.
Well, I know you say it aint so - but when I had this problem it was the
persistent connections from PHP. Make absolutely 100% double-sure that
you do not use pconnect or some other feature that keeps connections
open. If you use pconnect the max. nr. of httpd processes in apache
should be a few less than the max. nr. of mysql connections. (Since
every httpd process will have one connection)
Also, running mysql with --log option should reveil who connects and
what gets executed to you in the logfile.
-S
---------------------------------------------------------------------
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
