Skip to content

Instantly share code, notes, and snippets.

@mythmon
Created October 26, 2012 21:00
Show Gist options
  • Save mythmon/3961453 to your computer and use it in GitHub Desktop.
Save mythmon/3961453 to your computer and use it in GitHub Desktop.
Snippet of my.cnf that makes tests 30% faster
# To my understanding, these settings make mysql slightly less durable/reliable, but in ways
# that don't really affect tests.
[mysqld]
# Don't flush log after transactions
innodb_flush_log_at_trx_commit = 0
# Don't sync binlog (it still gets written, but faster)
sync_binlog = 0
# Use a faster, less durable method to sync the DB.
innodb_flush_method = O_DIRECT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment