# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0

#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid

########################################################
datadir=/home/mysql
#socket=/home/mysql/mysql.sock



[client]
port=3306
socket=/var/lib/mysql/mysql.sock


#########################################################

[mysqld]

# 80% RAM innodb_buffer_pool_size
innodb_buffer_pool_size=102G
sort_buffer_size=6000M
#join_buffer_size = 3000M
#read_rnd_buffer_size=3000M
innodb_lock_wait_timeout=90
query_cache_type=1
query_cache_size=150M
#query_cache_limit=128M
thread_cache_size=80
max_connections=500

max_heap_table_size=500M
max_allowed_packet=50000000


# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#updated by dev 22-1-2016
[mysqld]
init_connect='SET NAMES utf8'
init_connect='SET character_set_client = utf8'
init_connect='SET character_set_server = utf8'
init_connect='SET character_set_connection = utf8'
init_connect='SET character_set_results = utf8'
init_connect='SET collation_server = utf8_unicode_ci'
init_connect='SET collation_connection = utf8_unicode_ci'

character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
#character-set-connection=utf8

[mysqld]
long_query_time=60
slow-query-log-file=/home/log/mysql/log-slow-queries.log.log
#log-slow-queries=/var/log/mysqld.log
#log-slow-queries=/var/log/mysqld.log

default_time_zone='+01:00'

#added by girish 14-07-2016
#innodb_read_io_threads=8
#innodb_write_io_threads=8

# for neon api group_concat 1024*1024
group_concat_max_len=1048576