top button
Flag Notify
Site Registration

What is the maximum size of database in mysql ?

+3 votes

I have started learning PHP and got a thought about mysql.

I did google and found this stack overflow link

But there are less answers and more discussions. Can someone give me the right answer which has full description in it.

posted May 3, 2014 by Karamjeet Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Here are the estimated maximum file sizes per operating system:

Win32 (FAT/FAT32 file system)
- 2GB or 4GB
Win32 (NTFS file system)
- 2TB
Linux Lite 2.2 (Intel 32-bit)
- 2GB (LFS: 4GB)
Linux Lite 2.4+ (using ext3 file system)
- 4TB
Solaris 9 or 10
- 16TB
MacOS X HFS+ (Mac OS Extended)
- 2TB
NetWare (NSS file system)
- 8TB

Source: This information was taken directly off but this is not necessarily the maximum limitations of your database.

answer Dec 21, 2016 by Atindra Kumar Nath
Similar Questions
+1 vote

I have some problem
I have store the data in the database without encrypt but i am view the data encrypt method after 1 day and doesn't know the details.

I am using php and mysql, Could the experts please comment on this, and offer some advice?

0 votes

I have a client where their next auto-increment number just jumped from 2300 to ********** for reasons not understood. They want it set back.

Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a relational table thing. So, is there a way (programmatically) to set the next number in an auto-increment?

Something like:

alter table abc auto_increment = 2301;

Any ideas of why this happened?