up vote 0 down vote favorite
share [g+] share [fb]

DROP TABLE table_name

and the CPU goes to 400% and it doesn't drop but the whole server is messed up.

any ideas?

MySQL db about 50MiB in size total. 11000 records in this table with no indexs apart from primary.

link|improve this question
100% accept rate
What SQL Server application? MySQL, MSSQL, other? Is the table in use at the time? Is the table massive? – Tom O'Connor Sep 30 '09 at 11:33
..are there any indices? PK/FK constraints? what OS? what kind of hardware? – warren Sep 30 '09 at 11:45
Updated to represent – Dorjan Sep 30 '09 at 12:45
feedback

2 Answers

up vote 0 down vote

What does a:

SHOW FULL PROCESSLIST;

display from the mysql client? I suspect that is will just show the drop statement, but it's somewhere to start.

Is there anything in dmesg or /var/log/messages, /var/log/mysql etc that suggest a greater problem? I am presuming it's a linux box - though you haven't mentioned what OS.

link|improve this answer
feedback
up vote 0 down vote accepted

the answer was a corrupted index or some-such. I recreated the db then copied over the data and it worked.

Weird but I guess it is one of those things that happen.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.