Are there any specific settings for RT in my.cnf that I should try before installing any new packages?
<br />
<br />On Aug 11, 2009 2:33am, Aaron Guise <aaron@guise.net.nz> wrote:
<br />> MySQLtuner would be a good place to start. MySQL is unfortunately not configured optimally for RT in a default install.
<br />>
<br />> You can get it here
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> Regards,
<br />>
<br />>
<br />> Aaron Guise
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> 07 838 7793
<br />>
<br />>
<br />> 027
<br />>
<br />> 212 6638
<br />>
<br />>
<br />> aaron@guise.net.nz
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> On Tue, Aug 11, 2009 at 1:57 AM, testwreq@gmail.com> wrote:
<br />>
<br />>
<br />>
<br />>
<br />> Our RT is installed on Linux CentOS 5.3 server running Apache and uses mysql. We just went live 2 days back with the website and RT on the same server, and the performance is slow from day 1. This was not the case when we were testing RT. Probabaly mysql is not configured well. We are pretty new to all this. Below are the contents of my.cnf in the etc folder. I do not have my.cnf in the datadir. I'm not sure if the configuration needs to change in this file and if I should have my.cnf in the datadir folder as well?
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> /etc/my.cnf
<br />>
<br />>
<br />> ===========
<br />>
<br />>
<br />> bash-3.2# more my.cnf
<br />>
<br />>
<br />> [mysqld]
<br />>
<br />>
<br />> datadir=/var/lib/mysql
<br />>
<br />>
<br />> socket=/var/lib/mysql/mysql.sock
<br />>
<br />>
<br />> user=mysql
<br />>
<br />>
<br />> # Default to using old password format for compatibility with mysql 3.x
<br />>
<br />>
<br />> # clients (those using the mysqlclient10 compatibility package).
<br />>
<br />>
<br />> old_passwords=1
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> [mysqld_safe]
<br />>
<br />>
<br />> log-error=/var/log/mysqld.log
<br />>
<br />>
<br />> pid-file=/var/run/mysqld/mysqld.pid
<br />>
<br />>
<br />> bash-3.2#
<br />> _______________________________________________
<br />>
<br />>
<br />> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> Community help: http://wiki.bestpractical.com
<br />>
<br />>
<br />> Commercial support: sales@bestpractical.com
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
<br />>
<br />>
<br />> Buy a copy at http://rtbook.bestpractical.com
<br />>
<br />>
<br />>
<br />>
<br />>