MySQL Database Limits

[redsox9]

I'm sure that I know the answer but is there a limit to the number of tables that can be created in a MySQL database? Or is there a data limit? I don't ever anticipate reaching a "limit" but I'm just curious and maybe this is a question that someone else might have.

[grant]

Before I signed up I asked about bluehost's MySQL policy and as I understood it at the time there is no limit in size, or scope as to how big you want your data tables, or data to be. The only thing I'm sure of is that we get 50 MySQL databases, which is way more than I need at the moment.

Not sure if that answers what you're asking or not though. I tried. :)

[thicke]

You can probably find out more than you ever wanted to know here (http://dev.mysql.com/doc/refman/4.1/en/table-size.html).

[ahwm]

Resurrecting an old thread... But the mod keeps saying to search, so...

MySQL 4.x has an option called max_questions_resource which limits the number of queries per user per hour. I never reached it on my old host. But another site I used to help with was on a host which limited this to 50,000. Get a very active forum, and this gets shot completely.

My question is: What is Bluehost's max_questions_resource setting?

The last time this was asked via email by someone other than me. We were told that the access limit was 5 or 50 at a time. I don't remember which at the moment.