blob: 01c90de71efbba963da9a208d804e12d8b68eed0 (
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
Benchmark DBD suite: 2.10
Date of test: 2000-12-17 23:35:25
Running tests on: Linux 2.2.14-my-SMP i686
Arguments:
Comments: Intel Xeon, 2x550 Mhz, 1G ram, key_buffer=16M
Limits from:
Server version: MySQL 3.23.29a gamma
ATIS: Total time: 47 wallclock secs ( 9.20 usr 4.15 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
alter-table: Total time: 463 wallclock secs ( 0.39 usr 0.15 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
big-tables: Total time: 32 wallclock secs ( 8.71 usr 6.83 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
connect: Total time: 79 wallclock secs (35.02 usr 18.29 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
create: Total time: 135 wallclock secs ( 9.85 usr 3.27 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
insert: Total time: 2216 wallclock secs (423.12 usr 155.81 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
select: Total time: 1312 wallclock secs (63.58 usr 18.29 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
wisconsin: Total time: 17 wallclock secs ( 3.57 usr 1.80 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
All 8 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 258.00 0.26 0.07 0.00 992
alter_table_drop 196.00 0.07 0.01 0.00 496
connect 13.00 7.93 2.58 0.00 10000
connect+select_1_row 15.00 7.98 3.18 0.00 10000
connect+select_simple 14.00 7.69 3.24 0.00 10000
count 45.00 0.10 0.01 0.00 100
count_distinct 124.00 0.68 0.16 0.00 2000
count_distinct_big 111.00 7.80 5.59 0.00 120
count_distinct_group 74.00 1.26 0.40 0.00 1000
count_distinct_group_on_key 61.00 0.43 0.08 0.00 1000
count_distinct_group_on_key_parts 73.00 1.27 0.42 0.00 1000
count_group_on_key_parts 62.00 1.13 0.43 0.00 1000
count_on_key 514.00 17.86 3.19 0.00 50100
create+drop 36.00 2.52 0.89 0.00 10000
create_MANY_tables 28.00 1.87 0.47 0.00 10000
create_index 4.00 0.00 0.00 0.00 8
create_key+drop 46.00 4.05 0.70 0.00 10000
create_table 0.00 0.00 0.00 0.00 31
delete_all 19.00 0.01 0.00 0.00 12
delete_all_many_keys 181.00 0.02 0.00 0.00 1
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 181.00 0.02 0.00 0.00 128
delete_key 3.00 0.50 0.39 0.00 10000
drop_index 4.00 0.00 0.00 0.00 8
drop_table 0.00 0.00 0.00 0.00 28
drop_table_when_MANY_tables 14.00 0.60 0.60 0.00 10000
insert 134.00 22.42 14.46 0.00 350768
insert_duplicates 24.00 2.86 2.57 0.00 100000
insert_key 172.00 10.70 4.06 0.00 100000
insert_many_fields 9.00 0.39 0.10 0.00 2000
insert_select_1_key 7.00 0.00 0.00 0.00 1
insert_select_2_keys 9.00 0.00 0.00 0.00 1
min_max 30.00 0.03 0.00 0.00 60
min_max_on_key 206.00 27.71 4.96 0.00 85000
multiple_value_insert 9.00 1.92 0.07 0.00 100000
order_by_big 53.00 22.27 16.17 0.00 10
order_by_big_key 33.00 22.36 10.06 0.00 10
order_by_big_key2 33.00 22.83 9.51 0.00 10
order_by_big_key_desc 32.00 22.03 10.36 0.00 10
order_by_big_key_diff 49.00 21.98 16.40 0.00 10
order_by_key 3.00 1.28 0.40 0.00 500
order_by_key2_diff 5.00 1.91 0.83 0.00 500
order_by_range 5.00 1.09 0.51 0.00 500
outer_join 73.00 0.01 0.00 0.00 10
outer_join_found 70.00 0.00 0.00 0.00 10
outer_join_not_found 50.00 0.00 0.01 0.00 500
outer_join_on_key 61.00 0.00 0.00 0.00 10
select_1_row 3.00 0.71 0.67 0.00 10000
select_2_rows 3.00 0.65 0.68 0.00 10000
select_big 58.00 31.42 17.06 0.00 10080
select_column+column 4.00 0.48 0.60 0.00 10000
select_diff_key 184.00 0.36 0.02 0.00 500
select_distinct 12.00 1.64 0.81 0.00 800
select_group 70.00 1.92 0.41 0.00 2911
select_group_when_MANY_tables 11.00 0.81 0.61 0.00 10000
select_join 16.00 4.55 2.23 0.00 200
select_key 126.00 68.62 14.75 0.00 200000
select_key2 134.00 73.78 14.11 0.00 200000
select_key_prefix 136.00 69.37 14.48 0.00 200000
select_many_fields 22.00 8.31 6.73 0.00 2000
select_range 201.00 9.29 3.51 0.00 410
select_range_key2 18.00 6.59 1.71 0.00 25010
select_range_prefix 20.00 6.80 1.51 0.00 25010
select_simple 2.00 0.53 0.51 0.00 10000
select_simple_join 2.00 0.65 0.26 0.00 500
update_big 65.00 0.00 0.00 0.00 10
update_of_key 97.00 3.15 2.09 0.00 50256
update_of_key_big 33.00 0.01 0.02 0.00 501
update_with_key 116.00 15.94 12.19 0.00 300000
wisc_benchmark 4.00 1.92 0.66 0.00 114
TOTALS 4480.00 553.34 208.50 0.00 1946237
|