Hi,
I have a PIII 800MHz 2GB RAM Linux (Suse 6.4) server running mysql version
3.23.28
I also have 2 Solaris machines a E440R with 2x450MHz CPUs and 512MB of RAM
(this is results 2 & 3)
and a E4500 with 4x450MHz 4MB cache CPUs and 2GB of RAM with a 12 disk SCSI
array connected via fibre.
But but using sql-bench that came with mysql the solaris boxes perform bad..
:(
Even my application seems very sluggish on the Solaris boxes.
I have tried a pre-compiled binary and compling my own.... all still very
slow.
So two things I guess 1) Are Ultra SPARC 450MHz 4MB cache CPUs no match for
a single 800MHz PIII?
2) is there a problem with the Solaris port?
I am using the "huge" my.cnf for all test.
Thanks
Nigel
==================== snip from sql-bench ========================
The test was run with limits from: mysql,pg,solid
The result logs which where found and the options:
1 mysql-Linux_2.4.0_i686 : MySQL 3.23.38
2 mysql-SunOS_5.8_sun4u : MySQL 3.23.38 log
3 mysql-SunOS_5.8_sun4u29fresh : MySQL 3.23.39 log
4 mysql-SunOS_5.8_sun4um : MySQL 3.23.38 log
=====================================================================
Operation | 1| 2| 3| 4|
|mysql-L|mysql-S|mysql-S|mysql-S|
---------------------------------------------------------------------
Results per test in seconds: |
---------------------------------------------------------------------
ATIS | 39.00| 84.00| 85.00| 121.00|
alter-table | 204.00| 641.00| 628.00| 581.00|
big-tables | 33.00| 77.00| 76.00| 96.00|
connect | 59.00| 90.00| 89.00| 142.00|
create | |1683.00|1936.00|1093.00|
insert |2789.00|5244.00|5268.00|5429.00|
select |1382.00|2238.00|+2334.00|+2982.00|
wisconsin | 14.00| 36.00| 35.00| 51.00|
---------------------------------------------------------------------
The results per operation: |
---------------------------------------------------------------------
alter_table_add (992) | 195.00| 625.00| 613.00| 562.00|
connect (10000) | 16.00| 23.00| 23.00| 36.00|
connect+select_1_row (10000) | 19.00| 30.00| 30.00| 47.00|
count (100) | 57.00| 52.00| 51.00| 80.00|
count_distinct (1000) | 71.00| 110.00| 125.00| 132.00|
count_distinct_2 (1000) | 59.00| 128.00| 123.00| 152.00|
count_distinct_big (120) | 107.00| 189.00| 188.00| 288.00|
count_distinct_group (1000) | 62.00| 199.00| 196.00| 384.00|
count_distinct_group_on_key (1000) | 59.00| 93.00| 107.00| 111.00|
count_distinct_group_on_key_parts (1| 78.00| 200.00| 196.00| 386.00|
count_distinct_key_prefix (1000) | 47.00| 85.00| 98.00| 102.00|
count_group_on_key_parts (1000) | 62.00| 77.00| 77.00| 90.00|
count_on_key (50100) | 498.00| 668.00|+705.00|+794.00|
create+drop () | |*563.00|*680.00|*403.00|
create_MANY_tables () | |*349.00|*359.00|*159.00|
create_index (8) | 4.00| 8.00| 7.00| 9.00|
create_key+drop () | |*566.00|*687.00|*420.00|
create_table (31) | 0.00| 3.00| 1.00| 2.00|
delete_all (12) | 14.00| 24.00| 24.00| 34.00|
delete_all_many_keys (1) | 601.00| 534.00| 545.00| 120.00|
delete_big (1) | 0.00| 1.00| 1.00| 1.00|
delete_big_many_keys (128) | 601.00| 534.00| 545.00| 120.00|
delete_key (10000) | 5.00| 9.00| 9.00| 11.00|
drop_index (8) | 5.00| 7.00| 7.00| 9.00|
drop_table (28) | 0.00| 1.00| 2.00| 1.00|
drop_table_when_MANY_tables () | |*199.00|*204.00| *99.00|
insert (350768) | 121.00| 322.00| 323.00| 423.00|
insert_duplicates (100000) | 30.00| 57.00| 57.00| 101.00|
insert_key (100000) | 225.00|1003.00|1022.00| 282.00|
insert_many_fields (2000) | 10.00| 20.00| 18.00| 24.00|
insert_select_1_key (1) | 8.00| 11.00| 12.00| 13.00|
insert_select_2_keys (1) | 10.00| 14.00| 13.00| 17.00|
min_max (60) | 27.00| 39.00| 42.00| 52.00|
min_max_on_key (85000) | 200.00| 283.00| 291.00| 357.00|
order_by_big (10) | 42.00| 98.00| 98.00| 128.00|
order_by_big_key (10) | 33.00| 86.00| 86.00| 97.00|
order_by_big_key2 (10) | 29.00| 84.00| 83.00| 94.00|
order_by_big_key_desc (10) | 34.00| 87.00| 86.00| 97.00|
order_by_big_key_diff (10) | 40.00| 95.00| 94.00| 126.00|
order_by_big_key_prefix (10) | 27.00| 83.00| 83.00| 93.00|
order_by_key2_diff (500) | 4.00| 13.00| 13.00| 18.00|
order_by_key_prefix (500) | 3.00| 6.00| 7.00| 10.00|
order_by_range (500) | 6.00| 9.00| 8.00| 13.00|
select_1_row (10000) | 4.00| 6.00| 6.00| 11.00|
select_2_rows (10000) | 3.00| 7.00| 7.00| 12.00|
select_big (10080) | 41.00| 103.00| 101.00| 120.00|
select_column+column (10000) | 3.00| 7.00| 6.00| 11.00|
select_diff_key (500) | 218.00| 314.00| 312.00| 444.00|
select_distinct (800) | 10.00| 24.00| 25.00| 34.00|
select_group (2701) | 49.00| 70.00| 76.00| 94.00|
select_group_when_MANY_tables () | | *6.00| *6.00| *12.00|
select_join (100) | 2.00| 4.00| 4.00| 6.00|
select_key (200000) | 131.00| 222.00| 225.00| 319.00|
select_key2 (200000) | 134.00| 234.00| 232.00| 331.00|
select_key2_return_key (200000) | 130.00| 215.00| 213.00| 303.00|
select_key2_return_prim (200000) | 132.00| 224.00| 222.00| 321.00|
select_key_prefix (200000) | 136.00| 236.00| 235.00| 334.00|
select_key_prefix_join (100) | 12.00| 21.00| 21.00| 24.00|
select_key_return_key (200000) | 126.00| 214.00| 214.00| 306.00|
select_many_fields (2000) | 23.00| 57.00| 58.00| 71.00|
select_query_cache (10000) | 115.00| 210.00| 223.00| 241.00|
select_query_cache2 (10000) | 118.00| 209.00| 223.00| 241.00|
select_range (410) | 3.00| 5.00| 6.00| 8.00|
select_range_key2 (25010) | 20.00| 36.00| 35.00| 47.00|
select_range_prefix (25010) | 21.00| 37.00| 36.00| 50.00|
select_simple_join (500) | 2.00| 3.00| 3.00| 5.00|
update_big (10) | 22.00| 64.00| 61.00| 120.00|
update_of_key (50000) | 27.00| 74.00| 71.00| 68.00|
update_of_key_big (501) | 25.00| 41.00| 41.00| 57.00|
update_of_primary_key_many_keys (256| 62.00| 121.00| 120.00| 59.00|
update_with_key (300000) | 107.00| 205.00| 205.00| 350.00|
update_with_key_prefix (100000) | 32.00| 62.00| 60.00| 107.00|
wisc_benchmark (114) | 4.00| 8.00| 8.00| 10.00|
---------------------------------------------------------------------
TOTALS |5121.00|10626.00|+10994.00|+10613.00|
=====================================================================
---------------------------------------------------------------------
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
