Justin Swanhart <[EMAIL PROTECTED]> wrote: > The problem is that another application has been issuing queries > against the table and those queries have never timed out. So now I > can't kill the connections, because I can't make a database connection > to mysql to even see their thread ids: > > [EMAIL PROTECTED] mysql]$ mysqladmin -u root -p processlist > Enter password: > mysqladmin: connect to server at 'localhost' failed > error: 'Too many connections' > > I don't want to kill the mysqld process, because that would stop my > index creation. > > Is there anything you can do in this situation? I don't think > connections from mysqladmin should ever be denied. Is this a feature > request that I should make?
You only have to wait for some connections to free. Next time enlarge max_connections variable. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]