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 again. Letting the DB work in production gives the script necessary information about how to optimize your DB.

Regards

Rudolf

Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Jan.Dreyer@bertelsmann.de
Gesendet: Mittwoch, 1. Juni 2011 14:14
An: otrs@otrs.org
Betreff: [otrs] OTRS and Mysql performance

Hi,

we have two OTRS instances on one server, nothing else is running there.

There are some mysql statistics though, that make me worry:

· Slow_queries: 96

· Innodb_buffer_pool_reads: 12

· Handler_read_rnd: 9,198 k

· Handler_read_rnd_next: 710 M

· Created_tmp_disk_tables: 2,581

· Select_full_join: 31 k

· Opened_tables: 29 k

· Table_locks_waited: 11 k

Some of these could be improved by changing settings of innodb_buffer_pool_size, tmp_table_size and max_heap_table_size in my.cnf, but others (Handler_read_rnd, Select_full_join, …) are pointing to bad optimized requests.

Are there any documents about Mysql-performance (and –tweaking) wrt OTRS? (besides http://doc.otrs.org/2.4/en/html/performance-tuning-database.html I mean)

Regards,

Jan Dreyer