number of database connections?

LordRogaine

I have a site with roughly 5,000 members. I use php with mysql. The site has been very active latley with a lot of people signing up and re-visiting. Lately I am having a problem with connecting to the database. It seems I am running out of connections. I keep getting error messages saying "cannot connect to database" I have the database set for 100 connections and I have one GB of memory. Is this a sufficient amount of memory and am I using enough connections?
Thanks in advance for any advice or insight!

Lord Rogaine

tude-marie

You might want to make sure that you close your sql connections at the end of the page. Else you might get into trouble with a lot of users.

LordRogaine

I have been closing my connections but it doesn't seem to help at all. It seems that if I have one user do a very large search things slow down. How much memory is the norm for 5,000 active members on the site? I am currently using 1 gb with 100 connections. Is this enough? I'm new to this so I don't know.

tude-marie

1GB is way more than enough. There are different types of buffer sizes you can setup, i seriously doubt that your SQL server uses very much of your memory. Try giving each connection more memory access i think default 64k which would mean you can use a maximum of 64Mb RAM.

Heres some info on MySQL memory usage.

I am no expert though, before i make a fool of my self 😉

LordRogaine

Thanks. I'll give it a try 🙂