RUN-mysql-win98
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:5k
- Benchmark DBD suite: 2.7
- Date of test: 2000-03-15 1:51:13
- Running tests on: Windows 98 [Version 4.10.1998]
- Arguments:
- Comments: AMD K6, 400mz, 128M, 16M key_cache
- Limits from:
- Server version: MySQL 3.23.13a alpha
- alter-table: Total time: 1855 wallclock secs (1854.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- ATIS: Total time: 144 wallclock secs (143.53 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- big-tables: Total time: 151 wallclock secs (150.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- connect: Total time: 369 wallclock secs (368.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- create: Total time: 5141 wallclock secs (5140.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- insert: Estimated total time: 8358 wallclock secs (8356.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- select: Total time: 1294 wallclock secs (1293.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
- wisconsin: Total time: 63 wallclock secs (62.40 usr 0.00 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 1046 1046.38 0.00 0.00 992
- alter_table_drop 773 772.97 0.00 0.00 496
- connect 52 51.85 0.00 0.00 10000
- connect+select_1_row 72 71.95 0.00 0.00 10000
- connect+select_simple 67 66.90 0.00 0.00 10000
- count 55 54.87 0.00 0.00 100
- count_on_key 640 639.71 0.00 0.00 50100
- create+drop 1433 1433.28 0.00 0.00 10000
- create_MANY_tables 1510 1510.83 0.00 0.00 5000
- create_index 17 16.70 0.00 0.00 8
- create_key+drop 1457 1456.57 0.00 0.00 10000
- create_table 8 7.92 0.00 0.00 31
- delete_big 23 22.25 0.00 0.00 13
- delete_big_many_keys 112 112.11 0.00 0.00 2
- delete_key 0 0.82 0.00 0.00 500
- drop_index 17 16.64 0.00 0.00 8
- drop_table 1 0.06 0.00 0.00 28
- drop_table_when_MANY_tables 160 159.83 0.00 0.00 5000
- insert 510 508.11 0.00 0.00 350768
- insert_duplicates 91 91.06 0.00 0.00 300000
- insert_key 364 363.72 0.00 0.00 100000
- insert_many_fields 25 24.71 0.00 0.00 2000
- min_max 33 32.90 0.00 0.00 60
- min_max_on_key 339 339.56 0.00 0.00 73000
- multiple_value_insert 11 11.64 0.00 0.00 100000
- order_by 249 248.87 0.00 0.00 10
- order_by_key 175 174.66 0.00 0.00 10
- outer_join 146 145.66 0.00 0.00 10
- outer_join_found 144 144.40 0.00 0.00 10
- outer_join_not_found 606 605.55 0.00 0.00 500 +
- outer_join_on_key 63 63.33 0.00 0.00 10
- select_1_row 16 15.99 0.00 0.00 10000
- select_2_rows 19 18.89 0.00 0.00 10000
- select_big 304 306.16 0.00 0.00 10080
- select_diff_key 241 240.63 0.00 0.00 500
- select_distinct 33 33.34 0.00 0.00 800
- select_group 91 91.83 0.00 0.00 2911
- select_group_when_MANY_tables 581 580.46 0.00 0.00 5000
- select_join 51 50.15 0.00 0.00 200
- select_key 540 540.35 0.00 0.00 200000
- select_key_prefix 542 542.23 0.00 0.00 200000
- select_many_fields 124 124.24 0.00 0.00 2000
- select_range 423 423.21 0.00 0.00 25420
- select_range_prefix 66 66.62 0.00 0.00 25010
- select_simple 12 12.20 0.00 0.00 10000
- select_simple_join 7 7.47 0.00 0.00 500
- update_big 84 83.33 0.00 0.00 500
- update_of_key 59 59.21 0.00 0.00 756
- update_of_key_big 38 38.07 0.00 0.00 501
- update_with_key 432 432.20 0.00 0.00 100000
- wisc_benchmark 17 17.08 0.00 0.00 114
- TOTALS 13879 13879.47 0.00 0.00 1642948 +