PDA

View Full Version : What is the space allocation for mysql?



jimmi
02-28-2006, 12:14 PM
I can't find this info anywhere... I know that there are 50 databases possible, however is there a total space limitation on the database combined? What about individual space restrictions?


Cheers,
jimmi

crazypenguin
02-28-2006, 05:52 PM
I am curious as well if any quotas for SQL storage apply?

alligosh
02-28-2006, 08:11 PM
I am curious as well if any quotas for SQL storage apply?

Mysql drive space is counted as part of the total drive space that you have.

In general, however, if your mysql databases take any real part of the ten gigabytes, you have other issues.

:)

Sai
02-28-2006, 08:28 PM
so the limit of data stored in a database is shared with our 10GB web storage spage? :confused:

the database where my forum is stored is already using up 18MB...<--- i was wondering if there's a limit to that just a while ago...

alligosh
03-01-2006, 05:03 AM
so the limit of data stored in a database is shared with our 10GB web storage spage? :confused:

the database where my forum is stored is already using up 18MB...<--- i was wondering if there's a limit to that just a while ago...


We do not currently put limits on database size. It just counts as drive and file space taken up in you raccount as part of the 10 GB.

There are a few users with databases in the 100 - 200 MB range (and probably some even larger). I believe most of those tend to have performance issues unless the owner is very carefull about indexes, optimizing, etc. (mysql can handle fairly large databases, but just like any of the expensive DBs out there, they have to be done right)