Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs). 'Insert' is faster on Panther than on Jaguar (3316 secs vs. 5215 secs), but all other benchmarks are somewhat slower on Panther. I'm a bit worried about the 'select', which is about twice as slow on Panther than on Jaguar (1428 secs vs. 743 secs).
Complete benchmark results below, sorry for the possible bandwidth waste, but I'm not sure what I could snip, if anything.
JP
Panther benchmarks: ============================================================================= Benchmark DBD suite: 2.14 Date of test: 2003-11-07 0:12:11 Running tests on: Darwin 7.0.0 Power Macintosh Arguments: Comments: Limits from: mysql,pg,solid Server version: MySQL 4.0.15 standard log Optimization: None Hardware:
alter-table: Total time: 141 wallclock secs ( 0.22 usr 0.11 sys + 0.00 cusr 0.00 csys = 0.33 CPU)
ATIS: Total time: 59 wallclock secs (10.59 usr 6.30 sys + 0.00 cusr 0.00 csys = 16.89 CPU)
big-tables: Total time: 57 wallclock secs ( 7.53 usr 13.50 sys + 0.00 cusr 0.00 csys = 21.03 CPU)
connect: Total time: 252 wallclock secs (44.31 usr 38.81 sys + 0.00 cusr 0.00 csys = 83.12 CPU)
create: Total time: 298 wallclock secs ( 8.76 usr 3.06 sys + 0.00 cusr 0.00 csys = 11.82 CPU)
insert: Total time: 3316 wallclock secs (594.82 usr 261.66 sys + 0.00 cusr 0.00 csys = 856.48 CPU)
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 0.00 cusr 0.00 csys = 92.68 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 27 wallclock secs ( 4.19 usr 2.58 sys + 0.00 cusr 0.00 csys = 6.77 CPU)
All 9 test executed successfully
Totals per operation: Operation seconds usr sys cpu tests alter_table_add 134.00 0.20 0.09 0.29 992 connect 16.00 6.71 1.30 8.01 10000 connect+select_1_row 23.00 7.65 2.21 9.86 10000 count 38.00 0.04 0.02 0.06 100 count_distinct 27.00 0.39 0.09 0.48 1000 count_distinct_big 124.00 9.59 6.03 15.62 120 count_distinct_group 184.00 1.59 0.80 2.39 1000 count_distinct_group_on_key 31.00 0.49 0.10 0.59 1000 count_distinct_group_on_key_parts 182.00 1.36 0.75 2.11 1000 count_distinct_key_prefix 21.00 0.46 0.09 0.55 1000 count_group_on_key_parts 38.00 1.26 0.67 1.93 1000 count_on_key 383.00 15.73 3.78 19.51 50100 create+drop 111.00 3.39 0.98 4.37 10000 create_MANY_tables 46.00 1.15 0.36 1.51 5000 create_index 3.00 0.00 0.00 0.00 8 create_key+drop 121.00 3.16 1.16 4.32 10000 create_table 0.00 0.01 0.00 0.01 31 delete_all_many_keys 59.00 0.02 0.02 0.04 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 59.00 0.02 0.02 0.04 128 delete_key 5.00 0.47 0.31 0.78 10000 delete_range 11.00 0.00 0.00 0.00 12 drop_index 3.00 0.00 0.00 0.00 8 drop_table 1.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 12.00 0.44 0.14 0.58 5000 insert 188.00 18.93 10.96 29.89 350768 insert_duplicates 33.00 4.58 3.02 7.60 100000 insert_key 168.00 12.50 4.27 16.77 100000 insert_many_fields 10.00 0.41 0.16 0.57 2000 insert_select_1_key 5.00 0.00 0.00 0.00 1 insert_select_2_keys 6.00 0.00 0.00 0.00 1 min_max 20.00 0.05 0.00 0.05 60 min_max_on_key 169.00 22.06 5.41 27.47 85000 order_by_big 128.00 24.08 17.32 41.40 10 order_by_big_key 89.00 27.07 19.61 46.68 10 order_by_big_key2 86.00 24.30 18.88 43.18 10 order_by_big_key_desc 94.00 27.52 20.67 48.19 10 order_by_big_key_diff 116.00 25.02 16.13 41.15 10 order_by_big_key_prefix 87.00 24.71 18.71 43.42 10 order_by_key2_diff 10.00 2.21 1.42 3.63 500 order_by_key_prefix 5.00 1.13 0.72 1.85 500 order_by_range 11.00 1.28 0.78 2.06 500 outer_join 91.00 0.00 0.00 0.00 10 outer_join_found 87.00 0.00 0.00 0.00 10 outer_join_not_found 41.00 0.00 0.00 0.00 500 outer_join_on_key 33.00 0.00 0.01 0.01 10 select_1_row 34.00 5.83 6.72 12.55 100000 select_1_row_cache 31.00 5.20 5.78 10.98 100000 select_2_rows 59.00 7.76 7.53 15.29 100000 select_big 91.00 27.10 20.37 47.47 80 select_big_str 57.00 5.59 10.21 15.80 10000 select_cache 122.00 3.46 0.68 4.14 10000 select_cache2 123.00 3.62 0.63 4.25 10000 select_column+column 32.00 5.57 5.05 10.62 100000 select_diff_key 158.00 0.18 0.06 0.24 500 select_distinct 13.00 2.04 1.10 3.14 800 select_group 40.00 1.62 0.59 2.21 2701 select_group_when_MANY_tables 8.00 0.62 0.42 1.04 5000 select_join 3.00 0.65 0.31 0.96 100 select_key 175.00 54.27 14.64 68.91 200000 select_key2 179.00 54.65 14.99 69.64 200000 select_key2_return_key 161.00 50.43 11.47 61.90 200000 select_key2_return_prim 174.00 53.24 13.63 66.87 200000 select_key_prefix 182.00 54.88 14.84 69.72 200000 select_key_prefix_join 18.00 4.93 3.64 8.57 100 select_key_return_key 169.00 52.49 13.14 65.63 200000 select_many_fields 47.00 7.12 13.34 20.46 2000 select_range 141.00 10.26 6.57 16.83 410 select_range_key2 24.00 5.30 2.04 7.34 25010 select_range_prefix 25.00 5.71 1.84 7.55 25010 select_simple_join 3.00 0.65 0.39 1.04 500 update_big 49.00 0.01 0.00 0.01 10 update_of_key 51.00 3.95 1.60 5.55 50000 update_of_key_big 21.00 0.01 0.02 0.03 501 update_of_primary_key_many_keys 25.00 0.02 0.03 0.05 256 update_with_key 175.00 16.88 9.99 26.87 300000 update_with_key_prefix 54.00 10.03 3.68 13.71 100000 wisc_benchmark 8.00 2.16 1.59 3.75 114 TOTALS 5561.00 726.22 343.88 1070.10 2900541 ============================================================== Jaguar benchmarks: ============================================================== Benchmark DBD suite: 2.14 Date of test: 2003-09-29 22:20:05 Running tests on: Darwin 6.7.5 Power Macintosh Arguments: Comments: Limits from: mysql,pg,solid Server version: MySQL 4.0.15 standard log Optimization: None Hardware:
alter-table: Total time: 96 wallclock secs ( 0.35 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.35 CPU)
ATIS: Total time: 30 wallclock secs (11.14 usr 0.00 sys + 0.00 cusr 0.00 csys = 11.14 CPU)
big-tables: Total time: 31 wallclock secs (20.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 20.83 CPU)
connect: Total time: 140 wallclock secs (75.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 75.89 CPU)
create: Total time: 109 wallclock secs (10.24 usr 0.00 sys + 0.00 cusr 0.00 csys = 10.24 CPU)
insert: Total time: 5215 wallclock secs (689.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 689.67 CPU)
select: Total time: 743 wallclock secs (66.73 usr 0.00 sys + 0.00 cusr 0.00 csys = 66.73 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 19 wallclock secs ( 4.86 usr 0.00 sys + 0.00 cusr 0.00 csys = 4.86 CPU)
All 9 test executed successfully
Totals per operation: Operation seconds usr sys cpu tests alter_table_add 91.00 0.27 0.00 0.27 992 connect 9.00 6.27 0.00 6.27 10000 connect+select_1_row 14.00 8.42 0.00 8.42 10000 count 19.00 0.03 0.00 0.03 100 count_distinct 14.00 0.37 0.00 0.37 1000 count_distinct_big 63.00 9.05 0.00 9.05 120 count_distinct_group 91.00 1.48 0.00 1.48 1000 count_distinct_group_on_key 17.00 0.44 0.00 0.44 1000 count_distinct_group_on_key_parts 92.00 1.23 0.00 1.23 1000 count_distinct_key_prefix 12.00 0.42 0.00 0.42 1000 count_group_on_key_parts 21.00 1.30 0.00 1.30 1000 count_on_key 208.00 15.59 0.00 15.59 50100 create+drop 35.00 3.91 0.00 3.91 10000 create_MANY_tables 20.00 1.38 0.00 1.38 5000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 41.00 3.31 0.00 3.31 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 429.00 0.02 0.00 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 429.00 0.02 0.00 0.02 128 delete_key 13.00 0.94 0.00 0.94 10000 delete_range 10.00 0.00 0.00 0.00 12 drop_index 2.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 8.00 0.68 0.00 0.68 5000 insert 140.00 26.97 0.00 26.97 350768 insert_duplicates 22.00 6.91 0.00 6.91 100000 insert_key 2622.00 22.13 0.00 22.13 100000 insert_many_fields 6.00 0.35 0.00 0.35 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 3.00 0.00 0.00 0.00 1 min_max 11.00 0.03 0.00 0.03 60 min_max_on_key 93.00 21.11 0.00 21.11 85000 order_by_big 62.00 29.34 0.00 29.34 10 order_by_big_key 37.00 30.68 0.00 30.68 10 order_by_big_key2 38.00 30.64 0.00 30.64 10 order_by_big_key_desc 36.00 30.26 0.00 30.26 10 order_by_big_key_diff 57.00 28.18 0.00 28.18 10 order_by_big_key_prefix 35.00 28.87 0.00 28.87 10 order_by_key2_diff 5.00 2.87 0.00 2.87 500 order_by_key_prefix 3.00 1.36 0.00 1.36 500 order_by_range 6.00 1.37 0.00 1.37 500 outer_join 46.00 0.00 0.00 0.00 10 outer_join_found 45.00 0.00 0.00 0.00 10 outer_join_not_found 19.00 0.00 0.00 0.00 500 outer_join_on_key 17.00 0.02 0.00 0.02 10 select_1_row 21.00 11.05 0.00 11.05 100000 select_1_row_cache 18.00 10.17 0.00 10.17 100000 select_2_rows 35.00 13.61 0.00 13.61 100000 select_big 37.00 29.97 0.00 29.97 80 select_big_str 24.00 16.79 0.00 16.79 10000 select_cache 63.00 3.71 0.00 3.71 10000 select_cache2 63.00 3.83 0.00 3.83 10000 select_column+column 19.00 9.58 0.00 9.58 100000 select_diff_key 80.00 0.21 0.00 0.21 500 select_distinct 7.00 2.17 0.00 2.17 800 select_group 22.00 1.61 0.00 1.61 2701 select_group_when_MANY_tables 5.00 0.96 0.00 0.96 5000 select_join 1.00 0.50 0.00 0.50 100 select_key 101.00 60.63 0.00 60.63 200000 select_key2 110.00 61.40 0.00 61.40 200000 select_key2_return_key 96.00 53.23 0.00 53.23 200000 select_key2_return_prim 106.00 57.69 0.00 57.69 200000 select_key_prefix 106.00 61.47 0.00 61.47 200000 select_key_prefix_join 9.00 5.17 0.00 5.17 100 select_key_return_key 100.00 55.92 0.00 55.92 200000 select_many_fields 25.00 20.48 0.00 20.48 2000 select_range 68.00 11.03 0.00 11.03 410 select_range_key2 14.00 6.46 0.00 6.46 25010 select_range_prefix 14.00 6.36 0.00 6.36 25010 select_simple_join 2.00 0.76 0.00 0.76 500 update_big 71.00 0.00 0.00 0.00 10 update_of_key 156.00 6.73 0.00 6.73 50000 update_of_key_big 20.00 0.08 0.00 0.08 501 update_of_primary_key_many_keys 259.00 0.04 0.00 0.04 256 update_with_key 141.00 27.29 0.00 27.29 300000 update_with_key_prefix 28.00 10.27 0.00 10.27 100000 wisc_benchmark 4.00 2.30 0.00 2.30 114 TOTALS 6770.00 867.69 0.00 867.69 2900541
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
