Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
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

2 Answers 2

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.

share|improve this answer
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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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