MySQL connections not disconnecting
Page: 1
Recent posts in this topic
vrillusions
on Mar 12. 2008. 4:20 pm
Someone reported this issue in 0.7.1 at http://www.activecollab.com/forums/topic/1413/ but thought I'd reopen it here as it's still occurring.
My configuration:
Debian 4.0
Apache 2.2.3
PHP 5.2.0
MySQL 5.0.32
Problem is config/config.php doesn't have a DB_PERSIST option. When I add it and set it to false, it makes no difference. I am pretty sure I just used the my-large.cnf sample config file and tweaked a couple settings as needed. Is there any other way to disable DB_PERSIST and/or just fix mysql so it doesn't hold open connections?
My configuration:
Debian 4.0
Apache 2.2.3
PHP 5.2.0
MySQL 5.0.32
Problem is config/config.php doesn't have a DB_PERSIST option. When I add it and set it to false, it makes no difference. I am pretty sure I just used the my-large.cnf sample config file and tweaked a couple settings as needed. Is there any other way to disable DB_PERSIST and/or just fix mysql so it doesn't hold open connections?
vrillusions
on Mar 12. 2008. 4:39 pm
After doing more searching I found the options to fix it on the mysql end (source). Important lines from that are wait_timeout=60 and interactive_timeout=120. Both default to 28800 seconds, or 8 hours... yeah. I kept the wait timeout at 60 but set interactive to 300 seconds since I'll be on there to debug queries every so often.
Ilija Studen
on Mar 12. 2008. 4:53 pm
You are talking about v1.0 or v0.7.1?
activeCollab 1.0 always opens persistent connections. In order to use mysql_connect() instead of mysql_pconnect() open AngieApplication class located in /activecollab/angie/classes/application/AngieApplication.class.php and change this line:
Into:
activeCollab 1.0 always opens persistent connections. In order to use mysql_connect() instead of mysql_pconnect() open AngieApplication class located in /activecollab/angie/classes/application/AngieApplication.class.php and change this line:
$database_connect = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, true, DB_CHARSET);
Into:
$database_connect = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, false, DB_CHARSET);
activeCollab team member
