mac; mysql charset code; memory size limit control

my.cnf

# @温柔的码农
[client]
loose-default-character-set = utf8

[mysql]
loose-default-character-set = utf8

[mysqld]
collation-server = utf8_unicode_ci
loose-default-character-set = utf8
character-set-server = utf8
init-connect = 'SET NAMES utf8'
skip-character-set-client-handshake

# mac os yosemite; mysqld taking too much RAM; mysqld 500MB RAM
# prevent the mysqld from eating up RAM(make it drop from 500MB to 80MB)
max_connections       = 10

key_buffer_size       = 16K
max_allowed_packet    = 1M
table_open_cache      = 4
sort_buffer_size      = 64K
read_buffer_size      = 256K
read_rnd_buffer_size  = 256K
net_buffer_length     = 2K
thread_stack          = 128K