##HgigaAPICustomMyCnf
## eric.lin copy form /usr/share/mysql/my-huge.cnf
## eric.lin modify for hgiga-api

[client]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
## for hgiga-api
default-character-set=utf8

[mysqld]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 128M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
server-id	= 1
innodb_file_per_table=1
innodb_buffer_pool_size = 384M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

## for hgiga-api
character-set-server=utf8
init_connect='SET NAMES utf8'
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
max_connections = 2000
wait_timeout = 28800
interactive_timeout = 28800

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet = 128M
## for hgiga-api
default-character-set=utf8

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
## for hgiga-api
default-character-set=utf8

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
## for hgiga-api
default-character-set=utf8

[mysqlhotcopy]
interactive-timeout
## for hgiga-api
default-character-set=utf8