English
RUN-mysql_fast-Linux_2.2.14_my_SMP_i686-cmp-mysql,pg
上传用户：tsgydb
上传日期：2007-04-14
资源大小：10674k
文件大小：5k
源码类别：
MySQL数据库
开发平台：
Visual C++
- Benchmark DBD suite: 2.9
- Date of test: 2000-08-17 20:19:45
- Running tests on: Linux 2.2.14-my-SMP i686
- Arguments: --fast
- Comments: Intel Xeon, 2x550 Mhz, 1G ram, key_buffer=16M
- Limits from: mysql,pg
- Server version: MySQL 3.23.22 beta
- ATIS: Total time: 42 wallclock secs ( 7.93 usr 3.64 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- alter-table: Total time: 260 wallclock secs ( 0.26 usr 0.13 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- big-tables: Total time: 31 wallclock secs ( 8.32 usr 6.89 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- connect: Total time: 54 wallclock secs (26.60 usr 10.48 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- create: Total time: 122 wallclock secs ( 8.51 usr 3.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- insert: Total time: 1332 wallclock secs (254.96 usr 103.83 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- select: Total time: 1696 wallclock secs (113.17 usr 64.93 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- wisconsin: Total time: 6 wallclock secs ( 1.67 usr 0.73 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- All 8 test executed successfully
- Totals per operation:
- Operation seconds usr sys cpu tests
- alter_table_add 252.00 0.20 0.10 0.00 992
- connect 11.00 6.50 1.98 0.00 10000
- connect+select_1_row 14.00 7.49 2.28 0.00 10000
- connect+select_simple 12.00 7.41 2.24 0.00 10000
- count 46.00 0.02 0.00 0.00 100
- count_distinct 124.00 0.57 0.12 0.00 1000
- count_distinct_big 629.00 70.62 55.60 0.00 1020
- count_distinct_group 77.00 1.14 0.31 0.00 1000
- count_distinct_group_on_key 65.00 0.35 0.14 0.00 1000
- count_distinct_group_on_key_parts 77.00 1.07 0.35 0.00 1000
- count_group_on_key_parts 61.00 1.03 0.31 0.00 1000
- count_on_key 573.00 16.47 3.19 0.00 50100
- create+drop 26.00 2.17 1.03 0.00 10000
- create_MANY_tables 35.00 1.84 0.58 0.00 10000
- create_index 4.00 0.00 0.00 0.00 8
- create_key+drop 40.00 3.68 0.86 0.00 10000
- create_table 1.00 0.01 0.00 0.00 31
- delete_big 18.00 0.00 0.00 0.00 13
- delete_big_many_keys 1.00 0.00 0.00 0.00 2
- delete_key 3.00 0.44 0.38 0.00 10000
- drop_index 4.00 0.00 0.00 0.00 8
- drop_table 0.00 0.00 0.00 0.00 28
- drop_table_when_MANY_tables 15.00 0.10 0.01 0.00 10000
- insert 87.00 18.67 12.96 0.00 350768
- insert_duplicates 82.00 17.82 12.50 0.00 300000
- insert_key 91.00 8.12 4.12 0.00 100000
- insert_many_fields 9.00 0.46 0.10 0.00 2000
- min_max 32.00 0.05 0.00 0.00 60
- min_max_on_key 210.00 24.91 5.21 0.00 85000
- order_by 48.00 20.14 16.88 0.00 10
- order_by_key 31.00 20.12 10.64 0.00 10
- select_1_row 2.00 0.54 0.83 0.00 10000
- select_2_rows 4.00 0.55 0.65 0.00 10000
- select_big 37.00 23.14 12.09 0.00 10080
- select_column+column 3.00 0.51 0.73 0.00 10000
- select_diff_key 205.00 0.19 0.03 0.00 500
- select_distinct 11.00 1.74 0.60 0.00 800
- select_group 71.00 1.38 0.66 0.00 2711
- select_group_when_MANY_tables 6.00 0.71 0.53 0.00 10000
- select_join 16.00 4.21 2.17 0.00 200
- select_key 125.00 67.84 14.15 0.00 200000
- select_key_prefix 127.00 65.92 14.67 0.00 200000
- select_many_fields 22.00 7.85 6.78 0.00 2000
- select_range 20.00 7.27 1.62 0.00 25420
- select_range_prefix 19.00 6.09 1.82 0.00 25010
- select_simple 2.00 0.47 0.54 0.00 10000
- select_simple_join 1.00 0.64 0.24 0.00 500
- update_big 65.00 0.00 0.00 0.00 500
- update_of_key 77.00 2.84 2.32 0.00 756
- update_of_key_big 33.00 0.02 0.01 0.00 501
- update_with_key 97.00 14.16 13.03 0.00 100000
- wisc_benchmark 4.00 1.66 0.72 0.00 114
- TOTALS 3625.00 439.13 206.08 0.00 1594242
