Hi!
The first "set" is Drizzle, the seconds set of numbers is MySQL 5.4.
8 Core Intel System/8gigs of Ram
sysbench --db-driver=drizzle --drizzle-mysql=on --max-time=200 --max-
requests=0 --test=oltp --drizzle-db=test --drizzle-port=4427 --drizzle-
host=127.0.0.1 --drizzle-user=root --db-ps-mode=disable --db-
driver=drizzleclient --drizzle-table-engine=innodb --oltp-read-only=on
--oltp-table-size=100000
Any thoughts?
Drizzle ->
OLTP test statistics:
queries performed:
read: 1253938
write: 0
other: 179134
total: 1433072
transactions: 89567 (447.83 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 1253938 (6269.65 per sec.)
other operations: 179134 (895.66 per sec.)
Test execution summary:
total time: 200.0012s
total number of events: 89567
total time taken by event execution: 199.2262
per-request statistics:
min: 1.94ms
avg: 2.22ms
max: 13.85ms
approx. 95 percentile: 2.33ms
Threads fairness:
events (avg/stddev): 89567.0000/0.00
execution time (avg/stddev): 199.2262/0.00
==14109==
==14109== I refs: 4,978,383,588
==14109== I1 misses: 50,512,290
==14109== L2i misses: 3,963,944
==14109== I1 miss rate: 1.01%
==14109== L2i miss rate: 0.07%
==14109==
==14109== D refs: 2,215,296,987 (1,569,218,341 rd +
646,078,646 wr)
==14109== D1 misses: 32,222,003 ( 24,411,429 rd +
7,810,574 wr)
==14109== L2d misses: 12,816,504 ( 10,170,854 rd +
2,645,650 wr)
==14109== D1 miss rate: 1.4% ( 1.5% +
1.2% )
==14109== L2d miss rate: 0.5% ( 0.6% +
0.4% )
==14109==
==14109== L2 refs: 82,734,293 ( 74,923,719 rd +
7,810,574 wr)
==14109== L2 misses: 16,780,448 ( 14,134,798 rd +
2,645,650 wr)
==14109== L2 miss rate: 0.2% ( 0.2% +
0.4% )
==14109==
==14109== Branches: 847,425,590 ( 820,029,378 cond +
27,396,212 ind)
==14109== Mispredicts: 25,330,650 ( 20,115,372 cond +
5,215,278 ind)
==14109== Mispred rate: 2.9% ( 2.4% +
19.0% )
MySQL ->
OLTP test statistics:
queries performed:
read: 1020250
write: 0
other: 145750
total: 1166000
transactions: 72875 (364.37 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 1020250 (5101.17 per sec.)
other operations: 145750 (728.74 per sec.)
Test execution summary:
total time: 200.0030s
total number of events: 72875
total time taken by event execution: 199.3698
per-request statistics:
min: 2.39ms
avg: 2.74ms
max: 6.22ms
approx. 95 percentile: 2.87ms
Threads fairness:
events (avg/stddev): 72875.0000/0.00
execution time (avg/stddev): 199.3698/0.00
==26463== I refs: 5,388,606,148
==26463== I1 misses: 60,067,700
==26463== L2i misses: 1,103,242
==26463== I1 miss rate: 1.11%
==26463== L2i miss rate: 0.02%
==26463==
==26463== D refs: 2,084,722,851 (1,557,635,099 rd +
527,087,752 wr)
==26463== D1 misses: 26,799,586 ( 17,224,205 rd +
9,575,381 wr)
==26463== L2d misses: 1,371,822 ( 591,124 rd +
780,698 wr)
==26463== D1 miss rate: 1.2% ( 1.1% +
1.8% )
==26463== L2d miss rate: 0.0% ( 0.0% +
0.1% )
==26463==
==26463== L2 refs: 86,867,286 ( 77,291,905 rd +
9,575,381 wr)
==26463== L2 misses: 2,475,064 ( 1,694,366 rd +
780,698 wr)
==26463== L2 miss rate: 0.0% ( 0.0% +
0.1% )
==26463==
==26463== Branches: 1,076,632,343 (1,049,922,300 cond +
26,710,043 ind)
==26463== Mispredicts: 25,753,974 ( 20,631,298 cond +
5,122,676 ind)
==26463== Mispred rate: 2.3% ( 1.9% +
19.1% )
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
