Skip to content

Instantly share code, notes, and snippets.

@fightbulc
Created September 3, 2013 12:02
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 fightbulc/6422956 to your computer and use it in GitHub Desktop.
Save fightbulc/6422956 to your computer and use it in GitHub Desktop.
[client]
default-character-set=utf8
socket=/usr/local/var/run/mysql.sock
#################################################
[mysqld]
socket=/usr/local/var/run/mysql.sock
skip-ssl
skip-name-resolve
join_buffer_size = 4M
table_definition_cache = 2048
table_open_cache = 2048
query_cache_limit = 64K
default-storage-engine = InnoDB
sort_buffer_size = 8M
query_cache_min_res_unit = 0
#
# time zone
#
default-time-zone = '+00:00'
#
# fulltext
#
ft_min_word_len=1 # tino
#
# InnoDB
#
innodb = ON
innodb_buffer_pool_instances = 1
innodb_fast_shutdown = 1
innodb_buffer_pool_size = 512M
innodb_file_per_table
innodb_additional_mem_pool_size = 2M
#
# character set
#
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
character-set-filesystem=utf8
#
# logging
#
long_query_time=1
slow_query_log=/usr/local/var/log/mysql/slow-queries.log
general_log=1
general_log_file=/usr/local/var/log/mysql/queries.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment