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#
The rt-users Archives
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#
The rt-users Archives
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#
The rt-users Archives
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
The rt-users Archives
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.