Shashank Tripathi wrote: > > 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?
Not really, but thanks anyway. We already hit and successfully exceeded the 2/4GB table size limit almost two years ago thanks to MyISAM and LFS, so table size is not a problem (Typically, one instance of our DBs is currently about 130 GB in ~35 tables...). What made me think about there being a hard limit is the fact that if you create table T (A integer, B integer) max_rows=5000000000; [btw don't use max_rows=5e9, you will end up with max_rows=5 in 3.23.38] you get show table status like 'T'; +------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+---------------------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | |Index_length | Data_free | Auto_increment | Create_time | Update_time || Check_time | Create_options | Comment | +------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+---------------------+---------+ | T | MyISAM | Fixed | 0 | 0 | 0 | 38654705663 | | 1024 | 0 | NULL | 2002-09-02 15:47:35 | 2002-09-02 15:47:35 || NULL | max_rows=4294967295 | | NB 4294967295*9 bytes per row = 38654705663 -- Lukas --------------------------------------------------------------------- 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
