hello.
My server uses "SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250",
and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build
with the support of mysql.
The mysql server has several databases that are used by several virtual hosts.
I have a account having (and have only) the privileges of one of the databases on the
mysql server.
My site uses this database throught PHP scripts using the account I said
above. But my php scripts said "too many connections" when calling "mysql_pconnect" in
the past days.
I know it was caused by the PHP scripts because of not closing the
connections. I execute the command "show processlist" and it printed many rows. I
repaired the bug and killed the connections. But, now, the problem still exists, and
when I exeute "show processlist" there were only a few rows.
What's the problem? How does mysql limit the connections? Does it limit all the
connections to a certain quantity or limit each database seperately? When I execute
"show processlist", which connections does it shows?
---------------------------------------------------------------------
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
