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

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

939

---

What is the default port number of mysql?

951

---

If you wish to encrypt the username and password using php, how will you do that?

1022

---

What is difference between statement and preparedstatement?

1004

---

How can we get total number of records by query in mysql?

909

---

Is mysql query case sensitive?

975

---

Is mysql written in c?

904

---

How to find the unique values if the value in the column is repeated?

995

---

Is mysql relational?

918

---

What are the features of mysql?

989

---

What is current version of mysql?

977

---

Why do we use mysql?

942

---

How do I copy a table in mysql?

945

---

What is a blob datatype?

866

---

How do I rename a mysql database?

959

---