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=6000000000;

Following this, SHOW TABLE STATUS still gives the original number for
MAX_ROWS!
Could someone help me to understand, if MAX_ROWS is limited to the maximum
value of the integer, or do I need to change some other settings in order to
go beyond this number?

Thanks for any ideas!

Charlie





_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to