Naming a MySQL database + MySQL "specs"?

[SteveC]

Hi all. :)

Just a quick question. I'm setting up a MySQL database, and I was just wondering, does it matter what I name it? I understand we have to pay $10 for each one we need, so I wanted to know if I should name it something general or what I should do...

Also, what are the allowances/limits on a MySQL database, such as space, the number of requests/queries, or how is it measured? I'm very new to MySQL so anyone who can offer "newbie" tips will be much appreciated! Thanks! :)

[Pig]

I don't believe that powweb allows you to name a database. It should be based off of your domain.

[SteveC]

In OPS, where you order one, it says, "Please enter the name that you would like to use for your mysql database." Is this the same thing?

[Pig]

/me gasps...

They must have changed that since I reg'ed mine. :( Or I'm going blind.

Yeah, that's what you want. Nevermind what I said before. :/

[Jeff321]

http://www.powweb.com/faqs/?category=mySQL&faq_id=277 should answer your questions about queries.

The name doesn't really matter. It's up to you how you want to do it.

[SteveC]

Thanks Jeff!

Can you (or anyone) explain the details to me? It says you can have 3 users per database - what is a user?

Also, MySQL limitations are set to 36,000 questions per hour, and 3,600 connections per hour per user. What counts as a "question" or "connection"? For example, how would a message board's usage translate into this so I can get an idea of how much a board would use?

[Jeff321]

Each database may have up to 3 username/password combos which will connect to it. Each one has 36,000 queries/hour and 3,600 connections/hour. A connection is a script connecting to MySQL. Usually only 1 is required per page load. A query or a question is asking the MySQL database for some information. There may be multiple queries per connection.

As for running a message board, it all depends on which one you are using. PowWeb says they run this vBulletin board under the same MySQL restrictions that you and I have. However, some boards make inefficient use of queries and may cause you to hit the limits even though you have less users than this forum has. If your board won't have many users, you really shouldn't have to worry about the restrictions regardless of what message board you use.

[SteveC]

Thank you Jeff. That helps for sure. Now I guess I'll learn as I go?? :)