Skip to content

Instantly share code, notes, and snippets.

@crynobone

crynobone/my.cnf

Created December 12, 2012 11:56
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save crynobone/4267222 to your computer and use it in GitHub Desktop.
Save crynobone/4267222 to your computer and use it in GitHub Desktop.
Download ZIP
my.cnf configuration for Macbook Air using MAMP.
Raw
my.cnf
[mysqld]
default-storage-engine=InnoDB
collation-server=utf8_unicode_ci
character-set-server=utf8
init-connect='SET NAMES utf8'
table_cache=250
query_cache_size=0
query_cache_type=0
innodb_file_per_table
innodb_buffer_pool_size=10240M
innodb_file_format=barracuda
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=1
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_io_capacity=1000
innodb_thread_concurrency=4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment