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
Where’s database data actually stored? Is there a way to see the files which are stored?
How we can create index in mysql?
What are different types of queries?
Is mysql an oracle product?
Is mysql case-sensitive?
What are date and time intervals?
What is delimiter $$?
What is difference between microsoft sql and mysql?
What is indexing in mysql?
How can you export the table as an xml file in mysql?
What is a select query?
Is mysql easy to learn?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Where does mysql store data?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.