Re: Slower machine 100's of times faster??

[David Wynter]

Here is the my.cnf from the 2 * 246 Opteron with 2GB RAM and a soft RAID5 array machine that is performing these selects so poorly

[client]
#password = [your_password]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

innodb_data_home_dir=/var/mysql_data
innodb_log_group_home=/var/mysql_log
default-storage_engine=INNODB
innodb_buffer_pool_size=1500M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=400M
innodb_log_buffer_size=8M

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Suggestions on how to improve it?

David