How can we optimize MySQL for Testlink

[philips2005]

Most of the Testlink system run on MySQL, and how can we optimize it to get a good performance?
I found that the default config file(my.ini) in the MySQL should update based on the server configurations.
Otherwise, some of the report/query will have no results in Testlink.

The followings list my settings for HP server: 4G RAM/CPU 1.6G,fyi...
key_buffer = 64M
max_allowed_packet = 6M
table_cache = 512
sort_buffer_size = 4M
net_buffer_length = 64K
read_buffer_size = 4M
read_rnd_buffer_size = 8M
mp_table_size = 320M

# Uncomment the following if you are using InnoDB tables
#skip-innodb
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 100M
innodb_log_buffer_size = 200M
innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50, too short
innodb_lock_wait_timeout = 500