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
smime.p7s
Description: S/MIME cryptographic signature
--------------------------------------------------------------------- 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
