diff options
Diffstat (limited to 'sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m')
-rw-r--r-- | sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m | 139 |
1 files changed, 85 insertions, 54 deletions
diff --git a/sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m b/sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m index 2543a44ebc5..32aa3f890a3 100644 --- a/sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m +++ b/sql-bench/Results/RUN-mysql-SunOS_5.7_sun4m @@ -1,62 +1,93 @@ -Benchmark DBD suite: 2.0b -Date of test: 1999-03-19 11:16:57 -Running tests on: SunOS 5.7 sun4m -Arguments: -Comments: Sparc sun4m, 40MHz, 196M RAM +Benchmark DBD suite: 2.10 +Date of test: 2000-12-17 17:44:49 +Running tests on: SunOS 5.7 Sparcstation-10, sun4m 2xcpu: TI,TMS390Z55 (mid 8 impl 0x0 ver 0x1 clock 40MHz) +Arguments: -O key_buffer=!6M +Comments: gcc 2.95, 196M memory Limits from: -Server version: MySQL 3.22.20 +Server version: MySQL 3.23.29 gamma -alter-table: Total time: 6026 secs ( 3.39 usr 2.11 sys + 0.00 cusr 0.00 csys = 5.50 cpu) -ATIS: Total time: 1153 secs (147.11 usr 124.50 sys + 0.00 cusr 0.00 csys = 271.61 cpu) -big-tables: Total time: 674 secs (112.16 usr 179.21 sys + 0.00 cusr 0.00 csys = 291.37 cpu) -connect: Total time: 1514 secs (426.83 usr 331.83 sys + 0.00 cusr 0.00 csys = 758.66 cpu) -create: Total time: 377 secs (11.94 usr 6.22 sys + 0.00 cusr 0.00 csys = 18.16 cpu) -insert: Estimated total time: 20234 secs (3468.07 usr 1826.12 sys + 0.00 cusr 0.00 csys = 5294.18 cpu) -select: Estimated total time: 17283 secs (681.00 usr 335.49 sys + 0.00 cusr 0.00 csys = 1016.50 cpu) -wisconsin: Total time: 291 secs (47.32 usr 34.98 sys + 0.00 cusr 0.00 csys = 82.30 cpu) +ATIS: Total time: 459 wallclock secs (104.37 usr 50.19 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +alter-table: Total time: 2599 wallclock secs ( 2.67 usr 1.62 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +big-tables: Total time: 260 wallclock secs (55.55 usr 91.62 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +connect: Total time: 971 wallclock secs (313.99 usr 256.38 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +create: Total time: 4844 wallclock secs (79.86 usr 40.22 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +insert: Estimated total time: 19996 wallclock secs (4017.95 usr 2552.70 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +select: Estimated total time: 9945 wallclock secs (579.92 usr 312.63 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +wisconsin: Total time: 163 wallclock secs (34.49 usr 22.89 sys + 0.00 cusr 0.00 csys = 0.00 CPU) All 8 test executed successfully Tests with estimated time have a + at end of line Totals per operation: Operation seconds usr sys cpu tests -alter_table_add 3419 1.97 0.98 2.95 992 -alter_table_drop 2509 0.68 0.48 1.16 496 -connect 292 88.91 68.44 157.35 10000 -connect+select 363 104.08 83.81 187.89 10000 -count 539 0.53 0.14 0.67 100 -count_on_key 12306 215.39 80.44 295.84 50100 + -create+drop 110 2.56 2.18 4.74 1000 -create_index 47 0.02 0.01 0.03 8 -create_key+drop 116 5.71 1.29 7.00 1000 -create_table 98 2.20 1.07 3.27 1031 -delete_big 2534 0.02 0.02 0.04 15 -delete_key 4 0.43 0.34 0.77 500 -drop_index 47 0.01 0.00 0.01 8 -drop_table 48 0.61 0.77 1.38 1028 -insert 1898 251.51 256.93 508.44 350768 -insert_duplicates 330 64.66 64.80 129.46 300000 -insert_key 2879 151.51 77.43 228.94 100000 -insert_many_fields 203 6.43 2.61 9.04 2000 -min_max 437 0.34 0.09 0.43 60 -min_max_on_key 2306 286.71 107.71 394.42 73000 + -multiple_value_inser 128 16.22 0.49 16.71 100000 -order_by 1373 367.25 247.43 614.68 10 + -order_by_key 932 400.17 269.81 669.99 10 + -select 111 15.93 28.54 44.47 20000 -select_big 1298 507.77 332.35 840.12 10080 -select_distinct 292 28.26 22.92 51.18 800 -select_group 1508 22.22 14.17 36.39 3811 -select_join 572 81.23 73.44 154.67 200 -select_key 2290 906.93 309.98 1216.91 200000 + -select_key_prefix 2353 783.46 293.15 1076.61 200000 + -select_many_fields 469 105.58 176.57 282.15 2000 -select_range 3599 259.81 172.56 432.37 25420 + -select_range_prefix 401 81.95 32.65 114.60 25010 -select_simple 362 95.62 92.74 188.36 20000 -select_simple_join 37 9.62 7.92 17.54 500 -update_key 2 0.34 0.33 0.67 500 -update_key_big 380 0.33 0.25 0.58 501 -update_of_key 835 0.30 0.30 0.60 256 -wisc_benchmark 110 29.24 14.59 43.83 114 -TOTALS 47537 4896.51 2839.73 7736.26 1511318 +++++++ +alter_table_add 1482.00 1.50 0.71 0.00 992 +alter_table_drop 1066.00 0.71 0.32 0.00 496 +connect 175.00 69.09 50.36 0.00 10000 +connect+select_1_row 203.00 72.78 60.73 0.00 10000 +connect+select_simple 193.00 72.11 59.87 0.00 10000 +count 191.00 0.34 0.15 0.00 100 +count_distinct 808.00 6.35 2.11 0.00 2000 + +count_distinct_big 1174.00 93.21 74.14 0.00 120 + +count_distinct_group 1391.00 12.41 7.94 0.00 1000 + +count_distinct_group_on_key 373.00 3.78 1.54 0.00 1000 +count_distinct_group_on_key_parts 1394.00 12.62 7.80 0.00 1000 + +count_group_on_key_parts 303.00 12.11 7.43 0.00 1000 +count_on_key 2970.00 132.99 51.78 0.00 50100 + +create+drop 995.00 21.72 10.16 0.00 10000 +create_MANY_tables 2078.00 15.85 6.26 0.00 10000 +create_index 24.00 0.00 0.00 0.00 8 +create_key+drop 995.00 29.17 10.77 0.00 10000 +create_table 3.00 0.03 0.03 0.00 31 +delete_all 129.00 0.01 0.01 0.00 12 +delete_all_many_keys 1460.00 0.13 0.15 0.00 1 +delete_big 3.00 0.00 0.01 0.00 1 +delete_big_many_keys 1460.00 0.13 0.15 0.00 128 +delete_key 39.00 5.98 5.60 0.00 10000 +drop_index 24.00 0.00 0.01 0.00 8 +drop_table 1.00 0.03 0.02 0.00 28 +drop_table_when_MANY_tables 599.00 6.29 5.66 0.00 10000 +insert 1271.00 220.44 192.82 0.00 350768 +insert_duplicates 299.00 57.52 54.81 0.00 100000 +insert_key 1988.00 94.64 58.58 0.00 100000 +insert_many_fields 66.00 3.48 1.07 0.00 2000 +insert_select_1_key 44.00 0.00 0.00 0.00 1 +insert_select_2_keys 53.00 0.00 0.00 0.00 1 +min_max 144.00 0.16 0.05 0.00 60 +min_max_on_key 1384.00 221.90 88.70 0.00 85000 + +multiple_value_insert 55.00 8.95 0.40 0.00 100000 +order_by_big 677.00 251.22 227.57 0.00 10 + +order_by_big_key 448.00 251.08 195.23 0.00 10 +order_by_big_key2 445.00 248.50 195.16 0.00 10 +order_by_big_key_desc 453.00 253.91 197.69 0.00 10 +order_by_big_key_diff 648.00 250.20 227.39 0.00 10 +order_by_key 39.00 12.41 8.09 0.00 500 +order_by_key2_diff 76.00 22.75 15.86 0.00 500 +order_by_range 58.00 12.03 8.80 0.00 500 +outer_join 757.00 0.05 0.02 0.00 10 +outer_join_found 724.00 0.00 0.06 0.00 10 +outer_join_not_found 423.00 0.04 0.01 0.00 500 +outer_join_on_key 359.00 0.04 0.00 0.00 10 +select_1_row 25.00 4.18 7.73 0.00 10000 +select_2_rows 30.00 3.36 8.73 0.00 10000 +select_big 758.00 341.83 252.58 0.00 10080 +select_column+column 30.00 4.21 7.61 0.00 10000 +select_diff_key 1048.00 2.16 0.57 0.00 500 + +select_distinct 127.00 20.08 8.51 0.00 800 +select_group 416.00 15.07 6.09 0.00 2911 +select_group_when_MANY_tables 177.00 6.82 7.37 0.00 10000 +select_join 137.00 56.58 27.51 0.00 200 +select_key 1186.00 585.97 241.24 0.00 200000 + +select_key2 1248.00 578.67 246.27 0.00 200000 + +select_key_prefix 1258.00 576.44 251.41 0.00 200000 + +select_many_fields 193.00 52.02 90.54 0.00 2000 +select_range 1318.00 116.36 78.78 0.00 410 + +select_range_key2 177.00 55.95 26.70 0.00 25010 +select_range_prefix 181.00 55.31 26.09 0.00 25010 +select_simple 19.00 4.00 6.52 0.00 10000 +select_simple_join 21.00 7.16 3.20 0.00 500 +update_big 384.00 0.01 0.00 0.00 10 +update_of_key 624.00 33.71 29.06 0.00 50256 +update_of_key_big 209.00 0.30 0.33 0.00 501 +update_with_key 1136.00 171.26 157.65 0.00 300000 +wisc_benchmark 42.00 17.93 7.18 0.00 114 +TOTALS 40688.00 5188.04 3327.69 0.00 1946237 ++++++++++++ |