Interested to Buy Any Domain ? << Click Here >> for more details...
What is maximum size of a database in MySQL?
- 13 Answers
- 43171 Views
- Bastioncoup, CIS, NM, V2 Solutions, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prathiba
The effective maximum table size for MySQL databases is
usually determined by operating system constraints on file
sizes, not by MySQL internal limits.
| Is This Answer Correct ? | 117 Yes | 20 No |
Answer / vibhor gupta
Operating System File-size Limit
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)
Linux 2.4+ (using ext3 filesystem) 4TB
Solaris 9/10 16TB
MacOS X w/ HFS+ 2TB
NetWare w/NSS filesystem 8TB
| Is This Answer Correct ? | 78 Yes | 8 No |
Answer / rakesh
Operating System File-size Limit
Win32 w/ FAT/FAT32 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
| Is This Answer Correct ? | 27 Yes | 7 No |
Answer / demon
The answer above applies to TABLES in a MySQL DB and not the
DB itself.
Thus the DB can get quite large
| Is This Answer Correct ? | 20 Yes | 6 No |
Answer / shyam
Hi Pravina.. Regarding ur concern in answer #5.. There is no
such limitation on the db size.
It all depends on the table sizes which in turn depends on
the maximum file size the underlying operating system can
handle (for this refer answer# 3 by Vibhor Gupta). As the
table size increases, the db size too increases proportionally.
Of course you will have a drop in the performance if the db
grows in the range of several tera bytes provided you dont
scale your hardware and software correspondingly. That is
when u decide u cannot let the db grow anymore.. Relatively
for u this point may be the one where your db has reached
its maximum size.
Hope this addresses ur query :)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / garun mishra
The MAX size of mysql database is depends on your operating
System.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pravina
But the question is still unanswered...
How large can a DB be? There must be some limitation?
| Is This Answer Correct ? | 8 Yes | 8 No |
Answer / krish
hahah 1 kb ;)
before you work with databases you should know one thing. Database addresses are loaded on to the primary memory. So guess what 32bit OS can only handle max 4gb ram which means only 4gb can be addressed. This results 32bit database can have max size of < 4GB.
If you have a 64bit Database you will be able to address 2^64 bytes. (currently available 256 TB)
krish
source: experience
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / pravina
But if according to answer 3 a table can be 2TB then how can
a db size be smaller then that?
Am confused!!
| Is This Answer Correct ? | 6 Yes | 11 No |
Why are function needed?
what is the difference between gui testing and database testing? : Mysql dba
How do I create a schema in mysql?
What is an index? How can an index be declared in mysql?
How do I enable mysqli extension?
How to convert character strings to dates?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
How do I connect to mysql database?
mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?
What are the other commands to know the structure of a table using mysql commands except explain command?
What is pragma autonomous_transaction?
If we use sum function in mysql, does it return sum of that row or for that column?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
