my.cnf参数配置

[mysqld]
basedir=/opt/djangostack-1.4-0/mysql
datadir=/opt/djangostack-1.4-0/mysql/data
port=3306
socket=/opt/djangostack-1.4-0/mysql/tmp/mysql.sock
tmpdir=/opt/djangostack-1.4-0/mysql/tmp
#bind-address=127.0.0.1
log_slow_queries    = /opt/djangostack-1.4-1/mysql/mysql-slow.log
long_query_time = 30
log-queries-not-using-indexes
max_allowed_packet=1024M
wait_timeout=2880000
interactive_timeout=2880000
max_connections      = 100

原文地址:https://www.cnblogs.com/lexus/p/2542227.html