Are there any specific settings for RT in my.cnf that I should try before installing any new packages?

On Aug 11, 2009 2:33am, Aaron Guise <[email protected]> wrote:
MySQLtuner would be a good place to start. MySQL is unfortunately not configured optimally for RT in a default install.

You can get it here





Regards,


Aaron Guise





07 838 7793


027

212 6638


[email protected]











On Tue, Aug 11, 2009 at 1:57 AM, [email protected]> wrote:




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?








/etc/my.cnf


===========


bash-3.2# more my.cnf


[mysqld]


datadir=/var/lib/mysql


socket=/var/lib/mysql/mysql.sock


user=mysql


# Default to using old password format for compatibility with mysql 3.x


# clients (those using the mysqlclient10 compatibility package).


old_passwords=1





[mysqld_safe]


log-error=/var/log/mysqld.log


pid-file=/var/run/mysqld/mysqld.pid


bash-3.2#
_______________________________________________


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





_______________________________________________
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

Reply via email to