Skip to content

Instantly share code, notes, and snippets.

@jpowell

jpowell/my.cnf

Created April 21, 2012 19:12
Show Gist options
  • Save jpowell/2439158 to your computer and use it in GitHub Desktop.
Save jpowell/2439158 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL config optimized for importing a dump
Raw
my.cnf
[mysqld]
max_allowed_packet=128M
#innodb_force_recovery=1
# fast import settings
key_buffer_size=2G
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DSYNC
innodb_buffer_pool_size=64M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment