mysql数据库调优

编辑/etc/my.cnf

max_connections=10000
join_buffer_size = 64M
read_buffer_size = 128M
key_buffer = 512M
open-files-limit = 28196
query_cache_type=2
query_cache_size = 32M
tmp_table_size = 1024M
long_query_time=2
log-slow-queries = /var/log/mysql/slowquery.log
log_bin = /var/log/mysql/mysql-bin.log

mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql
来自史郎

当然了，这东西还是自动发送到你的邮箱比较好
写个脚本，mailslowquery.sh，然后配置到crontab
uuencode /var/log/mysql/slowquery.log slowquery.sql | mail -s "slow query of mysql" ***@126.com
echo "">/var/log/mysql/slowquery.log

调试连接数据库的时候，有些内容更有用，但一般不要用在生产机

在/etc/my.cnf里加入

[mysqld]
log=/var/log/mysql_query.log