query_cache_limit = 2M
max_connections = 2048
thread_cache_size = 512
open_files_limit = 65535
table_definition_cache = 1024
table_open_cache = 2048
# INNODB #
innodb_log_files_in_group = 2
innodb_log_file_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
# 2G这个值配置低的话建议改小即可
innodb_buffer_pool_size = 2G
# LOGGING #
log-error=/usr/local/mysql/log/error.log
general_log=1
general_log_file=/usr/local/mysql/log/mysql.log
slow_query_log=1
slow_query_log_file=/usr/local/mysql/log/slowquery.log
log-output=FILE
# 避免MySQL的外部锁定，减少出错几率增强稳定性 #
skip-external-locking
# 禁止sql读取本地文件 #
local-infile=0
5.将mysql的库文件路径加入系统的库文件搜索路径中
方法一：直接做软链接
# ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
方法二：利用ldconfig导入系统库（推荐）
# echo "/usr/local/mysql/lib" >> /etc/ld.so.conf.d/mysql.conf
# ldconfig
6.输出mysql的头文件到系统头文件
# ln -s /usr/local/mysql/include/mysql /usr/include/mysql
7.进入安装路径,初始化配置脚本
# cd /usr/local/mysql
# scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
8.复制mysql启动脚本到系统服务目录
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
9.系统启动项相关配置
# chkconfig --add mysqld #添加开机启动服务
# chkconfig --level 35 mysqld on #设置mysql启动
10.启动mysql
# service mysqld start
注：编译时若socket路径自定义为/var/lib/mysql/mysql.sock，这里需要创建一个mysql接口的软链接，防止登陆后台或安装论坛报错.
