Skip to content

Instantly share code, notes, and snippets.

@sh2
Created August 16, 2012 08:35
Show Gist options
  • Save sh2/3368433 to your computer and use it in GitHub Desktop.
Save sh2/3368433 to your computer and use it in GitHub Desktop.
my.cnf for a windows laptop computer.
[mysqld]
console
## character set
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
## sql
sql_mode = TRADITIONAL
transaction_isolation = READ-COMMITTED
## connection
max_connections = 256
thread_cache_size = 8
## per connection buffer
sort_buffer_size = 4M
## file descriptor
table_open_cache = 4096
## network
max_allowed_packet = 16M
## innodb
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_io_capacity = 1024
innodb_flush_log_at_trx_commit = 1
#innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 256M
innodb_log_file_size = 128M
## query cache
query_cache_type = 0
#query_cache_size = 16M
## binary log
#server_id = 1
#log_bin = mysql-bin
#expire_logs_days = 14
#sync_binlog = 1
#binlog_format = MIXED
#binlog_cache_size = 1M
#report_host = hostname
#slave_net_timeout = 30
## slow query log
slow_query_log = 1
long_query_time = 5.0
[mysql]
default_character_set = cp932
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment