Too Many Connections - Dedicated Server Max = 100

[mcyates]

My site is hosted on his dedicated server. www.myfootballforum.com. During the day we have at max about 14 members online with about 30 guests which most are spiders with about 10 being actual users browsing the site. He has other sites on the server but mine is the busiest by far.

He has the max connections set to 100. Surely this should be ample?

Can modifications i've installed from here affect the connections? Maybe preventing them from closing? Surely they should close straight away after a user has got the information from the database?

Thanks in advance.

[Angel-Wings]

Originally Posted by mcyates

My site is hosted on his dedicated server. www.myfootballforum.com. During the day we have at max about 14 members online with about 30 guests which most are spiders with about 10 being actual users browsing the site. He has other sites on the server but mine is the busiest by far.

He has the max connections set to 100. Surely this should be ample?

Set this value for all sites or just for your site ? If there's on DB running serving several sites this value may not be enough.

Originally Posted by mcyates

Can modifications i've installed from here affect the connections? Maybe preventing them from closing?

Can be - specially if "guests" can access or better use modifications that keep the server busy - automatic image resizing and such things - just an example.

Originally Posted by mcyates

Surely they should close straight away after a user has got the information from the database?

Yes and no. Sometimes persistent connections are better, if more or less static info needs to be read over and over again then the entire connection building / reading / closing might slow down things.

Generally - try to disable modifications for guests and maybe ask the server admin for DB optimization, if not done already, with mysqltuner / tuning-primer and at your board, try to store as much as possible in the filesystem (attachments, templates ...)

Finally - the Server Admin can enable the "slow query log" in MySQL that you both can see where the problem is and what Queries cause problems.

Hope this helps a little bit

[Paul M]

What is your wait_timeout setting ?

[mcyates]

Wait_timeout is set at : 28,800

What is that setting? Sorry i took ages to reply and thanks for helping.