MAX_ROWS limits

2002-02-12 Thread Charlie Thunderberg
Hi, I am using MySql 3.23.47 for nt (W2000). The number of rows of my table on an NTFS file system is estimated to become around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295 with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60; Following this, SHOW TABLE STATUS

MAX_ROWS limits

2002-02-08 Thread Charlie Thunderberg
Hi, I am using MySql 3.23.47 for nt (W2000). The number of rows of my table on an NTFS file system is estimated to become around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295 with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60; Following this, SHOW TABLE STATUS