Hi,
You do not mention if you use MySQL. For our setup it was not apache that was
the bottleneck, rather MySQL. There were a few things we did to speed up OTRS
dramatically:
1) Follow through all the steps mentioned in the OTRS support module
2) Restart all services (MySQL, Apache and OTRS)
3) Next optimize all tables in your MySQL database:
We have a script “optimizetable” with the following contents:
#!/bin/bash
for db in $(echo "SHOW DATABASES;" | mysql -u$1 --password=$2 | grep -v -e
"Database" -e "information_schema")
do
TABLES=$(echo "USE $db; SHOW TABLES;" | mysql -u$1 --password=$2 |
grep -v Tables_in_)
echo "Switching to database $db"
for table in $TABLES
do
echo -n " * Optimizing table $table ... "
echo "USE $db; OPTIMIZE TABLE $table" | mysql -u$1
--password=$2 >/dev/null
echo "done."
done
done
This is called using the following call:
cd /root/Desktop
./optimizetable root EnterPasswordHere
4) Another useful tool I found was “mysqltuner.pl”:
http://mysqltuner.pl/mysqltuner.pl . Google for the name, and download the perl
script to your OTRS MySQL server. In essence it reads the log files of MySQL
and makes recommendations how to improve the performance of MySQL. Your MySQL
needs to be running quite some time in production for the recommendations to be
accurate. We normally run the script, make appropriate modifications to the
MySQL config, restart MySQL, reorganize all tables, then restart all services
(OTRS, Apache, MySQL) and then let the server run in production for one or two
weeks. Then we follow the same steps as above. After two weeks in normal
production you have enough info in the log for the tool to make decent
recommendations.
The perl script is called using:
cd /root/Desktop
perl mysqltuner.pl --user root --pass EnterPasswordHere
The above steps dramatically improved the performance of OTRS.
Hope this helps.
Regards
Rudolf Bargholz
Von: [email protected] [mailto:[email protected]] Im Auftrag von Wagner
Gesendet: Donnerstag, 25. August 2011 22:43
An: User questions and discussions about OTRS.
Betreff: [otrs] Otrs with lighttpd + fastcgi
Hello,
has anyone tried using lighttpd + fascgi instead of apache + mod_perl?
My otrs is very slow, so I was wondering if this could help
Thanks
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
