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! Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.