HI - I have a table in a MySQL db that we were trying to shrink by moving all records older than 1 year from today's date to an identical archive table. Then we've written some pages so these old records are still accessible, but the unneeded 1.1 million records we end up needlessly scanning through on all the current activities pages can hopefully be eliminated from most hits on the db.
So far, so good. But we built and ran our first test on a backup copy and...nothing. We are still waiting. Hours later. If I go into Heidi SQL and try to do anything to this db, the application hangs.
So I went to command line and did a SHOW FULL PROCESSLIST and sure enough, that first query is the first in a line of 30 processes queued up. I can't tell if the first query is still running, or if this will eventually make it through all these processes. I've seen that you can KILL processes, but this appears to be a one at a time thing. If I kill this first process hanging everything up, will the other queued up processes then proceed to run? Any suggestions on an elegant way to stop all of these processes at once?
Could I just stop the MySQL service?