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

Can a table have multiple primary keys?

839

---

In which language it is written?

889

---

Is mysql distributed?

871

---

all the queries used in sql

2593

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1081

---

What is datadir?

824

---

Is mysql deprecated?

862

---

can you elaborate on blob and text in mysql? : Mysql dba

848

---

What is the use of innodb in mysql?

925

---

What is blob and clob?

900

---

What is mysql database used for?

960

---

Is mysql free download?

814

---

Why do gaps in sequences occur?

896

---

How can we run batch mode in mysql?

999

---

How can you retrieve a particular number of records from a table?

894

---