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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
|
04-29-2009, 11:10 PM
|
#1
|
Member
Registered: Nov 2003
Location: Huntsville, AL
Distribution: RHEL, Solaris, OSX, SuSE
Posts: 419
Rep:
|
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...
|
|
|
04-29-2009, 11:49 PM
|
#2
|
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,403
|
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.
|
|
|
04-30-2009, 12:21 PM
|
#3
|
Member
Registered: Nov 2003
Location: Huntsville, AL
Distribution: RHEL, Solaris, OSX, SuSE
Posts: 419
Original Poster
Rep:
|
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!
|
|
|
04-30-2009, 10:15 PM
|
#4
|
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,403
|
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.
|
|
|
05-01-2009, 05:09 AM
|
#5
|
Senior Member
Registered: Nov 2002
Location: CA
Distribution: redhat 7.3
Posts: 1,440
Rep:
|
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
|
|
|
All times are GMT -5. The time now is 05:13 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|