Results 1 to 6 of 6
  1. #1

    Question what does the number of MySQL Database mean?

    some web hosting plan has 1 MySQL Database, and some have 3, or more. what does the number mean? is it the more the better?


    thanks a lot.

  2. #2
    Its not the more the better, its how many you need for your website.

    If you need 1, that is good enough. If you need more then 1 you should look for more then 1.

  3. #3
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,574
    Certain scripts such as forums, topsite lists, polls, mostly PHP scripts, require a MySQL database. Sometimes you can get more than one script on the same database--albeit it will be messy. One WHT member came up with this analogy:

    Think of the databases as filing cabinets, the tables as folders and the rows as items (within the folders).

    Cheers,
    MediaLayer, LLC - www.medialayer.com Learn how we can make your website load faster, translating to better conversion rates for your business!
    The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business

  4. #4
    is it mean one database can be full if there are too many datas, then i need more than one database?
    or if i have only one php forum, then no matter what, one database is enough?

  5. #5
    Join Date
    Apr 2004
    Location
    Singapore
    Posts
    617
    most online scripts used mysql database. with a mysql database, your data is retrieve and store more efficiently. Thus, it is an advantage if your webhost provide you mysql db.
    Linux System admin (since 2001)
    * cPanel/WHM, Directadmin, Apache, DNS, PHP, HyperVM, Lxadmin, Openvz*

  6. #6

    Re: what does the number of MySQL Database mean?

    Originally posted by dogeye
    some web hosting plan has 1 MySQL Database, and some have 3, or more. what does the number mean? is it the more the better?
    Hello,

    The actual number of databases you are allowed to host really is irrelavent - the only thing that matters is the quota limitations placed on database size.

    You can easily run several applications off of a single DB if you like (just by utilizing different table prefixes).

    In other words 100 MySQL DB's each having a 1 MB quota is just as useful as 1 MySQL with a 100MB Quota.

    Hope this helps...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •