MySQL Forums :: MyISAM :: Outfile Using too much disk space
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?
|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.