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 :)

What mysql -u john -p command does?

514

---

What is delimiter $$?

502

---

What are the types of index?

517

---

How do I backup mysql database on linux?

486

---

How do I check mysql version?

491

---

---

Which is best pdo or mysqli?

484

---

Why mysql is open source?

489

---

How to create a trigger in mysql?

500

---

How to create a test table in your mysql server?

503

---

change column name and make a unique column so we get no dupes.

504

---

How do I free up space in mysql?

492

---

How we can get distinct columns values in mysql?

605

---

what is cte? : Mysql dba

521

---

how can you test for null values in a database? : Mysql dba

478

---

How to calculate the difference between two time values?

459

---