Re: How to admin a server that currently has too many connections?

2004-09-01 Thread Egor Egorov
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

How to admin a server that currently has too many connections?

2004-08-31 Thread Justin Swanhart
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

RE: How to admin a server that currently has too many connections ?

2004-08-31 Thread Victor Pendleton
Is there already a mysql privileged account logged in? The database will allow for an administrative account to login, if one is not already active, in the event of too many connections. It sounds as if you may be running one or more accounts with this privilege. -Original Message- From: