LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-29-2009, 11:10 PM   #1
mijohnst
Member
 
Registered: Nov 2003
Location: Huntsville, AL
Distribution: RHEL, Solaris, OSX, SuSE
Posts: 419

Rep: Reputation: 31
MySQL 20x faster on RHEL 4 over Solaris 10?


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...
 
Old 04-29-2009, 11:49 PM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,403

Rep: Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783
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.
 
Old 04-30-2009, 12:21 PM   #3
mijohnst
Member
 
Registered: Nov 2003
Location: Huntsville, AL
Distribution: RHEL, Solaris, OSX, SuSE
Posts: 419

Original Poster
Rep: Reputation: 31
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!
 
Old 04-30-2009, 10:15 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,403

Rep: Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783Reputation: 2783
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 ... )

Last edited by chrism01; 04-30-2009 at 10:17 PM.
 
Old 05-01-2009, 05:09 AM   #5
twantrd
Senior Member
 
Registered: Nov 2002
Location: CA
Distribution: redhat 7.3
Posts: 1,440

Rep: Reputation: 52
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL 20x slower on NFS share mijohnst Linux - General 3 04-05-2011 10:01 AM
hp 20X external usb 2.0 double-layer dvd-wr/cd-rw Question unixshell101 Linux - Hardware 0 11-16-2008 10:15 PM
Help needed for Migration from Sun solaris to RHEL. newbiebd Linux - Server 5 03-01-2008 12:56 AM
Make MySQL faster (Fedora Core 5 x86_64) GATTACA Linux - Software 2 07-21-2006 07:44 PM
RHEL vs aix and solaris msound Linux - General 14 11-23-2005 04:21 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration