MySQL Forums
Forum List  »  MySQL Administrator

A problem with a very slow "drop database"
Posted by: Angelo Ulivieri
Date: July 22, 2012 04:22AM

Hi all, I'm using Mysql to create a very big db. I'm doing a set of attempts with different tables to verify what is the fast way I could do some query.
To do this I have to use drop to delete inefficient constructions I've done.
but when I do this it happen that process takes a long long time.

I've been searching the web to understand what happens and seen that maybe can be the file system type that implies a slowness. One of the possible different ways is to erase single tables and then all the database.

the problem is that I have two very big databases and i've just used drop database for each of them. The processes started and continued for a lot of hours. I wasn't understanding and then killed the process by using Ctrl-C.

Now databases still exists in the mysql system and i don't know if my processes are still running or not and how can I erase them.

Please someone help me!

thanks

Options: ReplyQuote


Subject
Written By
Posted
A problem with a very slow "drop database"
July 22, 2012 04:22AM


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.