====================================================================================================
SYSBENCH BENCHMARK REPORT 
====================================================================================================
MACHINE:  drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID:   521
RUN DATE: 2010-10-12T14:17:01.622857
WORKLOAD: innodb_1000K_readonly
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     1962.72       -0.79%     -15.70    1942.49    2019.60    1978.42      
18.41
32     2610.70       +1.85%      47.31    2419.51    2651.66    2563.39      
79.02
64     2622.64       +0.23%       6.10    2548.68    2650.79    2616.54      
30.07
128    2616.03       +0.13%       3.34    2553.50    2652.28    2612.69      
32.29
256    2601.14       +0.27%       7.03    2549.82    2642.78    2594.11      
28.63
512    2378.94       -0.09%      -2.09    2371.10    2391.57    2381.03       
5.60
1024   1703.72       +0.49%       8.28    1628.29    1728.57    1695.44      
26.27
====================================================================================================

TRENDING OVER Last 20 runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1962.72       -1.61%     -32.14    1927.62    2094.11    1994.86      
32.90
32     2610.70       +0.91%      23.52    2419.51    2651.66    2587.18      
51.00
64     2622.64       +1.11%      28.71    2539.98    2650.79    2593.93      
27.21
128    2616.03       +0.24%       6.28    2547.60    2676.15    2609.75      
35.29
256    2601.14       +0.07%       1.92    2530.00    2678.27    2599.22      
31.88
512    2378.94       -0.34%      -8.18    2324.41    2458.46    2387.12      
31.23
1024   1703.72       -0.74%     -12.72    1628.29    1763.44    1716.44      
27.47
====================================================================================================

TRENDING OVER ALL runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1962.72       -5.24%    -108.61    1765.65    2233.42    2071.33      
72.14
32     2610.70       -3.64%     -98.56    2010.47    2909.92    2709.25     
108.28
64     2622.64       -4.89%    -134.89    2191.91    2998.80    2757.53     
139.74
128    2616.03       -3.54%     -95.96    2107.33    2911.98    2711.99      
99.31
256    2601.14       +2.75%      69.63    2174.91    2691.02    2531.51      
90.67
512    2378.94      +35.88%     628.22     968.50    2470.12    1750.73     
505.42
1024   1703.72      +61.02%     645.63     485.25    1785.68    1058.09     
527.54
====================================================================================================
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

Reply via email to