====================================================================================================
SYSBENCH BENCHMARK REPORT 
====================================================================================================
MACHINE:  drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID:   524
RUN DATE: 2010-10-12T14:23:09.536305
WORKLOAD: innodb_1000K_readwrite
SERVER:   drizzled
VERSION:  staging
REVISION: 1842
COMMENT:  1842: Brian Aker 2010-10-12 [merge] Merge for Stewart
====================================================================================================

TRENDING OVER LAST 5 runs 
Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1237.12       -0.78%      -9.78    1226.02    1279.13    1246.90      
14.14
32     1586.39       +0.80%      12.59    1488.91    1624.32    1573.80      
42.29
64     1726.03       +1.22%      20.72    1636.07    1753.09    1705.30      
38.91
128    1797.25       +1.10%      19.56    1719.25    1808.73    1777.70      
25.59
256    1719.70       -0.88%     -15.30    1711.20    1758.26    1735.00      
13.80
512    1507.56       -0.39%      -5.85    1499.00    1527.02    1513.41       
8.13
1024   1108.30       +4.00%      42.63     983.11    1118.96    1065.67      
42.23
====================================================================================================

TRENDING OVER Last 20 runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1237.12       -1.43%     -17.91    1223.14    1300.62    1255.02      
16.72
32     1586.39       +0.96%      15.09    1461.23    1637.14    1571.29      
44.91
64     1726.03       +1.75%      29.70    1621.54    1753.09    1696.33      
34.68
128    1797.25       +2.03%      35.84    1691.57    1808.73    1761.42      
27.89
256    1719.70       -0.89%     -15.44    1691.39    1771.39    1735.14      
16.46
512    1507.56       -0.77%     -11.76    1470.69    1548.61    1519.32      
13.76
1024   1108.30       +5.16%      54.37     948.52    1118.96    1053.93      
33.17
====================================================================================================

TRENDING OVER ALL runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1237.12       -4.00%     -51.52    1111.61    1503.03    1288.64      
64.41
32     1586.39       -4.60%     -76.51    1403.17    1870.18    1662.90     
102.17
64     1726.03       -5.04%     -91.55    1584.08    2059.46    1817.58     
115.51
128    1797.25       -2.86%     -52.91    1563.60    2051.37    1850.17      
94.19
256    1719.70       -0.42%      -7.25    1340.97    1824.49    1726.95      
65.13
512    1507.56      +18.80%     238.54     828.88    1554.29    1269.02     
203.90
1024   1108.30      +50.47%     371.72     450.29    1118.96     736.58     
232.37
====================================================================================================
FULL REVISION COMMENTARY:

  1815.2.12: Stewart Smith 2010-10-13 remove HailDB config_fast_shutdown2 test 
as we shut down so hard we leave a bunch of Valgrind warnings around.
  1815.2.11: Stewart Smith 2010-10-13 fix index definitions of HailDB system 
tables.
  1815.2.10: Stewart Smith 2010-10-13 check query plan of HailDB datadict table 
access
  1815.2.9: Stewart Smith 2010-10-13 remove HAILDB_VERSION() function - you can 
get this through the data_dictionary now
  1815.2.8: Stewart Smith 2010-10-13 update haildb.status_table_function result 
for InnoDB->HailDB name change
  1815.2.7: Stewart Smith 2010-10-13 update haildb config_file_per_table_enable 
test to look in DRIZZLETEST_VARDIR as MYSQLTEST_VARDIR is now gone
  1815.2.6: Stewart Smith 2010-10-12 [merge] merge trunk
  1815.2.5: Stewart Smith 2010-10-07 use the new ib_get_table_statistics() 
HailDB API for getting better record count from HailDB
  1815.2.4: Stewart Smith 2010-10-06 make all HailDB tests using EXPLAIN 
substitute out the rows column as this will be non-exact from HailDB
  1815.2.3: Stewart Smith 2010-10-06 use ib_get_table_statistics() - new in 
HailDB 2.3 - to implement a better HailDBCursor::scan_time() metric. Pretty 
much exactly the same as Innobase handler.
  1815.2.2: Stewart Smith 2010-10-06 change HailDB status table function to use 
ib_status_get_all() API call - new to HailDB 2.1
  1815.2.1: Stewart Smith 2010-10-06 only include haildb.h in HailDB Plugin, do 
not even try for embedded innodb header.

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp
  • [Drizzle-benchmark] S... drizzle-build-n01 . wc1 . dfw1 . stabletransit . com
    • [Drizzle-benchma... drizzle-build-n02 . wc1 . dfw1 . stabletransit . com

Reply via email to