Hello -
This week we moved from running MySQL 3.23.33 on a Dual PIII 750 machine to
running MySQL 3.23.41 a Sun E220 Dual UltraSparc || 450 machine. Both
machines have 1 Gb of RAM, both machines are dedicated to running MySQL,
both keep data and log files on seperate SCSI drives, and both are running
MySQL with the following variables tweaked in the my.cnf file:
key-buffer=32M
sort_buffer=4M
record_buffer=1M
max_connections=1000
table_cache=1000
Since we have cut to the Solaris box we have been running an average of 30
queries a second vs. around 50 queries a second on the Linux box running
against the same data set. We added a couple of additional tables during
the move, but there should be very few queries (~ 100 queries an hour)
addressing those tables and none of them are being flagged as slow queries.
Does anyone have an recommendations on how we can get our performance back
to (or above) where it was? I have checked the online manual and the list
archive, but I haven't found anything that addresses the situation we have
run into. We have already tried recompiling w/ the Sun compiler, but we are
still seeing less than expected performance. True, there is *always* room
for refinement of our queries, but that doesn't explain why we are
experienced such a severe performance drop on the new architecture.
I should also mention the we are seeing a subsequent increase in server
load. We used to run between .5 and 2: now we are running between 3 and 10.
I have always been told that a 450 UltraSparc should outperform 750 PIII,
but that does not appear to be proving true.
Any recommendations would be greatly appreciated.
-F
+++++++++++++++++++++++++++++++++++++++
Floyd Mann, Webmaster, [EMAIL PROTECTED]
503.227.2571 x 227 cell. 503.806.1194
TechTracker VersionTracker MacFixIt
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
