Question about MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jkirkpatrick
    Junior Member
    • Jan 2005
    • 12

    #1

    Question about MySQL

    Hello,

    I hope everyone will forgive me if this is a stupid question, but I'm wondering how many simultaneous connections to a MySQL database are possible. I'm installing a shopping cart application that uses MySQL and need to know if I'm going to have a problem if my e-commerce store gets busy.

    Thanks,
    Jennifer
  • Grunfeld
    Senior Member
    • Mar 2004
    • 209

    #2
    If your site has not gone over it's bandwidth, you should be ok, monitor it closely and watch the traffic, MYSQL will keep up, that should not be a worry, it would be the overall traffic I would be more concerned about.
    Cheers,

    Gary
    (This space for rent)

    Comment

    • jkirkpatrick
      Junior Member
      • Jan 2005
      • 12

      #3
      Ok, good. Thank you for clarifying that for me.

      I was getting worried when I read on another forum about people having problems with "simultaneous MySQL connections". I got some good tips on how to reduce the load (such as don't include images in the database) but I was worried that if several people were trying to purchase at the same time that I would lose sales!

      Now I can get back to work finishing my store...

      Jennifer

      Comment

      • Frank Hagan
        Senior Member
        • Mar 2004
        • 724

        #4
        You know, this reminds me of something else that they may be talking about, "persistent connections" or something like that. It has to do with how the script opens and closes the database connections, and has an impact on server loading.

        Maybe someone remembers this and can chime in. I remember checking my forums to make sure they did or did not have "persistent connections", but now I can't remember which way is which (and I'm remote, so I can't access my notes.)

        Comment

        • ThomasW
          Member
          • Mar 2004
          • 98

          #5
          I know that "persistent connections" and a shared server are not a good mix. Or so most installs I have seen have said.
          "The word genius isn't applicable in football. A genius is a guy like Norman Einstein!" ... Joe Theisman

          Comment

          • AndrewT
            Administrator
            • Mar 2004
            • 3655

            #6
            Please be sure that persistent connections are not being used (which uses mysql_pconnect among others instead of mysql_connect).

            Comment

            Working...