EmergencyEMERGENCY? Get 24/7 Help Now!

iiBench configuration

 | December 5, 2008 |  Posted In: Tokutek, TokuView

PREVIOUS POST
NEXT POST

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:

PREVIOUS POST
NEXT POST

3 Comments

  • I’m curious.

    If this is your my.cnf for your iibench Contest, where you are inserting into a single table, why do you have innodb_buffer_pool_size and key_buffer_size set, splitting up your memory resources. The resultant table in your benchmark is one storage engine or the other.

    Unless you are doing something like a MyISAM table (given it’s 8GB buffer), and then many InnoDB tables for additional seeding (you have plenty of innodb specific settings) I see no understand between your competition requirements and your settings.

    In addition, previous versions of MySQL crashed with a key_buffer_size > 4GB when accessing pointers above 4GB. I’m assuming this is no longer an issue in 5.1

  • We used a single set of mysql parameters for both InnoDB and MyISAM to avoid stopping and restarting the mysql server. Although the total memory allocated to both engines together exceeds the size of physical memory, we ran only one test at a time. Individually, each engine’s allocation is less than the size of physical memory. Our thinking was that with only one engine running at a time, the working set would fit within physical memory. We ran InnoDB first, and then MyISAM, and each engine ran for at least two days, so the transition from working set to the other probably wasn’t significant. My own expertise is in the underlying algorithms, rather than the specifics of MySQL parameter settings. For the contest, I would expect and encourage people to modify those settings to optimize performance.

  • Hm,

    If you’re focusing on Inserts why changing so many different parameters which does not anything to do with Inserts.

    Also you would normally want different configurations for MyISAM and Innodb because they would compete for the same memory.

Leave a Reply

 
 

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.