Skip to content

Instantly share code, notes, and snippets.

@jcxk
Created April 5, 2016 14:38
Show Gist options
  • Save jcxk/06c4f8bb0d12ed9c5038dea058df4932 to your computer and use it in GitHub Desktop.
Save jcxk/06c4f8bb0d12ed9c5038dea058df4932 to your computer and use it in GitHub Desktop.
[mysqld]
#innodb_log_archive=OFF
innodb_log_file_size = 2G
innodb_buffer_pool_size=6G
max_allowed_packet = 1024M
innodb_log_buffer_size = 1024M
innodb_file_format=Barracuda
innodb_file_format_max=Barracuda
innodb_file_per_table=1
innodb_read_io_threads=4
innodb_write_io_threads=8
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
skip-innodb_doublewrite
innodb_page_size=65536
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment