I am creating an index on a very large innodb table that is taking a
very long time to complete which I understand is a limitation of
innodb.

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?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to