MySQL crashing randomly

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

MySQL crashing randomly

Post 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...
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

A shot in the dark.. but it's not running out of disk space is it?
Charles256
DevNet Resident
Posts: 1375
Joined: Fri Sep 16, 2005 9:06 pm

Post by Charles256 »

or running out of memory?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post 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:
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

no I do not, I'll look into that today. thx!
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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/
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Yup that's it.

Mac
Post Reply