Hi!
On May 24, 2009, at 6:37 AM, Jay Pipes wrote:
Brian Aker wrote:
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
Hi! You may need to re-run your tests. You have two db-driver= in
the above, and it will take the second (drizzleclient) which is the
old driver...
So, the below may not be showing the correct results for any
revision of Drizzle after r950.
This was instrumented server code, so for cachegrind the TPS is not
really interesting.
But!
On Gaz right now I am finding that drizzleclient is around 30% faster
then the libdrizzle we have on the box.
Cheers,
-Brian
Cheers,
Jay
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
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
