Hi Lucas,
| Does anyone know what the maximum number of rows a
| MyISAM table can store is? We currently have a table
| We're afraid there is hard, implementation imposed limit
| of unsigned int (2^32) on the number of rows. Before trying
My guess is that the limit is not in terms of rows, but how large the
filesize is because the filesystem imposes constraints. I am assuming
you read this already? http://www.mysql.com/doc/en/Table_size.html
A few things I'd like to draw your attention to:
1. With the new MyISAM table type in MySQL Version 3.23, the maximum
table size is pushed up to 8 million terabytes (2 ^ 63 bytes).
2. If your big table is going to be read-only, you could use myisampack
to merge and compress many tables to one. myisampack usually compresses
a table by at least 50%, so you can have, in effect, much bigger tables.
3. You can go around the operating system file limit for MyISAM data
files by using the RAID option.
Hope this is useful?
-Shanx.
Shashank Tripathi
www.shanx.com
Sql, query
---------------------------------------------------------------------
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
