MyISAM and table size
Hi all!
I'm running MySQL 4.1.7 on WinXP/NTFS and set "myisam_data_pointer_size=5"
in "my.ini". SHOW VARIABLES confirms that the pointer size was increased. But
SHOW TABLE STATUS says that my MyISAM tables can grow upto 4GB only.
I expected 1TB result.
Why?
P.S. I know that the main way to increase MyISAM table size limit is to specify
AVG_ROW_LENGTH and MAX_ROWS on a table create. But if I understand right
MySQL manual, the above (myisam_data_pointer_size) method should work too.
Subject
Views
Written By
Posted
MyISAM and table size
5973
January 13, 2005 01:02AM
2091
January 13, 2005 07:33AM
2147
May 01, 2006 01:24PM
2092
May 02, 2006 10:20AM
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.