Maximum rows in Mysql database table

This is the very general question which usually comes in a developers mind that “How much data a mysql table may contain”. This question is also important because as a developer we must know the maximum limit so that we can take appropriate action before table crash.

Moreover the main reason behind database / table crash is disk full. But apart from that maximum table size is also an important factor of table crash And this factor depends on Operating System constraint. Below are the list or OS and their rough data is provided into below list. Although this data may be confirmed from respective OS site.

Operating System File-size Limit

Win32 w/ FAT/FAT3                        2GB/4GB

Win32 w/ NTFS                                 2TB (possibly larger)

Linux 2.2-Intel 32-bit                       2GB (LFS: 4GB)

Linux 2.4+ (using ext3 file system)      4TB

Solaris 9/10                                       16TB

MacOS X w/ HFS+                            2TB

NetWare w/NSS file system 8TB

Now as far as Table size concerned then here are the detail based on Table Engine Type.

MyISAM Engine Type: 2GB (until we are using Large File Support i.e., LFS)

Innodb Eengine Type: We all know innoDB tables are created from several files . This enables a table exceeds the maximum individual files. The combination of these files are known as tablespace. The maximum tablespace size is 64TB.

The following two tabs change content below.

Chandra Shekhar

GCP Architect
Chandra Shekhar Pandey is Google certified Cloud engineer, I am Magento2 Trained developer. Having huge experience in designing cloud solution. I have around 12 years of experience with world enterprise IT companies and fortune 500 clients. During my architecture design I am always caring about high availability, fast performance and resilient system. From the programmer background I have huge experience in LAMP stack as well. Throughout my carrier I have worked on Retail, E-Learning, Video Conferencing and social media domain. The motive of creating cutehits was just to share the knowledge/solutions I get to know during my day to day life so that if possible I can help someone for same problems/solutions. is a really a very effort for sharing knowledge to rest of the world. For any query/suggestion about same you can contact me on below details:- Email: shekharmca2005 at Phone: +91-9560201363

Latest posts by Chandra Shekhar (see all)

You may also like...