RUN-mysql_fast-Linux_2.2.10_i686-cmp-msql,mysql
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:3k
源码类别:
MySQL数据库
开发平台:
Visual C++
- Benchmark DBD suite: 2.4
- Date of test: 1999-09-24 9:07:48
- Running tests on: Linux 2.2.10 i686
- Arguments: --force --fast
- Comments:
- Limits from: msql,mysql
- Server version: MySQL 3.23.3 alpha
- ATIS: Total time: 41 wallclock secs (14.97 usr 2.26 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- alter-table: Total time: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- big-tables: Total time: 63 wallclock secs (32.15 usr 5.59 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- connect: Total time: 77 wallclock secs (42.05 usr 9.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- create: Total time: 9 wallclock secs ( 1.85 usr 0.18 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- insert: Estimated total time: 2211 wallclock secs (751.12 usr 86.95 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- select: Total time: 17 wallclock secs ( 5.57 usr 0.80 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- wisconsin: Total time: 7 wallclock secs ( 2.43 usr 0.29 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
- connect 20 14.35 1.53 0.00 10000
- connect+select_1_row 24 15.08 2.21 0.00 10000
- create+drop 2 0.55 0.04 0.00 1000
- create_key+drop 2 0.62 0.06 0.00 1000
- create_table 4 0.40 0.03 0.00 1031
- delete_big 19 0.00 0.00 0.00 13
- delete_big_many_keys 8 0.00 0.00 0.00 2
- delete_key 0 0.06 0.01 0.00 500
- drop_table 0 0.02 0.00 0.00 1028
- insert 119 43.27 6.98 0.00 350768
- insert_duplicates 15 5.68 1.77 0.00 300000
- insert_key 68 13.88 2.39 0.00 100000
- insert_many_fields 19 7.12 0.65 0.00 20000
- order_by 86 47.40 7.63 0.00 10
- order_by_key 69 47.67 7.32 0.00 10
- select 1 0.26 0.05 0.00 1000
- select_1_row 4 1.14 0.33 0.00 10000
- select_2_rows 4 1.24 0.37 0.00 10000
- select_big 95 58.19 12.13 0.00 10080
- select_diff_key 305 0.62 0.03 0.00 500
- select_distinct 15 3.57 0.55 0.00 700
- select_join 22 9.94 1.56 0.00 200
- select_key 262 162.27 10.69 0.00 200000
- select_key_prefix 265 165.34 9.78 0.00 200000
- select_many_fields 44 25.02 4.94 0.00 20000
- select_range 41 17.25 1.56 0.00 25400
- select_range_prefix 30 14.63 1.11 0.00 25000
- select_simple_join 3 1.40 0.15 0.00 500
- update_big 34 0.00 0.00 0.00 500
- update_of_key 694 152.73 23.25 0.00 600256 +
- update_with_key 147 37.92 7.66 0.00 100000
- wisc_benchmark 4 2.43 0.29 0.00 74
- TOTALS 2425 850.05 105.07 0.00 1999572 +