MySQL 20x faster on RHEL 4 over Solaris 10?

mijohnst · 04-29-2009, 10:10 PM

Sorry, this isn't really all a Linux problem but I'm hoping that there are db admins that look through here. I'm by no means a MySQL admin and I'm having a problem that I just can't figure out, so I'm hoping someone here can point me in the right direction.

I have a 64-bit RHEL 4 server with 2 XEON CPU's and it has 8GB of memory serving as a MySQL server. We decided to upgrade to a newer server that could handle more of a load so we bought was a Sunfire T5140 with 8 sparc quadcore processors and 64 gigs of ram. I've installed the same version level MySQL on the Solaris box but it's literally 20 times slower when extracting data!

I've virtually copied over the /etc/my.cnf file from the RHEL server (only changing lines like threads, database location and pid file location) and it's made no difference. I've even tried increasing all the buffers to no avail. Could anyone point me in the right direction as where else to look? I don't see any problems in the mysql.err file or in the messages file either. Thanks again for the support as always...

chrism01 · 04-29-2009, 10:49 PM

Interesting; can you post the cnf files ?
Also, as this may be a deep qn, you may also want to post this at http://forums.mysql.com/, I'm sure they'd be interested.

mijohnst · 04-30-2009, 11:21 AM

Thanks for the information... I pasted my post from here over there and had not bites. Nevertheless, here is what I have in the my.cnf file.

Code:

[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 was also incorrect in the versions of MySQL that I'm using. On the RHEL box I'm using MySQL-server-standard-5.0.24a-0.rhel4 and on my Sun server I'm using mysql-5.0.51a-solaris10-sparc-65bit.pkg.

Does this stand out to anyone? Thanks again!

chrism01 · 04-30-2009, 09:15 PM

Ah, actually I meant cnf files for both, so we can see what you've changed, unless you can specify the differences exactly(!).

(of course now Oracle has bought Sun, which bought MySQL a while back, maybe they (Oracle) don't like the competition to their (Oracle) product ...

)

twantrd · 05-01-2009, 04:09 AM

Quote:

I've installed the same version level MySQL on the Solaris box but it's literally 20 times slower when extracting data!

Also look at the I/O of the disks on the Sun box. Does your system have a high I/O wait time?

-twantrd