centos7安装mysql5.6
编译安装
- 安装环境准备
yum install gcc gcc-c++ cmake ncurses-devel bison
- 下载源码包
cd /data/tools
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.40.tar.gz
tar xf mysql-5.6.40.tar.gz
3.安装
useradd -s /sbin/nologin mysql
cd mysql-5.6.40
cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/data/server/mysql5.6 -DINSTALL_DATADIR=/data/server/mysql5.6/data -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
make
make install
4.初始化数据库
cd server/
ln -s mysql5.6/ mysql
chown -R mysql:mysql /data/server/mysql5.6/data
cp /data/server/mysql5.6/support-files/my-default.cnf /etc/my.cnf
5.配置环境变量
vim /etc/profile
PATH=/data/server/mysql/bin/:$PATH
source /etc/profile
#配置文件
6.配置文件
vim /etc/my.cnf
basedir=/data/server/mysql5.6
datadir=/data/server/mysql5.6/data
7.配置启动
cp /data/server/mysql5.6/support-files/mysql.server /etc/init.d/mysqld
chmod a+x /etc/init.d/mysqld
service mysqld restart
8.更新密码
mysqladmin -uroot password '123456'
配置my.cnf文件
datadir = /data/server/mysql5.6/data
basedir=/data/server/mysql5.6
socket = /data/server/mysql5.6/data/mysql.sock
skip-external-locking
max_allowed_packet = 512M
table_open_cache = 1024M
sort_buffer_size = 1024M
read_buffer_size = 1024M
read_rnd_buffer_size = 1024M
innodb_file_per_table =1
innodb_status_file =1
innodb_additional_mem_pool_size =512M
innodb_buffer_pool_size =6000M #最大内存的70%~80%
innodb_flush_method =O_DIRECT
innodb_support_xa =0
innodb_log_file_size =64M
innodb_log_buffer_size =32M
innodb_flush_log_at_trx_commit=2
thread_cache_size=6 #CPU核数*2
thread_concurrency=6 #CPU核数*2
query_cache_size=512M
join_buffer_size=128M
key_buffer=1024M
key_buffer_size=2048M
