Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Location
    in province of Quebec in Canada
    Posts
    2

    Question Unanswered: Optimize MYSQL DB

    Hello,

    I want to optimize my database in mysql v 5.1.32.

    Actually i host a web site that use my DB, and all of my table is in one Data base!

    At first, is taht correct to to only one database? Or it's better to have more?


    Thank's for your help!

    Pascal_22

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oui

    until you need more than one database, use just one

    if you are implementing different scripts like content management, e-commerce, etc., and they come with their own tables, then that might be a good reason to segregate the tables into different databases

    size alone is not usually a good reason to have more than one database, because more than one introduces further complexities (e.g. single site signon)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2010
    Location
    in province of Quebec in Canada
    Posts
    2
    Good, thak's for the comments.

    If we talk about the maximun connexion allowed: is that a config for Apache or mysql ? or do we need to set up a maximum connexion for each Database in mysql??


    Thank's

    Pascal_22

Tags for this Thread

Posting Permissions

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