[rt-users] httpd's are more than 10%

[Asif Iqbal]

My RT3 is still slow afetr upgrading it from 3.04. to 3.0.5pre3. This is how my
cnf file looks like

[client]
port            = 3306
socket          = /tmp/mysql.sock

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
thread_concurrency = 8

server-id       = 1

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[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

I have only InnoDB and MyISAM tables as part of the default setup

Any suggestion for improvement now ?

Thanks a lot

On Sun, 24 Aug 2003, [iso-8859-2] Ale¹ Su¹nik wrote:

> Try optimizing your mysql (there's plenty of info about that on the web).
> You said you've got 4gb of RAM, use it well...
>
> A.
>
> -----Original Message-----
> From: Asif Iqbal [mailto:iqbala at qwestip.net]
> Sent: Saturday, August 23, 2003 11:55 PM
> To: Ale¹ Su¹nik
> Cc: rt-users at lists.fsck.com
> Subject: RE: [rt-users] httpd's are more than 10%
>
>
> On Thu, 21 Aug 2003, [iso-8859-2] Ale¹ Su¹nik wrote:
>
> > Try to go with my-large.cnf, the amount of RAM you've got is plenty for
> > my-large.
> >
> > And yes try 3.0.5pre3.
> >
> > A.
>
> using my-large instead of my-medium and upgraded from RT-3-0-4 to
> RT-3-0-5pre3
> and now the same ticket takes 9.5 sec to retrieve instead of 58 secs
>
> Now I am not sure if I need to be concerned about the httpds that are
> *still* over 10%
>
> Thanks for all the help
> >
> > -----Original Message-----
> > From: Asif Iqbal [mailto:iqbala at qwestip.net]
> > Sent: Thursday, August 21, 2003 4:46 PM
> > To: Ale¹ Su¹nik
> > Subject: RE: [rt-users] httpd's are more than 10%
> >
> >
> > On Thu, 21 Aug 2003, [iso-8859-2] Ale¹ Su¹nik wrote:
> >
> > > HW configuration?
> >
> > Soalris 420R, 4x450 Mhz/4 GB Ram
> >
> > > mysql config?
> >
> > my-medium.cnf
> >
> > > Tried 3.0.5pre3?
> >
> > No, should I ?
> >
> > >
> > > A.
> > >
> > > -----Original Message-----
> > > From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]
> > > On Behalf Of Asif Iqbal
> > > Sent: Thursday, August 21, 2003 3:58 PM
> > > To: rt-users at lists.fsck.com
> > > Cc: rt-devel at lists.fsck.com
> > > Subject: [rt-users] httpd's are more than 10%
> > >
> > >
> > > I am using RT-3-0-4/Mysql4.0.13/Apache 1.3.27+mod_perl1/Perl 5.8
> > >
> > > I noticed three out of 10 of my httpd sessions are taking more than 10%
> of
> > > CPU
> > > and they are excruciatingly slow. Not sure if we need to switch to a
> > > different
> > > product at this time. I really had very good experience with RT2 and not
> > > with
> > > RT3. I followed the instruction while upgrading to RT3.
> > >
> > > Someone else experiencing the same way ?
> > >
> > > Sorry I needed to vent out :-(
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1