Skip to content

Instantly share code, notes, and snippets.

@terwey
Last active December 12, 2015 05:48
Show Gist options
  • Save terwey/4723764 to your computer and use it in GitHub Desktop.
Save terwey/4723764 to your computer and use it in GitHub Desktop.
NewzNab is very slow with innodb_flush_log_at_trx_commit = 1; I've seen extremely slow commits from Newznab and decided to take a look. I went from crawling slow to blazingly fast with simply turning this on. Now ok in case of a crash/fire etc your data might be lost or whatever. But this is not important data...
# mysql -u YOURUSER -p
mysql> SET GLOBAL innodb_flush_log_at_trx_commit = 0;
# add this to your /etc/mysql/my.cnf
# innodb_flush_log_at_trx_commit = 0;
# to make this permanent
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment