[RESOLVED] Viewing User Connections

luiddog

I'm trying to determine on average how many user connections my site has. I need to determine the average amount because I'm changing hosters and need a host with a higher max_user_connections. But I don't know how high I need. If I could see how many user connections I have on a typical day then I would be able to find the correct hosting plan for my needs.

tomhath

Unless you're running really big/slow queries that take a long time to run, you probably need less than you think. Usually a connection only lasts for a fraction of a second, so the server should be able to handle thousands of hits per hour with a small connection pool. If your queries are taking a long time a bigger connection pool won't help, because the server will be bogged down anyway. Other than a really big site, 25-50 database connections should be plenty.

MarkR

Unless you're creating more than one connection per page (Not recommended; most database servers can serve the contents of several databases using the same connection), there will NEVER be more connections than you have Apache worker processes.

So look at how many apache worker processes / threads you have (Look at MaxClients and other related settings), and set it to a level where it will never exceed the number of max_user_connections.

Then it will never fail in this way even though new connections (to Apache) may have to wait for an available thread.

Mark

luiddog

How would I see the apache worker processes and MaxClients? Another reason why I need to know is that I'm looking to host multiple sites on one account. So 25 connections would be plenty for one site but it wouldn't suit ten sites on one account.

MarkR

luiddog wrote:
How would I see the apache worker processes and MaxClients?

It's in the Apache config - you can modify this with root access of course.

Another reason why I need to know is that I'm looking to host multiple sites on one account. So 25 connections would be plenty for one site but it wouldn't suit ten sites on one account.

Why do you make this assumption? The amount of connections required is entirely dependent on the amount of traffic, NOT the number of sites, which is entirely irrelevant.

Mark

luiddog

I'm sorry. But where would I view the Apache config? I'm on a hoster and do not have root access.

luiddog

mysql 'SHOW STATUS' worked. I looked at 'Threads_connected'.