Hi Jan,
I used the following to improve the performance of our MySQL dramatically:
http://mysqltuner.com/mysqltuner.pl
Some of the SQL in OTRS could probably be better, but the script did a lot to
help. You need to make changes, then let the system run a couple of days, then
run the script aga
Hi Jan,
Have you checked the recommendations in the Support Module?
Apart from that, the so called "Full text searches" -- which are not
using FTS indexes in MySQL, as you might expect -- are known to
generate heavy requests. I have a proposal of creating an article
search backend that uses MySQL
