Juicey: New Juice Benchmark Output

Pushed about a ton of changes to the Juice benchmark since I announced it… lots of little fixes and a few big ones… really their are too many to talk about, and a lot of the new stuff is boring ( who cares about adding ramp up time, its just not that interesting to talk about ).

The big change is all about the Analyze.pl script. I am adding a ton to this script in order to try and give a concise and clear picture of what happened during the benchmark run. I am excited about it ( I am a geek though ) so I thought I would share what it looks like so far:

Total Test Runtime = 513.110480070114 seconds, limiting results to 300 seconds however
QNum:      4 ... QCount:      9 ... QTime:   0.028973 ... Max:   0.037164 ... FlatTime:   0.030530  ... Min5%:   0.015769  ... Max5%:   0.037164 
QNum:      7 ... QCount:   2900 ... QTime:   0.001224 ... Max:   0.027039 ... FlatTime:   0.000658  ... Min5%:   0.000134  ... Max5%:   0.012549 
QNum:      8 ... QCount:   2909 ... QTime:   0.006501 ... Max:   0.064809 ... FlatTime:   0.004871  ... Min5%:   0.001158  ... Max5%:   0.022202 
QNum:      9 ... QCount:     78 ... QTime:   7.551728 ... Max:  12.909189 ... FlatTime:   7.583298  ... Min5%:   2.761753  ... Max5%:  12.196176 
QNum:     10 ... QCount:    158 ... QTime:   3.468951 ... Max:   6.974674 ... FlatTime:   3.513459  ... Min5%:   1.128893  ... Max5%:   5.979509 
QNum:     11 ... QCount:    119 ... QTime:   8.327390 ... Max:  12.129862 ... FlatTime:   8.463985  ... Min5%:   3.524403  ... Max5%:  11.367781 
QNum:     13 ... QCount:      9 ... QTime:   7.490330 ... Max:  10.608021 ... FlatTime:   9.076644  ... Min5%:   4.011339  ... Max5%:  10.608021 
=======================stats===============================
CPU Totals  
___________________________________________________________________
USER:  26.82 SYS:  11.13 IDLE:  47.45 IOWAIT:  11.82 

IO Totals  
___________________________________________________________________
Device:  vtmsa ATPS: 34889.47 AMBRD/s:    41.55 AMBWR/s:   125.74 MxMBRD/s:    64.93 MxMBWR/s:   158.91 
Device:   sda7 ATPS:     2.97 AMBRD/s:     0.05 AMBWR/s:     0.00 MxMBRD/s:     0.87 MxMBWR/s:     0.01 
Device:    sda ATPS:     6.26 AMBRD/s:     0.07 AMBWR/s:     0.07 MxMBRD/s:     0.87 MxMBWR/s:     0.49 
Device:   sda5 ATPS:     3.29 AMBRD/s:     0.02 AMBWR/s:     0.07 MxMBRD/s:     0.20 MxMBWR/s:     0.49 
Device:    sdb ATPS:     0.01 AMBRD/s:     0.00 AMBWR/s:     0.00 MxMBRD/s:          MxMBWR/s:     0.02 
Device:   sdb2 ATPS:     0.01 AMBRD/s:     0.00 AMBWR/s:     0.00 MxMBRD/s:          MxMBWR/s:     0.02 

Innodb Stats:
___________________________________________________________________
Innodb Buffer Pool:  768 MB
Number of minutes:      6 Total Rows Read:      2601334 Avg Rows RDS/PS:  7225.93 
Number of minutes:      6 Total Rows Upda:      1145466 Avg Rows UPD/PS:  3181.85 
Number of minutes:      6 Total Rows Inse:            0 Avg Rows INS/PS:     0.00 
Number of minutes:      6 Total Rows Dele:            0 Avg Rows DEL/PS:     0.00 


=======================GRAPH===============================
User CPU :  26, 28, 25, 30, 28, 29, 31, 31, 34, 30, 29, 30, 27, 29, 25, 25, 24, 23, 23, 24, 27, 27, 26, 28, 26, 27, 29, 32, 32, 33, 31, 28, 27, 26, 23, 24, 22, 


I left off some of the graph data, but this is basically a comma delimited data section that you can grab IO stats, cpu stats, db stats from and drop into gnuplot, open office, excel , etc… pretty cool stuff! I hope to add a lot more in here over the next few weeks. Also, Yves started playing with it as well, so now with two eyes looking through the code hopefully we can get this thing cleaned up quickly.

This entry was posted in benchmark, Matt, mysql. Bookmark the permalink.

Comments are closed.