Re: Are tables limited to 2GB on Win NT?

[Michael Widenius]

>>>>> "Joshua" == Joshua Chamas <joshua@stripped> writes:

Joshua> indrek siitan wrote:
>> 
>> Hey,
>> 
>> > Just wondering if the maximum table size is 2GB on windoze
>> > NT?  I tried adding table options (3.23.5a) of avg_row_length,
>> > max_rows, and so on ... but I still get cut off at about 2GB.
>> 
>> unfortunately yes. this is not directly a mysql limit - but mysql
>> keeps all the data in a single file and 2GB is a file size limit
>> on NT (as well as on many other operating systems).
>> 
>> Rgds,
>> Tfr
>> 

Joshua> I went around with the mysql developers about this fallacy.
Joshua> WinNT does not have a 2G file size limit.  I'm looking at a 4G
Joshua> file right not on a WinNT 4.0 box.  Something must be wrong 
Joshua> with mysql.

See my previous mail;  This will be fixed in 3.23.7.

Regards,
Monty