Skip to content

Instantly share code, notes, and snippets.

@uggedal

uggedal/stormondemand.bench.txt

Created December 22, 2009 16:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save uggedal/261848 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save uggedal/261848 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stormondemand.bench.txt
###########################################################
# sysinfo
###########################################################
# uname -nrmo
stormondemand.test 2.6.18-128.1.14.el5 x86_64 GNU/Linux
# grep "MemTotal" /proc/meminfo
MemTotal: 1758232 kB
# grep -m 4 -e "model name" -e "MHz" -e "cache size" -e "bogomips" /proc/cpuinfo
model name : Intel(R) Core(TM)2 Quad CPU Q9400 @ 2.66GHz
cpu MHz : 2663.211
cache size : 3072 KB
bogomips : 5329.81
# grep "processor" /proc/cpuinfo | wc -l
1
###########################################################
# unixbench single
###########################################################
Benchmark Run: Tue Dec 22 2009 16:26:14 - 16:52:16
1 CPU in system; running 1 parallel copy of tests
Dhrystone 2 using register variables 20343404.6 lps (10.0 s, 7 samples)
Double-Precision Whetstone 3165.9 MWIPS (10.0 s, 7 samples)
Execl Throughput 1237.1 lps (30.0 s, 2 samples)
File Copy 1024 bufsize 2000 maxblocks 561305.6 KBps (30.0 s, 2 samples)
File Copy 256 bufsize 500 maxblocks 248877.8 KBps (30.0 s, 2 samples)
File Copy 4096 bufsize 8000 maxblocks 1047692.5 KBps (30.0 s, 2 samples)
Pipe Throughput 1492283.4 lps (10.0 s, 7 samples)
Process Creation 2724.4 lps (30.0 s, 2 samples)
Shell Scripts (1 concurrent) 2130.0 lpm (60.0 s, 2 samples)
Shell Scripts (8 concurrent) 294.8 lpm (60.1 s, 2 samples)
System Call Overhead 2418246.3 lps (10.0 s, 7 samples)
System Benchmarks Index Values BASELINE RESULT INDEX
Dhrystone 2 using register variables 116700.0 20343404.6 1743.2
Double-Precision Whetstone 55.0 3165.9 575.6
Execl Throughput 43.0 1237.1 287.7
File Copy 1024 bufsize 2000 maxblocks 3960.0 561305.6 1417.4
File Copy 256 bufsize 500 maxblocks 1655.0 248877.8 1503.8
File Copy 4096 bufsize 8000 maxblocks 5800.0 1047692.5 1806.4
Pipe Throughput 12440.0 1492283.4 1199.6
Process Creation 126.0 2724.4 216.2
Shell Scripts (1 concurrent) 42.4 2130.0 502.4
Shell Scripts (8 concurrent) 6.0 294.8 491.4
System Call Overhead 15000.0 2418246.3 1612.2
========
System Benchmarks Index Score 821.3
###########################################################
# unixbench multiple
###########################################################
Benchmark Run: Tue Dec 22 2009 16:52:16 - 17:25:02
1 CPU in system; running 4 parallel copies of tests
Dhrystone 2 using register variables 20521762.0 lps (10.2 s, 7 samples)
Double-Precision Whetstone 12652.4 MWIPS (10.0 s, 7 samples)
Execl Throughput 1230.0 lps (29.9 s, 2 samples)
File Copy 1024 bufsize 2000 maxblocks 624833.0 KBps (30.0 s, 2 samples)
File Copy 256 bufsize 500 maxblocks 249673.4 KBps (30.0 s, 2 samples)
File Copy 4096 bufsize 8000 maxblocks 1012416.2 KBps (30.0 s, 2 samples)
Pipe Throughput 1498790.1 lps (10.2 s, 7 samples)
Process Creation 2691.3 lps (30.1 s, 2 samples)
Shell Scripts (1 concurrent) 2092.9 lpm (60.1 s, 2 samples)
Shell Scripts (8 concurrent) 289.5 lpm (60.3 s, 2 samples)
System Call Overhead 2446329.7 lps (10.2 s, 7 samples)
System Benchmarks Index Values BASELINE RESULT INDEX
Dhrystone 2 using register variables 116700.0 20521762.0 1758.5
Double-Precision Whetstone 55.0 12652.4 2300.4
Execl Throughput 43.0 1230.0 286.0
File Copy 1024 bufsize 2000 maxblocks 3960.0 624833.0 1577.9
File Copy 256 bufsize 500 maxblocks 1655.0 249673.4 1508.6
File Copy 4096 bufsize 8000 maxblocks 5800.0 1012416.2 1745.5
Pipe Throughput 12440.0 1498790.1 1204.8
Process Creation 126.0 2691.3 213.6
Shell Scripts (1 concurrent) 42.4 2092.9 493.6
Shell Scripts (8 concurrent) 6.0 289.5 482.6
System Call Overhead 15000.0 2446329.7 1630.9
========
System Benchmarks Index Score 935.6
###########################################################
# sqlbench on postgresql
###########################################################
Benchmark DBD suite: 2.15
Date of test: 2009-12-22 16:05:07
Running tests on: Linux 2.6.18-128.1.14.el5 x86_64
Arguments: --silent
Comments:
Limits from:
Server version: PostgreSQL version ???
Optimization: None
Hardware:
alter-table: Total time: 2 wallclock secs ( 0.04 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.05 CPU)
ATIS: Failed (output/ATIS-Pg-Linux_2.6.18_128.1.14.el5_x86_64)
big-tables: Total time: 25 wallclock secs ( 3.85 usr 0.08 sys + 0.00 cusr 0.00 csys = 3.93 CPU)
connect: Total time: 302 wallclock secs (23.36 usr 8.87 sys + 0.00 cusr 0.00 csys = 32.23 CPU)
create: Total time: 206 wallclock secs ( 1.63 usr 0.45 sys + 0.00 cusr 0.00 csys = 2.08 CPU)
insert: Total time: 178 wallclock secs (35.66 usr 2.72 sys + 0.00 cusr 0.00 csys = 38.38 CPU)
select: Total time: 188 wallclock secs (25.05 usr 1.87 sys + 0.00 cusr 0.00 csys = 26.92 CPU)
transactions: Total time: 34 wallclock secs ( 1.39 usr 0.78 sys + 0.00 cusr 0.00 csys = 2.17 CPU)
wisconsin: Total time: 31 wallclock secs ( 3.16 usr 0.17 sys + 0.00 cusr 0.00 csys = 3.33 CPU)
Of 9 tests, 1 tests didn't work
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 1.00 0.04 0.00 0.04 992
connect 72.00 3.46 0.74 4.20 10000
connect+select_1_row 96.00 4.03 1.04 5.07 10000
connect+select_simple 79.00 3.79 1.04 4.83 10000
count 1.00 0.01 0.00 0.01 100
count_distinct 3.00 0.09 0.01 0.10 1000
count_distinct_2 8.00 0.10 0.01 0.11 1000
count_distinct_big 12.00 5.11 0.07 5.18 120
count_distinct_group 9.00 0.62 0.01 0.63 1000
count_distinct_group_on_key 6.00 0.11 0.01 0.12 1000
count_distinct_group_on_key_parts 8.00 0.61 0.02 0.63 1000
count_distinct_key_prefix 7.00 0.10 0.02 0.12 1000
count_group_on_key_parts 3.00 0.58 0.00 0.58 1000
count_on_key 57.00 3.66 0.54 4.20 50100
create+drop 11.00 0.20 0.05 0.25 1000
create_MANY_tables 6.00 0.07 0.01 0.08 1000
create_index 0.00 0.00 0.00 0.00 8
create_key+drop 186.00 1.27 0.36 1.63 1000
create_table 0.00 0.00 0.00 0.00 3
delete_all_many_keys 0.00 0.00 0.00 0.00 1
delete_autocommit 9.00 0.02 0.03 0.05 10000
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 0.00 0.00 0.00 0.00 128
delete_commit 1.00 0.19 0.11 0.30 10000
delete_key 1.00 0.00 0.01 0.01 1000
delete_range 0.00 0.00 0.00 0.00 12
delete_rollback 1.00 0.19 0.09 0.28 100
drop_index 0.00 0.00 0.00 0.00 8
drop_table_when_MANY_tables 3.00 0.07 0.01 0.08 1000
insert 63.00 0.23 0.25 0.48 71000
insert_autocommit 9.00 0.06 0.08 0.14 10000
insert_commit 1.00 0.23 0.09 0.32 10000
insert_duplicates 1.00 0.27 0.14 0.41 10000
insert_key 10.00 0.08 0.05 0.13 10000
insert_many_fields 9.00 0.12 0.03 0.15 2000
insert_rollback 1.00 0.26 0.11 0.37 100
insert_select_1_key 0.00 0.00 0.00 0.00 1
insert_select_2_keys 0.00 0.00 0.00 0.00 1
min_max 0.00 0.01 0.00 0.01 60
min_max_on_key 17.00 5.63 0.88 6.51 85000
once_prepared_select 1.00 0.36 0.08 0.44 10000
order_by_big 1.00 1.19 0.03 1.22 10
order_by_big_key 2.00 1.54 0.02 1.56 10
order_by_big_key2 1.00 1.19 0.03 1.22 10
order_by_big_key_desc 2.00 1.53 0.02 1.55 10
order_by_big_key_diff 2.00 1.20 0.00 1.20 10
order_by_big_key_prefix 2.00 1.20 0.02 1.22 10
order_by_key2_diff 1.00 1.04 0.00 1.04 500
order_by_key_prefix 1.00 0.56 0.01 0.57 500
order_by_range 1.00 0.51 0.01 0.52 500
outer_join 0.00 0.00 0.00 0.00 10
outer_join_found 1.00 0.00 0.00 0.00 10
outer_join_not_found 0.00 0.00 0.00 0.00 500
outer_join_on_key 1.00 0.00 0.00 0.00 10
prepared_select 2.00 0.66 0.12 0.78 10000
select_1_row 9.00 1.80 0.97 2.77 100000
select_1_row_cache 9.00 1.66 0.95 2.61 100000
select_2_rows 9.00 2.07 0.89 2.96 100000
select_big 1.00 1.25 0.03 1.28 80
select_big_str 6.00 1.23 0.54 1.77 10000
select_cache 21.00 0.71 0.11 0.82 10000
select_cache2 21.00 0.72 0.11 0.83 10000
select_column+column 10.00 1.84 0.88 2.72 100000
select_diff_key 0.00 0.03 0.00 0.03 500
select_group 2.00 0.02 0.00 0.02 111
select_group_when_MANY_tables 0.00 0.02 0.02 0.04 1000
select_key 4.00 1.47 0.24 1.71 20000
select_key2 4.00 1.66 0.17 1.83 20000
select_key2_return_key 3.00 1.40 0.22 1.62 20000
select_key2_return_prim 3.00 1.40 0.21 1.61 20000
select_key_prefix 3.00 1.57 0.18 1.75 20000
select_key_return_key 3.00 1.42 0.20 1.62 20000
select_many_fields 16.00 3.73 0.05 3.78 2000
select_range 14.00 7.92 0.18 8.10 410
select_range_key2 4.00 2.06 0.16 2.22 25010
select_range_prefix 6.00 2.09 0.17 2.26 25010
select_simple 6.00 1.61 0.90 2.51 100000
select_simple_cache 6.00 1.87 0.92 2.79 100000
update_autocommit 10.00 0.05 0.03 0.08 10000
update_big 4.00 0.00 0.00 0.00 10
update_commit 1.00 0.18 0.11 0.29 10000
update_of_key 5.00 0.02 0.02 0.04 5000
update_of_key_big 2.00 0.01 0.00 0.01 480
update_of_primary_key_many_keys 2.00 0.01 0.01 0.02 256
update_rollback 1.00 0.20 0.12 0.32 100
update_with_key 28.00 0.10 0.10 0.20 30000
update_with_key_prefix 9.00 0.12 0.05 0.17 10000
wisc_benchmark 4.00 3.07 0.08 3.15 114
TOTALS 935.00 85.50 14.77 100.27 1203906
real 16m7.021s
user 1m34.972s
sys 0m15.166s
###########################################################
# django on postgresql
###########################################################
Ran 795 tests in 336.749s
OK
real 5m55.926s
user 2m33.078s
sys 0m10.289s
###########################################################
# django on sqlite
###########################################################
Ran 793 tests in 178.892s
OK
real 3m7.626s
user 2m49.023s
sys 0m6.543s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment