Here are the insert results though:
MyISAM:
insert: Total time: 1437 wallclock secs (432.84 usr 358.12 sys + 0.00 cusr 0.00 csys = 790.96 CPU)
InnoDB:
insert: Total time: 3270 wallclock secs (440.53 usr 361.82 sys + 0.00 cusr 0.00 csys = 802.35 CPU)
- Gabriel
Benchmark DBD suite: 2.14 Date of test: 2003-10-17 11:15:04 Running tests on: Darwin 7.0.0 Power Macintosh Arguments: Comments: Limits from: Server version: MySQL 4.0.15aIMAX G5 debug log Optimization: None Hardware: PowerMac G5 2 x 2GHz , 4GB PC3200 RAM (8x256MB Kingston HyperX), 160GB SATA HD
alter-table: Total time: 69 wallclock secs ( 0.01 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.04 CPU) ATIS: Total time: 27 wallclock secs ( 9.31 usr 9.93 sys + 0.00 cusr 0.00 csys = 19.24 CPU) big-tables: Total time: 37 wallclock secs ( 8.10 usr 20.83 sys + 0.00 cusr 0.00 csys = 28.93 CPU) connect: Total time: 182 wallclock secs (46.25 usr 54.08 sys + 0.00 cusr 0.00 csys = 100.33 CPU) create: Total time: 197 wallclock secs ( 5.71 usr 2.65 sys + 0.00 cusr 0.00 csys = 8.36 CPU) insert: Total time: 3270 wallclock secs (440.53 usr 361.82 sys + 0.00 cusr 0.00 csys = 802.35 CPU) select: Total time: 222 wallclock secs (44.41 usr 32.55 sys + 0.00 cusr 0.00 csys = 76.96 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 28 wallclock secs ( 2.99 usr 2.73 sys + 0.00 cusr 0.00 csys = 5.72 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 19.00 0.00 0.00 0.00 20 alter_table_drop 17.00 0.01 0.00 0.01 20 connect 10.00 5.43 1.69 7.12 10000 connect+select_1_row 15.00 6.52 2.57 9.09 10000 connect+select_simple 12.00 6.18 1.87 8.05 10000 count 39.00 0.06 0.00 0.06 100 count_distinct 1.00 0.19 0.03 0.22 1000 count_distinct_big 26.00 9.11 10.75 19.86 120 count_distinct_group 2.00 1.06 0.60 1.66 1000 count_distinct_group_on_key 0.00 0.23 0.07 0.30 1000 count_distinct_group_on_key_parts 2.00 1.07 0.62 1.69 1000 count_distinct_key_prefix 0.00 0.14 0.10 0.24 1000 count_group_on_key_parts 2.00 1.25 0.38 1.63 1000 count_on_key 31.00 7.59 2.98 10.57 50100 create+drop 57.00 1.57 0.71 2.28 10000 create_MANY_tables 38.00 1.05 0.47 1.52 10000 create_index 16.00 0.00 0.00 0.00 8 create_key+drop 61.00 1.92 0.56 2.48 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 171.00 0.00 0.01 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 171.00 0.00 0.01 0.01 128 delete_key 5.00 0.24 0.32 0.56 10000 delete_range 25.00 0.00 0.00 0.00 12 drop_index 16.00 0.00 0.00 0.00 8 drop_table 1.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 36.00 0.68 0.38 1.06 10000 insert 271.00 9.92 10.35 20.27 350768 insert_duplicates 18.00 2.30 3.07 5.37 100000 insert_key 371.00 5.26 3.31 8.57 100000 insert_many_fields 7.00 0.29 0.04 0.33 2000 insert_select_1_key 7.00 0.00 0.00 0.00 1 insert_select_2_keys 12.00 0.00 0.00 0.00 1 min_max 12.00 0.00 0.01 0.01 60 min_max_on_key 22.00 12.48 4.77 17.25 85000 multiple_value_insert 19.00 0.29 0.03 0.32 100000 order_by_big 67.00 26.36 33.24 59.60 10 order_by_big_key 66.00 27.64 33.13 60.77 10 order_by_big_key2 65.00 26.27 34.13 60.40 10 order_by_big_key_desc 66.00 27.11 33.51 60.62 10 order_by_big_key_diff 64.00 26.85 32.96 59.81 10 order_by_big_key_prefix 64.00 26.86 32.54 59.40 10 order_by_key2_diff 4.00 2.51 1.50 4.01 500 order_by_key_prefix 3.00 1.29 0.65 1.94 500 order_by_range 7.00 1.45 0.63 2.08 500 outer_join 7.00 0.00 0.01 0.01 10 outer_join_found 7.00 0.00 0.00 0.00 10 outer_join_not_found 4.00 0.00 0.00 0.00 500 outer_join_on_key 4.00 0.01 0.00 0.01 10 select_1_row 28.00 4.49 7.40 11.89 100000 select_1_row_cache 14.00 3.52 6.96 10.48 100000 select_2_rows 30.00 4.80 7.44 12.24 100000 select_big 64.00 26.55 33.86 60.41 80 select_big_str 21.00 4.58 8.71 13.29 10000 select_cache 2.00 1.42 0.50 1.92 10000 select_cache2 129.00 1.81 0.77 2.58 10000 select_column+column 25.00 4.11 5.98 10.09 100000 select_diff_key 174.00 0.15 0.02 0.17 500 select_distinct 4.00 1.71 1.69 3.40 800 select_group 9.00 1.13 0.59 1.72 2911 select_group_when_MANY_tables 5.00 0.49 0.53 1.02 10000 select_join 1.00 0.61 0.56 1.17 100 select_key 73.00 32.89 15.10 47.99 200000 select_key2 83.00 33.51 15.19 48.70 200000 select_key2_return_key 76.00 30.68 11.13 41.81 200000 select_key2_return_prim 78.00 31.47 12.99 44.46 200000 select_key_prefix 87.00 34.26 14.17 48.43 200000 select_key_prefix_join 12.00 4.97 6.11 11.08 100 select_key_return_key 69.00 32.66 12.73 45.39 200000 select_many_fields 30.00 7.81 20.79 28.60 2000 select_range 25.00 9.79 11.31 21.10 410 select_range_key2 6.00 3.50 1.66 5.16 25010 select_range_prefix 6.00 3.64 1.73 5.37 25010 select_simple 13.00 3.29 5.85 9.14 100000 select_simple_cache 12.00 3.33 5.61 8.94 100000 select_simple_join 2.00 0.59 0.64 1.23 500 update_big 73.00 0.00 0.01 0.01 10 update_of_key 62.00 1.77 1.56 3.33 50000 update_of_key_big 87.00 0.04 0.00 0.04 501 update_of_primary_key_many_keys 615.00 0.01 0.01 0.02 256 update_with_key 292.00 9.76 9.14 18.90 300000 update_with_key_prefix 22.00 3.71 3.29 7.00 100000 wisc_benchmark 5.00 2.12 1.90 4.02 114 TOTALS 4174.00 546.36 473.93 1020.29 3224799
Benchmark DBD suite: 2.14 Date of test: 2003-10-17 10:31:14 Running tests on: Darwin 7.0.0 Power Macintosh Arguments: Comments: Limits from: Server version: MySQL 4.0.15a G5 debug log Optimization: Large cache allocations. Hardware: PowerMac G5 2 x 2GHz , 4GB PC3200 RAM (8x256MB Kingston HyperX), 160GB SATA HD alter-table: Total time: 11 wallclock secs ( 0.02 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.06 CPU) ATIS: Total time: 21 wallclock secs ( 9.41 usr 9.44 sys + 0.00 cusr 0.00 csys = 18.85 CPU) big-tables: Total time: 34 wallclock secs ( 7.90 usr 20.86 sys + 0.00 cusr 0.00 csys = 28.76 CPU) connect: Total time: 180 wallclock secs (45.56 usr 51.51 sys + 0.00 cusr 0.00 csys = 97.07 CPU) create: Total time: 118 wallclock secs ( 3.87 usr 2.55 sys + 0.00 cusr 0.00 csys = 6.42 CPU) insert: Total time: 1437 wallclock secs (432.84 usr 358.12 sys + 0.00 cusr 0.00 csys = 790.96 CPU) select: Total time: 146 wallclock secs (42.52 usr 33.74 sys + 0.00 cusr 0.00 csys = 76.26 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 12 wallclock secs ( 2.91 usr 2.76 sys + 0.00 cusr 0.00 csys = 5.67 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 3.00 0.00 0.00 0.00 20 alter_table_drop 4.00 0.00 0.01 0.01 20 connect 9.00 5.45 1.70 7.15 10000 connect+select_1_row 14.00 6.41 2.12 8.53 10000 connect+select_simple 12.00 6.02 2.16 8.18 10000 count 23.00 0.01 0.00 0.01 100 count_distinct 0.00 0.15 0.05 0.20 1000 count_distinct_big 25.00 9.07 10.81 19.88 120 count_distinct_group 2.00 1.20 0.43 1.63 1000 count_distinct_group_on_key 1.00 0.20 0.12 0.32 1000 count_distinct_group_on_key_parts 1.00 0.99 0.63 1.62 1000 count_distinct_key_prefix 0.00 0.14 0.07 0.21 1000 count_group_on_key_parts 2.00 0.90 0.67 1.57 1000 count_on_key 33.00 6.90 3.07 9.97 50100 create+drop 24.00 1.03 0.55 1.58 10000 create_MANY_tables 36.00 0.76 0.39 1.15 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 27.00 1.47 0.73 2.20 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 30.00 0.02 0.00 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 30.00 0.02 0.00 0.02 128 delete_key 2.00 0.24 0.23 0.47 10000 delete_range 6.00 0.00 0.01 0.01 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 11.00 0.23 0.28 0.51 10000 insert 80.00 7.77 9.70 17.47 350768 insert_duplicates 15.00 2.25 3.17 5.42 100000 insert_key 71.00 4.54 2.83 7.37 100000 insert_many_fields 3.00 0.28 0.04 0.32 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 7.00 0.01 0.02 0.03 60 min_max_on_key 20.00 11.69 5.12 16.81 85000 multiple_value_insert 2.00 0.26 0.03 0.29 100000 order_by_big 68.00 27.07 33.21 60.28 10 order_by_big_key 65.00 27.20 32.43 59.63 10 order_by_big_key2 64.00 26.40 33.41 59.81 10 order_by_big_key_desc 64.00 26.88 32.83 59.71 10 order_by_big_key_diff 67.00 26.28 33.25 59.53 10 order_by_big_key_prefix 63.00 26.15 33.38 59.53 10 order_by_key2_diff 6.00 2.34 1.31 3.65 500 order_by_key_prefix 3.00 1.24 0.86 2.10 500 order_by_range 6.00 1.27 0.64 1.91 500 outer_join 4.00 0.00 0.00 0.00 10 outer_join_found 5.00 0.01 0.00 0.01 10 outer_join_not_found 3.00 0.00 0.00 0.00 500 outer_join_on_key 3.00 0.01 0.00 0.01 10 select_1_row 26.00 4.66 6.49 11.15 100000 select_1_row_cache 14.00 3.57 6.66 10.23 100000 select_2_rows 37.00 5.00 7.15 12.15 100000 select_big 63.00 26.64 33.14 59.78 80 select_big_str 20.00 4.24 8.67 12.91 10000 select_cache 2.00 1.42 0.68 2.10 10000 select_cache2 60.00 1.84 0.68 2.52 10000 select_column+column 21.00 3.70 5.59 9.29 100000 select_diff_key 87.00 0.13 0.01 0.14 500 select_distinct 3.00 1.82 1.43 3.25 800 select_group 4.00 1.17 0.54 1.71 2911 select_group_when_MANY_tables 20.00 0.38 0.60 0.98 10000 select_join 1.00 0.60 0.63 1.23 100 select_key 72.00 33.25 14.81 48.06 200000 select_key2 74.00 33.84 14.60 48.44 200000 select_key2_return_key 64.00 31.04 11.40 42.44 200000 select_key2_return_prim 69.00 31.78 12.52 44.30 200000 select_key_prefix 80.00 34.58 14.35 48.93 200000 select_key_prefix_join 12.00 4.99 5.83 10.82 100 select_key_return_key 68.00 32.10 12.72 44.82 200000 select_many_fields 31.00 7.62 20.82 28.44 2000 select_range 25.00 9.81 11.86 21.67 410 select_range_key2 7.00 3.58 1.88 5.46 25010 select_range_prefix 5.00 3.55 1.79 5.34 25010 select_simple 12.00 3.33 5.37 8.70 100000 select_simple_cache 13.00 3.18 5.60 8.78 100000 select_simple_join 1.00 0.54 0.66 1.20 500 update_big 24.00 0.00 0.00 0.00 10 update_of_key 26.00 1.20 1.34 2.54 50000 update_of_key_big 11.00 0.01 0.03 0.04 501 update_of_primary_key_many_keys 12.00 0.00 0.01 0.01 256 update_with_key 50.00 5.56 9.05 14.61 300000 update_with_key_prefix 19.00 3.97 3.47 7.44 100000 wisc_benchmark 4.00 2.11 1.85 3.96 114 TOTALS 1962.00 534.07 468.49 1002.56 3224799
On Wednesday, November 5, 2003, at 01:57 PM, Jan Pieter Kunst wrote:
Hi everyone,
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.
The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is more than twice as slow. Below are the benchmark
results for both machines, and the my.cnf I used.
I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?
Thanks in advance for any insight, Jan Pieter Kunst
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
