[rt-users] RT 3.0 Speed

[Ryan Wheaton]

is it /etc/my.cnf?

cause i don't have ANY of those option variables in there... i guess that
might help.  (sorry about the double post)

-----Original Message-----
From: Ryan Wheaton [mailto:rwheaton at moguls.com]
Sent: Tuesday, May 06, 2003 8:50 AM
To: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0 Speed


excuse my ignorance, but which config file is this information in?  I'd like
to check mine out and see if I can tweak the performance a bit.  

thanks,
-ryan

-----Original Message-----
From: Simon Woodward [mailto:sw-lists at onyx.net]
Sent: Tuesday, May 06, 2003 7:55 AM
To: Autrijus Tang
Cc: Dean Kao; rt-users at lists.fsck.com
Subject: Re: [rt-users] RT 3.0 Speed



> The first two are arguably the most important pair; did you
> forget to set them?

I must have left them out, they are set:

key_buffer_size=128M
table_cache=64

I have however tweaked further with the box, and now have it running with:

key_buffer_size=256M
table_cache=64
query_cache_size=4M
max_allowed_packet=1M
sort_buffer=1M
record_buffer=1M

innodb_data_file_path=/usr/local/var/mysql
innodb_data_file_path=ibdata1:10M:autoextend:max:2000M
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=64M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1

And it hasn't made a difference :-(.



_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm