Performace is very slow on 3.8.2

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#

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 http://rackerhacker.com/mysqltuner/

Regards,

*Aaron Guise

07 838 7793
027 212 6638
aaron@guise.net.nzOn Tue, Aug 11, 2009 at 1:57 AM, testwreq@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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

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

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

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

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

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