Question about MySQL

[jkirkpatrick]

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]

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.

[jkirkpatrick]

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

[Frank Hagan]

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.)

[ThomasW]

I know that "persistent connections" and a shared server are not a good mix. Or so most installs I have seen have said.

[AndrewT]

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