English
RUN-pg_fast-Linux_2.4.2_64GB_SMP_i686-cmp-mysql,pg
上传用户：romrleung
上传日期：2022-05-23
资源大小：18897k
文件大小：7k
源码类别：
MySQL数据库
开发平台：
Visual C++
- Benchmark DBD suite: 2.13
- Date of test: 2001-06-12 18:14:29
- Running tests on: Linux 2.4.2-64GB-SMP i686
- Arguments: --fast
- Comments: Intel Xeon, 2x550 Mhz, 512M, pg started with -o -F
- Limits from: mysql,pg
- Server version: PostgreSQL version 7.1.2
- ATIS: Total time: 105 wallclock secs (12.13 usr 1.14 sys + 0.00 cusr 0.00 csys = 13.27 CPU)
- alter-table: Total time: 51 wallclock secs ( 0.63 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.69 CPU)
- big-tables: Total time: 1356 wallclock secs ( 8.41 usr 0.76 sys + 0.00 cusr 0.00 csys = 9.17 CPU)
- connect: Total time: 550 wallclock secs (52.92 usr 14.30 sys + 0.00 cusr 0.00 csys = 67.22 CPU)
- create: Total time: 9195 wallclock secs (31.22 usr 11.10 sys + 0.00 cusr 0.00 csys = 42.32 CPU)
- insert: Estimated total time: 21187 wallclock secs (884.26 usr 225.15 sys + 0.00 cusr 0.00 csys = 1109.40 CPU)
- select: Estimated total time: 12852 wallclock secs (74.09 usr 9.62 sys + 0.00 cusr 0.00 csys = 83.71 CPU)
- wisconsin: Total time: 64 wallclock secs (13.06 usr 3.32 sys + 0.00 cusr 0.00 csys = 16.38 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 48.00 0.32 0.03 0.35 992
- book-keeping 3262.00 0.03 0.00 0.03 25
- connect 140.00 7.94 1.85 9.79 10000
- connect+select_1_row 190.00 10.78 2.23 13.01 10000
- connect+select_simple 155.00 10.57 2.71 13.28 10000
- count 132.00 0.04 0.00 0.04 100
- count_distinct 131.00 0.34 0.05 0.39 1000
- count_distinct_2 213.00 0.38 0.03 0.41 1000
- count_distinct_big 269.00 8.53 0.27 8.80 120
- count_distinct_group 385.00 1.14 0.09 1.23 1000
- count_distinct_group_on_key 209.00 0.35 0.09 0.44 1000
- count_distinct_group_on_key_parts 382.00 1.16 0.06 1.22 1000
- count_distinct_key_prefix 188.00 0.38 0.02 0.40 1000
- count_group_on_key_parts 332.00 1.14 0.03 1.17 1000
- count_on_key 1774.00 14.24 1.80 16.04 50100 +
- create+drop 2924.00 11.10 2.41 13.51 10000
- create_MANY_tables 194.00 6.27 5.72 11.99 5000
- create_index 0.00 0.00 0.00 0.00 8
- create_key+drop 5464.00 11.00 2.30 13.30 10000
- create_table 1.00 0.03 0.00 0.03 31
- delete_all 11.00 0.01 0.01 0.02 12
- delete_all_many_keys 3.00 0.05 0.00 0.05 1
- delete_big 2.00 0.01 0.00 0.01 1
- delete_big_many_keys 3.00 0.05 0.00 0.05 128
- delete_key 11.00 3.02 0.37 3.39 10000
- drop_index 1.00 0.00 0.00 0.00 8
- drop_table 0.00 0.00 0.00 0.00 28
- drop_table_when_MANY_tables 599.00 1.39 0.38 1.77 5000
- insert 359.00 104.39 28.15 132.54 350768
- insert_duplicates 111.00 28.41 9.26 37.67 100000
- insert_key 895.00 45.94 68.46 114.40 100000
- insert_many_fields 525.00 1.01 0.18 1.19 2000
- insert_select_1_key 45.00 0.00 0.00 0.00 1
- insert_select_2_keys 77.00 0.01 0.00 0.01 1
- min_max 58.00 0.01 0.00 0.01 60
- min_max_on_key 9948.00 29.82 5.49 35.30 85000 ++
- order_by_big 147.00 22.48 0.61 23.09 10
- order_by_big_key 150.00 25.91 1.24 27.15 10
- order_by_big_key2 137.00 22.59 0.71 23.30 10
- order_by_big_key_desc 147.00 25.81 1.23 27.04 10
- order_by_big_key_diff 143.00 22.68 0.55 23.23 10
- order_by_big_key_prefix 133.00 22.64 0.62 23.26 10
- order_by_key2_diff 7.00 2.07 0.04 2.11 500
- order_by_key_prefix 3.00 1.48 0.03 1.51 500
- order_by_range 4.00 1.04 0.04 1.08 500
- outer_join 253.00 0.00 0.00 0.00 10
- outer_join_found 243.00 0.00 0.00 0.00 10
- outer_join_not_found 242.00 0.00 0.01 0.01 500
- outer_join_on_key 238.00 0.00 0.00 0.00 10
- select_1_row 6.00 2.65 0.43 3.08 10000
- select_2_rows 7.00 2.81 0.40 3.21 10000
- select_big 56.00 22.70 2.29 24.99 80
- select_big_str 37.00 12.51 5.97 18.48 10000
- select_column+column 8.00 2.90 0.33 3.23 10000
- select_diff_key 1.00 0.21 0.00 0.21 500
- select_distinct 23.00 1.91 0.34 2.25 800
- select_group 318.00 1.54 0.12 1.66 2711
- select_group_when_MANY_tables 14.00 1.46 0.28 1.74 5000
- select_join 4.00 0.59 0.10 0.69 100
- select_key 213.00 67.07 8.38 75.45 200000
- select_key2 192.00 67.06 8.24 75.30 200000
- select_key2_return_key 183.00 63.93 8.32 72.25 200000
- select_key2_return_prim 188.00 64.56 8.71 73.27 200000
- select_key_prefix 192.00 67.39 7.56 74.95 200000
- select_key_prefix_join 12.00 4.47 0.12 4.59 100
- select_key_return_key 208.00 65.98 8.96 74.94 200000
- select_many_fields 823.00 7.36 0.55 7.91 2000
- select_query_cache 2643.00 3.20 0.43 3.63 10000
- select_query_cache2 2642.00 3.26 0.43 3.69 10000
- select_range 481.00 11.87 1.04 12.91 410
- select_range_key2 47.00 6.56 0.67 7.23 25010
- select_range_prefix 48.00 6.63 0.65 7.28 25010
- select_simple 5.00 2.74 0.38 3.12 10000
- select_simple_join 4.00 0.71 0.18 0.89 500
- update_big 3883.00 0.01 0.00 0.01 10
- update_of_key 90.00 14.87 5.98 20.85 50000
- update_of_key_big 647.00 0.12 0.06 0.18 501
- update_of_primary_key_many_keys 835.00 0.10 0.09 0.19 256
- update_with_key 470.00 87.85 41.80 129.65 300000
- update_with_key_prefix 170.00 31.13 15.28 46.41 100000
- wisc_benchmark 18.00 3.58 0.20 3.78 114
- TOTALS 45356.00 1076.29 265.36 1341.64 2551576 +++
