ioDrive de benchmarking 2011 1209_zem_distribution

• クラウドは人生(ｷﾘｯ
–
•
•
•
–

–
•
•

–
•

•
–
•
–
•
–
•
–
•
–
•
–
•
•
•

•
–
–

•
–
–

•
–
–

•
–
–

•
–
–

•

•
–

•
–
–

•
–

•

•
•
•
•
•
•
•
•
•
•

•
–

•

–

•

•

•
•
•
•

•
•
•
•

•
–

•
–

–

•
–
–
–

•
–
–

•
–

•
–

•
–

Deltree "¥clients¥client1" NT_STATUS_OK
Mkdir "¥clients" NT_STATUS_OK
NTCreateX "¥clients¥client1" 0x1 0x2 16385 NT_STATUS_OK
Close 16385 NT_STATUS_OK
NTCreateX "¥clients¥client1¥mixfile" 0x40 0x1 9935 NT_STATUS_OBJECT_NAME_NOT_FOUND
QUERY_PATH_INFORMATION "¥clients¥client1¥~dmtmp" 1004 NT_STATUS_OBJECT_NAME_NOT_FOUND
FIND_FIRST "¥clients¥client1¥FILLER.*" 260 1366 0 NT_STATUS_NO_SUCH_FILE
NTCreateX "¥clients¥client1¥~dmtmp" 0x1 0x2 9937 NT_STATUS_OK
Close 9937 NT_STATUS_OK
l
NTCreateX "¥clients¥client1¥filler.000" 0x40 0x2 9938 NT_STATUS_OK
QUERY_FS_INFORMATION 1 NT_STATUS_OK
WriteX 9938 65534 1 1 NT_STATUS_OK
QUERY_FILE_INFORMATION 9938 258 NT_STATUS_OK
QUERY FILE INFORMATION 9938 258 NT STATUS OK
WriteX 9938 196608 65536 65536 NT STATUS OK
9938 196608 65536 65536 NT_STATUS_OK

dbench version 4.00 - Copyright Andrew Tridgell 1999-2004
py g g

Running for 10 seconds with load '/usr/local/share/client.txt' and minimum warmup
2 secs
1 of 1 processes prepared for launch 0 sec
releasing clients
1 41998 243.68 MB/sec warmup 1 sec latency 67.858 ms
1 171196 349.36 MB/sec execute 1 sec latency 17.176 ms
1 366016 349.86 MB/
349 86 MB/sec execute 4 sec l t
t latency 16 510 ms
16.510
1 557047 349.23 MB/sec e ec te 7 sec latenc 4.118 ms
349 23 execute latency 4 118
1 cleanup 10 sec
0 cleanup 10 sec

Operation Count AvgLat MaxLat
----------------------------------------
NTCreateX 104342 0.007 0.108

Operation
p Count AvgLat
g MaxLat
----------------------------------------
NTCreateX 104342 0.007 0.108
Close 76639 0.001 0.014
Rename 4417 0.018 0.423
Unlink 21076 0.014 0.129
Deltree 2 2.151 4.244
Mkdir 1 0.002 0.002
Qpathinfo 94576 0.005 0.030
Qfileinfo 16549 0.001 0.010
Qfsinfo
Qf i f 17332 0 129
0.129 16 581
16.581
Sfileinfo 8504 0.004 0.017
Find 36527 0.017 0.041
WriteX 51879 0.018
0 018 0.141
0 141
ReadX 163469 0.002 0.020
LockX 340 0.001 0.007
UnlockX 340 0 001
0.001 0.009
0 009
Flush 7308 0.428 40.069

Throughput 327 658 MB/sec 1 clients 1 procs max latency=40 073 ms
327.658 max_latency=40.073

•
–
•

•

–

************************************************************************
* DBT-2 test for mysql started
* *
* Results can be found in output/7 directory
************************************************************************
* *
* Test consists of 3 stages: *
* *
* 1. Start of client to create pool of databases connections *
* 2. Start of driver to emulate terminals and transactions generation *
* 3. Processing of results *
* *
************************************************************************

DATABASE SYSTEM: localhost
DATABASE NAME: dbt2
DATABASE USER: root
DATABASE CONNECTIONS: 128
TERMINAL THREADS: 500
TERMINALS PER WAREHOUSE: 10
SCALE FACTOR(WAREHOUSES): 50
DURATION OF TEST (in sec): 180
1 client stared every 10 millisecond(s)

Stage 1. Starting up client...

Stage 2. Starting up driver
2 driver...
10 threads started per millisecond
estimated rampup time: Sleeping 5 seconds
estimated rampup time has elapsed
estimated steady state time: Sl
i d d i Sleeping 180 seconds
i d

Stage 3. Processing of results...
Killing client...
MySQL stopped successfully (by kill).
Test completed.
Results are in: /usr/local/src/dbt-2/dbt2-0.40/scripts/../scripts/output/7

Response Time (s)
Transaction % Average : 90th % Total Rollbacks %
------------ ----- --------------------- ----------- --------------- -----
Delivery 4.07 0.934 : 1.047 5116 0 0.00
New Order 45.13 0.816 : 0.933 56724 546 0.97
Order Status 3.94 0.550 : 0.583 4949 0 0.00
Payment 42 93
42.93 0 615 :
0.615 0 744
0.744 53962 0 0 00
0.00
Stock Level 3.94 0.543 : 0.574 4947 0 0.00
------------ ----- --------------------- ----------- --------------- -----

18752.36 new-order transactions per minute (NOTPM)
3.0 minute duration
0 total unknown errors

•
–

•
–

•

–

sysbench 0.4.12: multi-threaded system evaluation benchmark

No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 16

Doing OLTP test.
Running mixed OLTP test
g
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 15 times)
Done.

OLTP test statistics:
t t t ti ti
queries performed:
read: 5265806
write: 1880645
other: 752258
total: 7898709
transactions: 376129 (2089.47 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 7146451 (39699 99 per sec )
(39699.99 sec.)
other operations: 752258 (4178.95 per sec.)

Test execution summary:

ime limit exceeded, exiting...
(last message repeated 15 times)
Done.

OLTP test statistics:
queries performed:
read: 5265806
write: 1880645
other: 752258
total: 7898709
transactions: 376129 (2089 47 per sec )
(2089.47 sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 7146451 (39699.99 per sec.)
other operations: 752258 (4178.95 per sec.)

Test execution summary:
total time: 180.0114s
total number of events: 376129
total time taken by event execution: 2877.6783
per-request statistics:
min: 2.03ms
avg: 7.65ms
max: 105.17ms
approx. 95 percentile: 24.42ms

Threads fairness:
events (avg/stddev): 23508.0625/192.99
execution ti (
ti time (avg/stddev):
/ tdd ) 179.8549/0.00
179 8549/0 00

•

•
–
–

•

•

•
–

–

•
•
•

ioDrive de benchmarking 2011 1209_zem_distribution

More Related Content

ioDrive de benchmarking 2011 1209_zem_distribution