Re: MySQL 20x faster on RHEL 4 over Solaris 10?

[Michael Johnston]

Thanks for the input Rick!

The machine is running at 1gb network speeds.

I don't know if I'm CPU or I/O Bound...how would I find that out?

I believe I do have the 64-Bit compliant MySQL version. I'm using mysql-5.0.51a-solaris10-sparc-65bit.pkg.

### This is the my.cnf file
[mysqld]
datadir=/opt/mysql/mysql/data
basedir=/opt/mysql/mysql
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 10M
table_cache = 512
sort_buffer_size = 32M
read_buffer_size = 32M
tmp_table_size = 128M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
wait_timeout = 60
thread_concurrency = 256
temp-pool
log-error=/var/log/mysql/mysql.err
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer = 2M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

I'll ask my users if they are using InnoDB or MyISAM. I don't have any clue.

I'm also working on getting those commands you requested.