[rt-users] performace is very slow on 3.8.2

Tue Aug 11 08:32:46 EDT 2009

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 <aaron at guise.net.nz> 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

> aaron at guise.net.nz

> On Tue, Aug 11, 2009 at 1:57 AM, testwreq at gmail.com> 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: sales at bestpractical.com

> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.

> Buy a copy at http://rtbook.bestpractical.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090811/920e709e/attachment.htm>