Page 1 of 1

MySQL crashing randomly

Posted: Mon Jan 02, 2006 3:51 pm
by Burrito
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.... :roll:

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...

Posted: Tue Jan 03, 2006 5:22 am
by ody
A shot in the dark.. but it's not running out of disk space is it?

Posted: Tue Jan 03, 2006 7:20 am
by Charles256
or running out of memory?

Posted: Tue Jan 03, 2006 7:21 am
by twigletmac
Do you have MySQL administrator running? It was very useful to me when I created a query which kept crashing our Intranet server :oops: because it showed all the processes and the query which was causing it to fall over.

Mac

Posted: Tue Jan 03, 2006 8:15 am
by JayBird
twigletmac wrote:Do you have MySQL administrator running? It was very useful to me when I created a query which kept crashing our Intranet server :oops: because it showed all the processes and the query which was causing it to fall over.

Mac
That's what i did :oops:

Posted: Tue Jan 03, 2006 8:35 am
by Burrito
no I do not, I'll look into that today. thx!

Posted: Fri Jan 06, 2006 5:52 pm
by Burrito
ok, where do I get this 'MySQL administrator' thingy you guys are boasting about?

Is this what your'e talking about?

http://www.mysql.com/products/tools/administrator/

Posted: Sat Jan 07, 2006 6:17 am
by twigletmac
Yup that's it.

Mac