MySQL Forums
Forum List  »  Performance

MyISAM and table size
Posted by: tumurbaatar
Date: January 11, 2005 12:44AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM and table size
2364
January 11, 2005 12:44AM


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.