2

Possible Duplicate:
Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL

To look at the background my problem; I have run a query to import data to a new table from a query result in MySQL workbench (149.000.000 row would be decrease to 490.000 by grouping). But it is stopped unexpectedly because of connection timeout after 20000 seconds. In the table, there is no data when I look.

I executed the query "truncate table Concepts" to delete data inside also for executing the insertion query again later. I worked about an hour but not finished. So, I stopped the query and by using command line, executed "drop table Concepts" query to completely remove it.

It has been working for 3 hours but not finished. Is there any way to delete the table manually from database?

(Windows 7, 4gb ram, intel core2 duo 2.27GHz processor)

Community
  • 1
  • 1
    Is there a lock on the table or maybe an unfinished process running? –  Oct 09 '12 at 07:20
  • Only a primary key is set. I don't think there is a lock. The problem is non-finishing process. Drop table query is running from 3 hours and 30 minutes. –  Oct 09 '12 at 07:20
  • Have a look at this http://www.mysqlperformanceblog.com/2009/06/16/slow-drop-table/ –  Oct 09 '12 at 07:21
  • If you would log in on both sites with the same login method we could associate all your accounts together ... – jcolebrand Oct 09 '12 at 19:20

0 Answers0