Recent Topics

Automatic creation of mysql threads

Started by on Oct 24, 2005 – Contents updated: Oct 24, 2005

Oct 24, 2005 20:00    

b2evo has started creating threads in mysql on it's own... most likely from our host's upgrade of php. I'm running 0.9.0.11(Paris) right now, and as soon as someone hits the journal for the first time, it seems to create a new mysql thread about every 50-60 seconds. This would be fine, if those threads didn't sit there sleeping, until we hit our max_connections. It almost seems like b2evo is creating persistant connections!

If anyone has any ideas on how to fix this problem, I would appreciate it very much! As of now, our site is crashing every 15 min. until I kill the mysql threads!

btw, in php...

Active Persistent Links 3
Active Links 3
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value

mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

I can't change any of thse values (shared server).

Thank you!

Oct 24, 2005 20:40

We're running the same version as you are and don't have a problem. I don't know what to suggest, other than perhaps upgrade to a newer version, as that MIGHT fix the problem.

The only other thought isn't a FIX, but could tide you over till "Phoenix" comes out - create a CRON job to kill those 'sleeping' threads every so often, thus avoiding a max_connections crash. (Ain't exactly pretty and it does assume that you can identify WHICH threads to kill, but it's the only thing I can think of ... off the top of my addled head).

Hope this helps.

-stk :D


Form is loading...

powered by b2evolution CMS – This forum is powered by b2evolution CMS, a complete engine for your website.