fortuneteller

Source: https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster

innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0
Why these settings ?

innodb_buffer_pool_size will cache frequently read data

malclocke

$ git branch -r --merged | 
  awk -F'/' '/^ *origin/{if(!match($0, /(>|master)/)){print $2}}' | 
  xargs git push origin --delete