Does anyone know what the maximum number of rows a MyISAM table can store is? We currently have a table (27 GB .MYD, 17GB .MYI) holding more than 2^31 rows:
mysql> select count(*) from BigTable; +------------+ | count(*) | +------------+ | 2222947945 | +------------+ 1 row in set (0.09 sec) We're afraid there is hard, implementation imposed limit of unsigned int (2^32) on the number of rows. Before trying to verify this by loading 4.3 billion records into a table, I thought it would be worth asking... Thanks, Lukas Knecht --------------------------------------------------------------------- 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