Skip to content

Instantly share code, notes, and snippets.

Yorick Terweijden terwey

Block or report user

Report or block terwey

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
terwey / gist:4723764
Last active Dec 12, 2015
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...
View gist:4723764
# 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
You can’t perform that action at this time.