1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
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 +
|