PDA

View Full Version : MySQL Limits


Qwerty
3-13-02, 02:50 PM
What are the limits on the MySQL databases?

How many users?
How many tables?
How many fields per table?
What is the maximum length on field content and names of the fields?

Also, what is a good easy to use database management thing?

James
3-14-02, 12:48 AM
We allow you to have 3 mysql users with different permission settings. We have no other limitations other than those of the mySQL server itself. Your database size will be counted against your FTP quota.

There are a number of different mysql clients. There is a list compiled at mysql.com under their downloads section.

Qwerty
3-14-02, 01:44 PM
Originally posted by james
Your database size will be counted against your FTP quota.

uh...this might sound extremely stupid but...

Do you mean that interaction between my scripts and the database counts toward my monthly transfer?

Or that the database takes up room in my 200MB limit?

James
3-14-02, 07:19 PM
Your mysql database will be on the same machine as your website, so there really is not a transfer problem. The database size will count against your 200MB's.

Qwerty
3-15-02, 01:16 PM
alrighty, that is what I figured anyway

thanks for the info :)