A tip of the hat to Mark Callaghan, who suggested I post our my.cnf settings for iiBench.
Instead of fiddling around with the configuration file, we adjusted everything on the command line. Here’s the relevant script from iiBench/scripts/start_mysql.sh:

I’d like to advertise my previous iiBench posting again (now that we are feeding into PlanetMySQL.)

At the recent OpenSQL Camp in Charlottesville, VA, Tokutek offered a challenge to the MySQL community – who can insert a billion rows into MySQL the fastest?  We will post the results on our website and the winner gets a…