I think what you see is the fact that x86systems have overtaken
workstations in some respect.
have a look at spec.org for specint (which should be most relevant for
databases)
the same is true for memory throughput (look out for streambench)
At 01:13 PM 9/6/2001 -0700, Floyd Mann wrote:
>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
---------------------------------------------------------------------
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
