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-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von jan.dre...@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
--------------------------------------------------------------------- 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
