[rt-users] Slow - Tool to Archive ?

[Asif Iqbal]

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