my.cnf

# only local permit access
bind-address = 127.0.0.1
# add client ip 192.168.10.35 
bind-address = 192.168.10.35
# if comment bind-address, permit connect anywhere

# many application server connect 
max_connections=500
# for migrate from oracle
lower_case_table_names=1

# query buffer size = 70% of memory
innodb_buffer_pool_size=16G
# for long query
connect_timeout=300
net_read_timeout=600
net_write_timeout=600
# using large size query result
max_allowed_packet=64M
# large join data
join_buffer_size=1260000
# large table read
table_open_cache=102000
# innodb log file size
innodb_log_file_size=100M
# log buffer size for innodb
innodb_log_buffer_size=16M
# same to table count(get table information using memory)
table_definition_cache=3471
# query cache
query_cache_type=1
# cache per query
query_cache_limit=16M
# total query cache
query_cache_size=256M

# for tuning
slow_query_log=1
slow_query_log_file=/mnt/logs/mysql-slow.log
long_query_time=10