top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is the maximum size of database in mysql ?

+3 votes
402 views

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

I did google and found this stack overflow link
http://stackoverflow.com/questions/625930/what-is-the-maximum-size-of-a-mysql-database-in-version-5-and-up

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 Google+ Share Button LinkedIn Share Button Multiple Social 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 MySQL.com 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 1000000000 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?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...