RUN-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:3k
源码类别:
MySQL数据库
开发平台:
Visual C++
- Benchmark DBD suite: 2.0b
- Date of test: 1999-03-07 22:58:12
- Running tests on: Linux 2.0.36 i686
- Arguments: --force
- Comments:
- Limits from: mysql,pg,solid
- Server version: MySQL 3.22.18
- ATIS: Total time: 49 wallclock secs (10.38 usr 4.19 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- alter-table: Total time: 23 wallclock secs ( 0.14 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- big-tables: Total time: 15 wallclock secs ( 4.57 usr 2.58 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- connect: Total time: 53 wallclock secs (25.85 usr 5.76 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- create: Total time: 15 wallclock secs ( 1.48 usr 0.25 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- insert: Total time: 1389 wallclock secs (376.47 usr 81.30 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- select: Total time: 630 wallclock secs (42.58 usr 5.63 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- wisconsin: Total time: 20 wallclock secs ( 4.61 usr 1.48 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- All 8 test executed successfully
- Totals per operation:
- Operation seconds usr sys cpu tests
- alter_table_add 21 0.08 0.01 0.00 293
- connect 15 8.66 1.63 0.00 10000
- connect+select 19 9.61 2.34 0.00 10000
- count 59 0.08 0.01 0.00 100
- count_on_key 640 25.56 3.32 0.00 50100
- create+drop 3 0.39 0.08 0.00 1000
- create_index 1 0.00 0.00 0.00 7
- create_key+drop 2 0.55 0.02 0.00 1000
- create_table 6 0.31 0.05 0.00 1031
- delete_big 67 0.01 0.00 0.00 15
- delete_key 10 0.11 0.02 0.00 500
- drop_index 1 0.00 0.00 0.00 7
- drop_table 0 0.12 0.05 0.00 1028
- insert 162 41.63 9.65 0.00 350768
- insert_duplicates 18 5.06 2.17 0.00 300000
- insert_key 165 12.53 3.21 0.00 100000
- insert_many_fields 4 0.55 0.10 0.00 2000
- min_max 27 0.02 0.00 0.00 60
- min_max_on_key 32 15.90 1.97 0.00 73000
- order_by 73 23.18 12.42 0.00 10
- order_by_key 50 23.37 12.37 0.00 10
- select 8 1.75 0.95 0.00 20000
- select_big 61 29.19 12.82 0.00 10080
- select_distinct 14 2.23 0.74 0.00 800
- select_group 41 1.57 0.25 0.00 3101
- select_join 22 4.87 2.75 0.00 200
- select_key 230 115.25 13.94 0.00 200000
- select_key_prefix 242 115.60 13.94 0.00 200000
- select_many_fields 11 4.02 2.48 0.00 2000
- select_range 29 10.70 1.56 0.00 25420
- select_range_prefix 35 10.03 1.41 0.00 25010
- select_simple_join 2 0.91 0.24 0.00 500
- update_key 4 0.07 0.02 0.00 500
- update_key_big 27 0.06 0.01 0.00 501
- update_of_key 83 0.02 0.00 0.00 256
- wisc_benchmark 6 1.99 0.67 0.00 114
- TOTALS 2190 465.98 101.20 0.00 1389411