blob: 91a519b208c8651dfe904096ad632fe016d32656 (
plain)
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
56
57
58
59
60
|
Benchmark DBD suit: 2.0
Date of test: 1999-03-08 10:55:47
Running tests on: Windows NT Version 4.0
Arguments: --force
Comments:
Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase
Server version: MySQL 3.22.16 gamma
ATIS: Total time: 71 wallclock secs (16.88 usr + 8.22 sys = 25.11 CPU)
alter-table: Total time: 5 wallclock secs ( 0.19 usr + 0.17 sys = 0.36 CPU)
big-tables: Total time: 74 wallclock secs (23.40 usr + 8.04 sys = 31.45 CPU)
connect: Total time: 155 wallclock secs (45.74 usr + 33.56 sys = 79.29 CPU)
create: Total time: 72 wallclock secs ( 2.05 usr + 0.97 sys = 3.02 CPU)
insert: Total time: 5368 wallclock secs (568.77 usr + 216.27 sys = 785.04 CPU)
select: Estimated total time: 899 wallclock secs (90.43 usr + 24.97 sys = 115.41 CPU)
wisconsin: Total time: 38 wallclock secs ( 7.83 usr + 5.25 sys = 13.08 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 1 0.01 0.00 0.01 8
connect 56 16.91 13.01 29.92 10000
connect+select 64 18.76 14.96 33.72 10000
count 54 0.06 0.01 0.07 100
count_key 665 36.67 9.66 46.33 50000 +
count_on_key 31 0.08 0.04 0.12 100
create+drop 14 0.40 0.19 0.59 1000
create_index 2 0.00 0.00 0.00 8
create_key+drop 18 0.85 0.33 1.18 1000
create_table 23 0.47 0.19 0.66 1031
delete_big 678 0.01 0.00 0.01 15
delete_key 1 0.10 0.08 0.18 500
drop_index 1 0.00 0.00 0.00 8
drop_table 3 0.10 0.18 0.28 1028
insert 381 67.34 48.27 115.61 350768
insert_duplicates 68 16.34 13.36 29.70 300000
insert_key 2906 27.77 14.64 42.41 100000
insert_many_fields 30 7.32 2.84 10.16 20000
min_max 26 0.06 0.01 0.07 60
min_max_on_key 220 51.97 14.10 66.07 73000
order_by 100 40.72 19.97 60.69 10
order_by_key 73 40.79 20.33 61.12 10
select 21 3.50 3.78 7.30 20000
select_big 88 47.93 21.83 69.76 10080
select_distinct 17 3.22 1.51 4.74 800
select_group 53 2.23 0.70 2.93 3191
select_join 31 8.80 4.19 12.99 200
select_key 367 157.27 40.25 197.51 200000
select_key_prefix 375 158.15 38.91 197.05 200000
select_many_fields 44 16.07 5.19 21.28 20000
select_range 40 13.94 3.73 17.68 25400
select_range_prefix 34 12.64 3.04 15.68 25000
select_simple_join 3 1.23 0.50 1.73 500
update_key 0 0.09 0.05 0.14 500
update_key_big 26 0.10 0.06 0.16 501
update_of_key 157 0.04 0.04 0.08 256
wisc_benchmark 8 3.07 1.29 4.37 114
TOTALS 6679 755.01 297.24 1052.30 1425188 +
|
