[rt-users] Slow - Tool to Archive ?

[Asif Iqbal]

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

Thanks


On 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