What is maximum size of a database in MySQL?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql used for?

669


How do I show all mysql databases?

680


How does mysql store dates?

662


How do I find my mysql username and password?

711


How important is to list the column names when doing an insert?

754






Explain what is mysql?

775


How would you enter characters as hex numbers?

668


What is the data type for image?

784


What is the difference between sql and mysql and oracle?

617


What is inner join in mysql?

625


what is database black box testing? : Mysql dba

770


What is a join? Explain the different types of mysql joins.

966


What do you need to connect php to mysql?

686


What is the difference between truncate and delete in mysql?

769


What is general log in mysql?

637