max_rows with largetext field

Qunfeng Mon, 03 Jan 2005 14:21:41 -0800

Hi there,

I create a large table with the following command

CREATE TABLE MyTable(
        ID      int unsigned not null,
        Description longtext,
        index(ID),
        foreign key (ID) references MainTable (ID) on delete cascade
);
alter table MyTable max_rows = 20000000000;


Then if I do "show create table" statement,
it shows "MAX_ROWS=4294967275".

Then when I tried to load a data file with 10814572 records, it stops after loading 5081016 records and gave the "Table is full" message.

However, if I change the Description column from largetext to text, I can successfully load into all those records. Any idea why?

Here is my server info $ uname -a Linux machinename 2.4.21-9.0.3.ELsmp #1 SMP Tue Apr 20 19:49:13 EDT 2004 i686 i686 i386 GNU/Linux

MySQL version is 4.1.8-standard

Thanks!

Qunfeng


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

max_rows with largetext field

Reply via email to