It has been a few times when I bump into this situation, and I would like to know if anyone has solutions for this: When I "ALTER" a table that contains a lot of data, or enter a long long complex query by mistake, it seems like the query (or action) is taking up all that the server can handle. The server stop responding. no connection can be made to mysql server no query can be made. mysqladmin shutdown can't seem to reach the server mysqladmin processlist didn't respond and this will last about an hour or so untill the process is finally done. My questions is, many of times this happen by accident. Is there anyway to stop this process and let the server back to normal? thanks.. Terry
