I've got a question for you. I've got a MySQL db running in FreeBSD 4.8, and have encountered the following problem.
When I try to connect to a database by a specific user, I get the following response :
#mysql -p -u comet
Enter password:
ERROR 1226: User 'comet' has exceeded the 'max_connections' resource (current value: 100)
Now, that is exactly what I'd expect to see, IF the user had 100 connections. Instead, when viewing the processlist, I get :
#mysqladmin -p processlist Enter password: +-----+------+-----------+----+---------+------+-------+---------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------+----+---------+------+-------+---------------+ | 469 | root | localhost | | Query | 0 | | show processlist | +-----+------+-----------+----+---------+------+-------+---------------+
I think that the code that had established all of those connections didn't properly dispose of the connections (a PHP script that one of our clients is using). Is there a way to clear those?
Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]