News for hackers. Stuff that matters.
Re:MySQL is bazillion times faster than MemSQL by HarrisonFisk on Tuesday June 26, 2012 @02:11PM (#4163333)
The primary settings are:

sync_binlog=1 innodb_flush_log_at_trx_commit=1 (which is default, but we add it to our configs since we run with =2 on the slaves since they don't need full durability)

We do use some performance related settings related to this as well:

innodb_flush_method = O_DIRECT innodb_prepare_commit_mutex=0 (enables group commit in the Facebook patch, other branches have a different setting)

For settings like innodb_doublewrite we leave the default of enabled.

There are no comments on this comment yet.