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