MySQL Forums
Forum List  »  MyISAM

Outfile Using too much disk space
Posted by: Jamie Koc
Date: October 07, 2010 11:49AM

I am dumping a myisam table with 300 million records using outfile (table size is 40G) with an select * from table order by. The server starts with 400G free and as I watch the process run, the server space drops down to 80G free. Why does MySQL need around 8 times as much disk space to perform a sort on a 40G table?

Options: ReplyQuote


Subject
Views
Written By
Posted
Outfile Using too much disk space
4448
October 07, 2010 11:49AM
1691
October 10, 2010 12:50PM
2288
October 12, 2010 12:38PM
1595
October 14, 2010 11:21AM
1603
October 16, 2010 10:57AM
2015
November 23, 2010 04:57PM


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.