MySQL Forums :: MyISAM :: Outfile Using too much disk space


Advanced Search

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 3392 Jamie Koc 10/07/2010 11:49AM
Re: Outfile Using too much disk space 1349 Rick James 10/10/2010 12:50PM
Re: Outfile Using too much disk space 1817 Jamie Koc 10/12/2010 12:38PM
Re: Outfile Using too much disk space 1168 Jamie Koc 10/14/2010 11:21AM
Re: Outfile Using too much disk space 1208 Rick James 10/16/2010 10:57AM
Re: Outfile Using too much disk space 1583 Jamie Koc 11/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.