[rt-users] new version seems lot slower with more resources

Asif Iqbal vadud3 at gmail.com
Tue Apr 28 11:01:45 EDT 2009


Older setup:

RT 3.4.5 with mysql 4.0.24 and Perl 5.8.6 on V20z with 2 1.8Ghz and 4G mem

mysql> select count(*) from Tickets;
+----------+
| count(*) |
+----------+
|   406311 |
+----------+
1 row in set (0.25 sec)

Newer setup:

RT 3.8.2 with mysql 5.0.75 and Perl 5.8.8 on T1000 with 24 1Ghz cpu threads
and 16GB mem

mysql> select count(*) from Tickets;
+----------+
| count(*) |
+----------+
|   401576 |
+----------+
1 row in set (2.02 sec)


As you can see it is really slow

Here is my my.cnf file

[client]
port            = 3306
socket          = /tmp/mysql.sock
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 1G
max_allowed_packet = 50M
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
server-id       = 1
skip-federated
innodb_data_home_dir = /var/opt/csw/mysql5/
innodb_data_file_path = ibdata1:2000M;ibdata2:50M:autoextend
innodb_log_group_home_dir = /var/opt/csw/mysql5/
innodb_log_arch_dir = /var/opt/csw/mysql5/
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 250M
innodb_log_buffer_size = 20M
innodb_flush_log_at_trx_commit = 2
[mysqldump]
quick
max_allowed_packet = 50M
[mysql]
no-auto-rehash
safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout



-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090428/1c616a59/attachment.htm>


More information about the rt-users mailing list