Re: Outfile Using too much disk space
Posted by:
Jamie Koc
Date: October 14, 2010 11:21AM
Through some testing, I've discovered that MySQL is using or allocating 255 characters for every record when I select into an outfile, even though the column is varchar(255). Is this by design or a bug?
So 255 char * 319451656 records ~ 81G, when the average length for my field is 64 char or 64 * 319451656 records = 20G. If it is doing that for 2 buffers (where clause and sort) then that explains why it is blowing away all my disk space.
Subject
Views
Written By
Posted
4772
October 07, 2010 11:49AM
1810
October 10, 2010 12:50PM
2406
October 12, 2010 12:38PM
Re: Outfile Using too much disk space
1706
October 14, 2010 11:21AM
1722
October 16, 2010 10:57AM
2129
November 23, 2010 04:57PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.