List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 26 1999 3:31pm
Subject:Re: Are tables limited to 2GB on Win NT?
View as plain text  
>>>>> "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
Thread
Are tables limited to 2GB on Win NT?Chris L. Smith19 Nov
  • Re: Are tables limited to 2GB on Win NT?sinisa19 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby19 Nov
    • RE: Are tables limited to 2GB on Win NT?Matthew Clark19 Nov
      • Re: Are tables limited to 2GB on Win NT?Steve Ruby19 Nov
      • RE: Are tables limited to 2GB on Win NT?sinisa20 Nov
        • 64 Bit ext2, Reiser FS, and Solaris on IntelBruce Ward20 Nov
          • RE: 64 Bit ext2, Reiser FS, and Solaris on IntelKolb Norbert20 Nov
          • Re: 64 Bit ext2, Reiser FS, and Solaris on IntelMatthew Kirkwood21 Nov
          • Re: 64 Bit ext2, Reiser FS, and Solaris on Intelsinisa21 Nov
            • Re: 64 Bit ext2, Reiser FS, and Solaris on IntelMatthew Kirkwood21 Nov
              • Re: 64 Bit ext2, Reiser FS, and Solaris on Intelsinisa22 Nov
        • 64 Bit ext2, Reiser FS, and Solaris on IntelBruce Ward21 Nov
    • Re: Are tables limited to 2GB on Win NT?sinisa20 Nov
    • Re: Are tables limited to 2GB on Win NT?Michael Widenius26 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby20 Nov
    • Re: Are tables limited to 2GB on Win NT?Michael Widenius26 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby22 Nov
    • Re: Are tables limited to 2GB on Win NT?Christopher E. Brown22 Nov
RE: Are tables limited to 2GB on Win NT?indrek siitan19 Nov
  • Re: Are tables limited to 2GB on Win NT?Joshua Chamas19 Nov
    • Re: Are tables limited to 2GB on Win NT?Michael Widenius26 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby19 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby19 Nov
    • Re: Are tables limited to 2GB on Win NT?Vivek Khera19 Nov
  • Re: Are tables limited to 2GB on Win NT?Steve Ruby19 Nov
  • Re: Are tables limited to 2GB on Win NT?Faisal Nasim19 Nov
  • RE: Are tables limited to 2GB on Win NT?Jim Keijser19 Nov
    • RE: Are tables limited to 2GB on Win NT?Peter Strömberg22 Nov
      • RE: Are tables limited to 2GB on Win NT?Christopher E. Brown22 Nov
        • RE: Are tables limited to 2GB on Win NT?Peter Strömberg22 Nov
  • Re: Are tables limited to 2GB on Win NT?Tonu Samuel20 Nov
RE: 64 Bit ext2, Reiser FS, and Solaris on IntelJohn Foley23 Nov