Since I started RT, I've always gotten these three comments from mysqltuner
[!!] Temporary tables created on disk: 30% (354 on disk / 1K total)
[!!] Table cache hit rate: 18% (40 open / 222 opened)
General recommendations:
Reduce your SELECT DISTINCT queries without LIMIT clauses
Is there a way to help the above metrics and reduce the select disticnt queries
thing? Are these code-level changes or just more/better usage by our staff?
If it's a usage thing, what things should we stop doing and what should we
start doing?
If the answer is to have better/more index in MySQL (a recommendation I've seen
many times on this list), could you please also include a recommendation on the
index itself? I don't know what indexes to create.
RT382, MySQL 5.077, Apache 2.2.11, mod-perl 2.04, mysqltuner 1.00, OpenBSD
4.4-STABLE, 2.5GB RAM, 3GB swap. Machine dedicated to RT.
Thank you,
PH
--
Paul Hirose : [email protected] : Sysadm Motto: rm -fr /MyLife
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
