Skip to content

Instantly share code, notes, and snippets.

@buddhamagnet
Created January 31, 2013 08:51
Show Gist options
  • Save buddhamagnet/4681421 to your computer and use it in GitHub Desktop.
Save buddhamagnet/4681421 to your computer and use it in GitHub Desktop.
MYSQL: SETTINGS
key_buffer_size=1300M
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=768M
innodb_log_file_size=2047M
innodb_log_buffer_size=512M
innodb_thread_concurrency=3
innodb_read_io_threads=4
innodb_write_io_threads=4
innodb_flush_method=O_DIRECT
innodb_file_per_table
Then at the start of the dump file:
SET autocommit=0;
SET unique_checks=0;
SET foreign_key_checks=0;
and the end of the file:
COMMIT;
SET unique_checks=1;
SET foreign_key_checks=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment