MySQL crashing randomly
Posted: Mon Jan 02, 2006 3:51 pm
I've just started running into an issue on my win 2k3 server where MySQL decides that it doesn't want to cooperate with me any more and then decides to go ahead and commit suicide and I can't revive it without a reboot. I've tried restarting the service and it hangs when I'm trying to stop it.
Unfortunately I have not been able to nail down any behaviors that might be causing this, but thought I'd throw it out here to see if any of you have experienced anythign similar and might be able to provide some insight....
thx,
Burr
Edit: Ok, after re-reading my post, I've come to the conclusion that it might possibly be the worst phrased question in the history of devnet...for that I apologize. Here are some more details:
it started crashing when I added a new database. I added the new db through phpMyAdmin (from a dump on my local machine (same MySQL versions)). It crashes when I'm swapping from db to db in phpMyAdmin and I think I've noticed it crashing from the cli when I was in the MySQL db adding a user. I know that still doesn't shed much more light, but hopefully it'll turn some gears...
Unfortunately I have not been able to nail down any behaviors that might be causing this, but thought I'd throw it out here to see if any of you have experienced anythign similar and might be able to provide some insight....
thx,
Burr
Edit: Ok, after re-reading my post, I've come to the conclusion that it might possibly be the worst phrased question in the history of devnet...for that I apologize. Here are some more details:
it started crashing when I added a new database. I added the new db through phpMyAdmin (from a dump on my local machine (same MySQL versions)). It crashes when I'm swapping from db to db in phpMyAdmin and I think I've noticed it crashing from the cli when I was in the MySQL db adding a user. I know that still doesn't shed much more light, but hopefully it'll turn some gears...