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

[Michael Widenius]

>>>>> "Steve" == Steve Ruby <stever@stripped> writes:

Steve> Sinisa,

Steve> are you saying this is a goal of 3.23 in general or should be the case
Steve> now.
Steve> I tested and am unable to pass 2gb also on 3.23.5a (win32 on NT 4.0)

mysql> INSERT INTO big_test (data,data2,bigthing) values
Steve> (Rand(),Truncate(Rand()*100000000,0),'testing');
Steve> ERROR 1114: The table 'big_test' is full

Steve> All indications I was given are the the only limits on table size are OS
Steve> limits.
Steve> the main table in my current project should be at about 2gb by Jan given
Steve> current
Steve> growth rate is the reason I am concerned.

Steve> In my test the table grew until the threads from the application
Steve> inserting suddenly
Steve> went into sleep. Attempt to insert another row by hand (see above)
Steve> reported
Steve> the above error. The directory looks like this now:

Steve>  Directory of Q:\mysql\data\misc

Steve> 11/19/99  10:19a        <DIR>          .
Steve> 11/19/99  10:19a        <DIR>          ..
Steve> 11/19/99  10:17a                 8,662 big_test.frm
Steve> 11/19/99  11:30a         2,147,483,628 big_test.MYD
Steve> 11/19/99  11:30a            44,321,792 big_test.MYI
Steve>                5 File(s)  2,191,814,082 bytes
Steve>                           2,085,715,968 bytes free

Steve> table looks like this (which is nothing like my production table in
Steve> question
Steve> if that matters):
Steve> +----------+---------------+------+-----+---------+----------------+
Steve> | Field    | Type          | Null | Key | Default | Extra          |
Steve> +----------+---------------+------+-----+---------+----------------+
Steve> | id       | bigint(20)    |      | PRI | NULL    | auto_increment |
Steve> | data     | float(11,9)   | YES  |     | NULL    |                |
Steve> | data2    | bigint(20)    | YES  |     | NULL    |                |
Steve> | addtime  | timestamp(14) | YES  |     | NULL    |                |
Steve> | bigthing | longtext      | YES  |     | NULL    |                |
Steve> +----------+---------------+------+-----+---------+----------------+

<cut>

Steve> sinisa@stripped wrote:
>> 
>> Chris L. Smith writes:
>> > 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.
>> > chris
>> >
>> >
>> >
>> 
>> On NT a maximum is 4 Gb, with MySQL 3.23 ...
>> 

Hi!

In MySQL 3.23.6 the maximum is 2G;  I will in MySQL 3.23.7 extend this 
to 1000T (or whatever NT can handle :)

Regards,
Monty