mysqlconf

[mysqld]
#
max_connections=20000　　　　#数据传输可能出现大表中断与这个有关系
port=13306
default-authentication-plugin=mysql_native_password
#datadir=/opt/data/mysql/mysql
#socket=/opt/data/mysql/mysql/mysql.sock
datadir=/opt/data/mysql/mysql/mysql
socket=/opt/data/mysql/mysql/mysql/mysql.sock
#socket=/opt/data/mysql/tbsql/var/lib/mysql/mysql.sock
#datadir=/opt/data/mysql/tbsql/var/lib/mysql
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#内部内存临时表的最大值。
##比如大数据量的group by ,order by时可能用到临时表，
##超过了这个值将写入磁盘，系统IO压力增大
tmp_table_size=640M
max_heap_table_size=640M
#inner left right join时用到
##建议先调整为4M，后期观察调整
join_buffer_size=400M
sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
innodb_buffer_pool_size = 36G
wait_timeout =  9640000
interactive_timeout = 9640000
max_allowed_packet = 100G