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
4483
October 07, 2010 11:49AM
1707
October 10, 2010 12:50PM
2301
October 12, 2010 12:38PM
Re: Outfile Using too much disk space
1605
October 14, 2010 11:21AM
1615
October 16, 2010 10:57AM
2031
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.