I think the top two runs can finally settle the issue with readwrite numbers being oddly variant.

Only difference in run_id 503, which peaked at ~2600tps and run_id 499, which peaked at ~2200tps, was that 503 was completed at 1am and 499 was completed at 4:30pm.

Like I've said before, it's very difficult to get good numbers from sysbench readwrite, even with these "extended time" configurations...

-jay

drizzle-x4450 wrote:
==================================================================
REGRESSION REPORT
==================================================================
MACHINE:  drizzle-x4450
RUN ID:   503
RUN DATE: 2009-09-18T01:17:33.371958
WORKLOAD: drizzled
SERVER:   innodb_1000K_readwrite
VERSION:  lp:drizzle/staging
REVISION: 1128
COMMENT:  1128: Brian Aker 2009-09-16 [merge] Merge Jay Alter table + Brian 
dead code
==================================================================
Version Run ID  Date    Conc    TPS
==================================================================
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     2       708.530000
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     4       1315.023333
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     8       1604.380000
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     16      2589.200000
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     32      2229.923333
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     64      1925.123333
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     128     1696.300000
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     256     1447.506667
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     512     1416.923333
lp:drizzle/staging-1128 503     2009-09-18 01:17:33     1024    828.596667
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     2       754.140000
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     4       1147.873333
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     8       1632.393333
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     16      2073.583333
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     32      2181.023333
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     64      1822.696667
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     128     1761.803333
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     256     1498.170000
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     512     1438.936667
lp:drizzle/staging-1128 499     2009-09-17 16:30:14     1024    837.633333
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     2       753.820000
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     4       1137.633333
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     8       1694.736667
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     16      2643.343333
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     32      2088.890000
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     64      1982.936667
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     128     1705.650000
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     256     1451.440000
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     512     1420.736667
lp:drizzle/staging-1126 472     2009-08-27 23:05:15     1024    838.050000
==================================================================
FULL REVISION COMMENTARY:

  1126.2.5: Brian Aker 2009-09-16 [merge] Merge Jay.
    1126.3.5: Jay Pipes 2009-09-15 Clean up the style and spacing in mysql_p...
    1126.3.4: Jay Pipes 2009-09-15 Changes Alter_drop and Alter_column to Al...
    1126.3.3: Jay Pipes 2009-09-15 Moves Alter_info out into its own header ...
    1126.3.2: Jay Pipes 2009-09-15 Simply moves alter_table specific stuff o...
    1126.3.1: Jay Pipes 2009-09-15 Removed unnecessary block of code in Alte...
  1126.2.4: Brian Aker 2009-09-16 Move block code out of HA_CREATE_INFO
  1126.2.3: Brian Aker 2009-09-14 Remove dead keywords.
  1126.2.2: Brian Aker 2009-09-14 Remove need for protocol from myisam
  1126.2.1: Brian Aker 2009-09-14 Rmove dead bit around old eror_injection s...

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to