Hello everyone,
I'm experiencing some performance issues with my testlink installation. As I've inherited the administration of the testlink from someone else in my company my knowledge is limited about testlink.
After getting complaints that testlink was becoming slow, I started searching for a cause.
I've found 2 causes:
1) testlink is writing access logs
2) everything that happens in the mysql database is kept in the "events" table and deleted after 30 days.
I've tried fixing these issues myself but was unable to.
In the "config.inc.php" I changed the log level from debug to error, but this doesn't changes that a line is written to logs/userlog0.log for every page requested by a user.
As I have no idea how the database works I didn't dive into it.
I requested help from the previous administrator, his solution to the log files was to create a cron job that deleted the log files every hour. His solution to the "events" table in the database was to set the retention policy to 1 day instead of 30 days.
This prevents that testlink stops working due to lack of diskspace.
Obvisously this isn't a very good solution to my problem.
Does anyone knows how I disable access logs being written?
Does anyone knows what I can do to prevent records (~100k/day) being written to the "events" table (and for what it's actually used)?
Server info:
Ubuntu 12.04 LTS
Testlink 1.9.5
mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2
PHP 5.3.10-1ubuntu3.11
Regards,
JanR