I just read your proposal for changing the behavior of the
scavenger for sysbench related tests:
--falcon-scavenge-schedule=1,6,11,16,21,26,31,36,41,46,51.56 * * * * *
Would make sense to try
For InnoDB I got a tip from Vadim from Percona to lower
from it's default of 90% to 70% and it helped to flaten the periodic
drops in InnoDB's performance a bit. I had a brief look into InnoDB's
code and it looks like it flushes all dirty pages, which means that they
probably don't have a "innodb_max_dirty_pages_floor_pct" like a thing.
So flushing more often in smaller chunks helped InnoDB.
Hakan Küçükyılmaz, Senior Software Engineer DBTG/MySQL +49 160
Sun Microsystems GmbH Sonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer
Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028 49.011, 8.376