Ryyo Posted April 27, 2003 Share Posted April 27, 2003 Just a quick question: Is there a maximum limit of tables that a mysql database can hold, or is it just a factor of disk space? Thanks! Link to comment https://forums.phpfreaks.com/topic/406-quickie-whats-the-max-amount-of-tables-in-a-mysql-db/ Share on other sites More sharing options...
shivabharat Posted April 28, 2003 Share Posted April 28, 2003 How Big Can MySQL Tables Be? MySQL Version 3.22 has a 4G limit on table size. 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). Note, however, that operating systems have their own file-size limits. Here are some examples: Operating System File-Size Limit Linux-Intel 32 bit 2G, 4G or more, depends on Linux version Linux-Alpha 8T (?) Solaris 2.5.1 2G (possible 4G with patch) Solaris 2.6 4G (can be changed with flag) Solaris 2.7 Intel 4G Solaris 2.7 UltraSPARC 512G Link to comment https://forums.phpfreaks.com/topic/406-quickie-whats-the-max-amount-of-tables-in-a-mysql-db/#findComment-1363 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.