MySQL Forums
Forum List  »  General

Re: Drop schema taking a very long time
Posted by: Rick James
Date: September 13, 2010 10:24AM

SHOW PROCESSLIST -- what it going on now?

Probably deleting the directory would be safe. You would also need to restart mysqld. It may, at that point, have to repair some stuff. Cross your fingers.

I do not know if DROP TABLE checks constraints. DELETE does.

How big is innodb_buffer_pool_size? How much RAM?

Options: ReplyQuote


Subject
Written By
Posted
Re: Drop schema taking a very long time
September 13, 2010 10:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.