[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
