Jump to content


Quickie: Whats the max amount of tables in a mysql DB?

  • Please log in to reply
1 reply to this topic

#1 Ryyo

  • Members
  • Pip
  • Newbie
  • 3 posts
  • LocationEast Lansing, MI

Posted 27 April 2003 - 08:58 PM

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?



#2 shivabharat

  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 28 April 2003 - 03:20 PM

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

Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users