[rt-users] performace is very slow on 3.8.2

[Ruslan Zakirov]

It's not a package, but a script and you probably have all deps it needs.

On Tue, Aug 11, 2009 at 4:32 PM, <testwreq at gmail.com> wrote:
> 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
>>
>>
>>
>>
>>
> _______________________________________________
> 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
>



-- 
Best regards, Ruslan.