MySQL Forums
Forum List  »  Newbie

Max_data_length 1 Terrabyte?
Posted by: Leo Druyanov
Date: August 17, 2005 05:03AM

Hi ALL,

I have a table tab1, which is "full".

Here are some data:

Max_data_length=4294967295
Max_rows=240849
Avg_row_length=16400


After I recevie a message, that table tab1 is full, I executed;

MYSQL> ALTER TABLE tab1 max_rows=524288 AVG_ROW_LENGTH=16400;
Query OK, 240849 rows affected (16 min 58.20 sec)
Records: 240849 Duplicates: 0 Warnings: 0

And then:

Max_data_length=1099511627775
Max_rows=240849
Avg_row_length=16400


So, the Max_data_length parameter must be about 8 Gigabyte, but it is
1 Terrabyte now.

SuSE linux 9.2
MySQL 3.23.55

What is wrong???

Kind regards,
Leo

Any help will be appreciated

Options: ReplyQuote


Subject
Written By
Posted
Max_data_length 1 Terrabyte?
August 17, 2005 05:03AM
November 18, 2005 02:01AM


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.