Your b2evolution version: 0.9.2
Your level of knowledge of Internet technologies: Basic Knowledge
Link to your b2evolution blog: http://www.whatsnextnetwork.com/technology/
PHP Version:
MySQL Version:
What actions led up to your current issue?
MySQL error - too many connections
What have you tried to solve the issue?
Nothing yet
Description and Message
I sometimes get the MySQL error "too many database connections", even though I do not have a lot of traffic.
I was curious about a few things:
1) How is a databse connection defined?
1 website visitor = 1 connection
each table access = 1 connection
each database access = 1 connection (ie listing 10 categories in the sidebar = 10 connections...)
2) How does 0.9.2 handle database connections? Do the connections get reset to zero as soon as a visitor leaves? Or do the connections continue to add up over days until it is maxed out?
3) Is MySQL limited in the software to the number of connections or is this simply a hardware capability issue? If it''s software, is it easy to change through SSH?
Thanks for your help.