==================================================================================================== SYSBENCH BENCHMARK REPORT ==================================================================================================== MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com RUN ID: 628 RUN DATE: 2010-11-08T16:06:53.568865 WORKLOAD: innodb_1000K_readonly SERVER: drizzled VERSION: staging REVISION: 1915 COMMENT: 1915: Brian Aker 2010-11-08 [merge] Merge in Stewart's change to blob field size. ====================================================================================================
TRENDING OVER LAST 5 runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1933.26 -0.22% -4.17 1911.39 1961.63 1937.43 14.16 32 2531.15 -0.54% -13.62 2456.30 2584.90 2544.77 34.85 64 2612.73 +1.39% 35.85 2499.51 2631.08 2576.88 31.13 128 2633.73 +1.16% 30.20 2574.43 2647.96 2603.53 18.98 256 2583.81 -0.24% -6.13 2572.59 2616.15 2589.94 11.13 512 2361.46 -0.04% -0.87 2339.97 2385.18 2362.33 15.34 1024 1455.37 +3.44% 48.45 1317.48 1530.67 1406.92 71.03 ==================================================================================================== TRENDING OVER Last 20 runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1933.26 -0.40% -7.78 1882.34 2017.29 1941.04 28.88 32 2531.15 -1.27% -32.64 2456.30 2608.23 2563.79 33.45 64 2612.73 +0.74% 19.22 2499.51 2650.41 2593.51 29.50 128 2633.73 +0.77% 20.06 2574.43 2650.44 2613.68 17.98 256 2583.81 -0.14% -3.61 2556.63 2616.15 2587.42 12.28 512 2361.46 -0.07% -1.64 2319.43 2420.84 2363.11 19.51 1024 1455.37 +2.31% 32.91 1276.12 1794.48 1422.45 126.54 ==================================================================================================== TRENDING OVER ALL runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1933.26 -5.72% -117.33 1765.65 2233.42 2050.59 83.30 32 2531.15 -5.78% -155.37 2010.47 2909.92 2686.52 114.21 64 2612.73 -4.34% -118.55 2191.91 2998.80 2731.28 143.88 128 2633.73 -2.27% -61.16 2107.33 2911.98 2694.89 101.36 256 2583.81 +1.76% 44.70 2174.91 2691.02 2539.10 86.50 512 2361.46 +28.11% 518.16 968.50 2470.12 1843.31 514.36 1024 1455.37 +29.87% 334.76 485.25 1866.15 1120.61 509.95 ==================================================================================================== FULL REVISION COMMENTARY: 1267.1.8: Stewart Smith 2010-11-08 change dynamic_cast in field_conv.cc back to static_cast for runtime performance 1267.1.7: Stewart Smith 2010-11-08 in field_conv.cc, get_copy_func should not try to cast Field_blob to Field_varstring as Field_ blob does not inherit from field_varstring. Previously this kinda worked out due to the first member of field_blob kinda making sense in this comparison. Instead, we just shortcut to that decision if we are converting from BLOB. 1267.1.6: Stewart Smith 2010-11-08 change cast in field_conv.cc that was producing valgrind warning to dynamic_cast to crash on invalid cast. this shows up in several tests: e.g. func_gconcat 1267.1.5: Stewart Smith 2010-11-07 [merge] merge trunk 1267.1.4: Stewart Smith 2009-12-09 remove last bits of packlength from Field_blob, leaving only support for 4 byte length for blobs (not 1, not 2 and certainly not 3). 1267.1.3: Stewart Smith 2009-12-09 remove Field_blob constructor that had set_packflag argument being called in Item::tmp_table_field_from_field_type(). This would cause a Field_blob to be created that used 3 bytes instead of 4 for length... potentially causing all sorts of trouble 1267.1.2: Stewart Smith 2009-12-09 remove Field_blob constructor that only takes packlength as argument. It's never even called 1267.1.1: Stewart Smith 2009-12-09 remove blob_pack_length argument to Field_blob constructor. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp

