[rt-users] RT 3.0 Speed

Simon Woodward sw-lists at onyx.net
Tue May 6 10:55:31 EDT 2003


Hi Ryan,

> 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.  

Depends how you have it configured ... its either in something like
/etc/my.cnf or ~/my.cnf

or, like me, you can set them from the command line (for example):

/usr/local/mysql/bin/safe_mysqld --user=mysqld
--datadir=/usr/local/var/mysql -O key_buffer_size=256M -O table_cache=64
-O query_cache_size=4M -O max_allowed_packet=1M -O sort_buffer=1M -O
record_buffer=1M -O innodb_data_file_path=/usr/local/var/mysql -O
innodb_data_file_path=ibdata1:10M:autoextend:max:2000M -O
innodb_buffer_pool_size=256M -O innodb_additional_mem_pool_size=64M -O
innodb_log_buffer_size=8M -O innodb_flush_log_at_trx_commit=1 &

You can see what they are set to using the mysql command line client, as
a prived user, type:

show variables;


Cheers,

Simon.
-- 
Simon Woodward <sw-lists at onyx.net>
Onyx Internet




More information about the rt-users mailing list