Max_data_length 1 Terrabyte?
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
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.