Hi All
Is there a tool that I can use to archive tickets older than for example few
months or certain date ? That might speed up RT3-0-5
I am using rt-3-0-5 with mysql 4.0.13/perl5.8/apache.1.3.27/modperl1 on a
solaris sparc 420R with 4x440Mhz and 4 gig RAM. I am using my-huge.cnf
Upgrade to rt-3-0-5 did improve the speed a lot but still it takes about 27.9
secs and the httpd goes upto 16% CPU during the time of the following query
time curl http://webrt.arl.qwestip.net/SelfService/Display.html -d user=Asif -d
pass=xxxx -d id=166320
Thanks
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1
Looks like my rt3-0-5 got slower again. Do I need to defrag my database to
improve the performance ?
Here the the values for my conf file
key_buffer = 1G
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
max_allowed_packet = 512M
query_cache_size = 256M
query_cache_type = 1
thread_concurrency = 8
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:1882M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50On Fri, 12 Sep 2003, Asif Iqbal wrote:
Hi All
Is there a tool that I can use to archive tickets older than for example few
months or certain date ? That might speed up RT3-0-5
I am using rt-3-0-5 with mysql 4.0.13/perl5.8/apache.1.3.27/modperl1 on a
solaris sparc 420R with 4x440Mhz and 4 gig RAM. I am using my-huge.cnf
Upgrade to rt-3-0-5 did improve the speed a lot but still it takes about 27.9
secs and the httpd goes upto 16% CPU during the time of the following query
time curl http://webrt.arl.qwestip.net/SelfService/Display.html -d user=Asif -d
pass=xxxx -d id=166320
Thanks
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1
I am not sure if anyone else noticed this as well
Everytime my RT3 gets slower I run the make upgrade from the source and it
speeds it up. Wish there is a better solution out there
ThanksOn Mon, 15 Sep 2003, Asif Iqbal wrote:
Looks like my rt3-0-5 got slower again. Do I need to defrag my database to
improve the performance ?
Here the the values for my conf file
key_buffer = 1G
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
max_allowed_packet = 512M
query_cache_size = 256M
query_cache_type = 1
thread_concurrency = 8
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:1882M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
On Fri, 12 Sep 2003, Asif Iqbal wrote:
Hi All
Is there a tool that I can use to archive tickets older than for example few
months or certain date ? That might speed up RT3-0-5
I am using rt-3-0-5 with mysql 4.0.13/perl5.8/apache.1.3.27/modperl1 on a
solaris sparc 420R with 4x440Mhz and 4 gig RAM. I am using my-huge.cnf
Upgrade to rt-3-0-5 did improve the speed a lot but still it takes about 27.9
secs and the httpd goes upto 16% CPU during the time of the following query
time curl http://webrt.arl.qwestip.net/SelfService/Display.html -d user=Asif -d
pass=xxxx -d id=166320
Thanks
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1