yum安装- y centos-release-scl devtoolset-4-gcc-c + + devtoolset-4-gcc cmake openssl-devel野牛git gmock ncurses ncurses - * autoconf
groupadd mysql,,useradd - r - g mysql mysql
wget http://mirror.cnop.net/alisql/AliSQL-5.6.32.zip,,解压缩AliSQL-5.6.32。邮政,,cd AliSQL-mastersci启用devtoolset-4 bash
mkdir source_downloads,,cd source_downloads,,wget http://mirror.cnop.net/gmock/gmock-1.6.0.zip,,cd . .
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/地方/alisql \
-DMYSQL_UNIX_ADDR=/usr/地方/alisql/mysql。袜子\
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/usr/地方/alisql/数据\
-DMYSQL_TCP_PORT=3306 \
-DENABLE_DOWNLOADS=1
让
让安装
乔恩- r mysql。mysql/usr/local/alisql/
回声从来没有比;启用/sys/kernel/mm/transparent_hugepage/
chmod + x。/脚本/mysql_install_db
/脚本/mysql_install_db ——用户=mysql ——basedir=/usr/地方/alisql datadir=/usr/地方/alisql/数据
[客户]
port =3306
socket =/tmp/mysql。袜子
(mysqld)
=3306港
套接字=/tmp/mysql。袜子
datadir=/usr/local/alisql/data
skip-external-locking
key_buffer_size=16 m
table_open_cache max_allowed_packet=10米=64
sort_buffer_size=512 k
net_buffer_length=8 k
read_buffer_size=256 k
read_rnd_buffer_size=512 k
myisam_sort_buffer_size=8 m
thread_cache_size=8
query_cache_size=8 m
tmp_table_size=16 m
max_connections=500
max_connect_errors=100
open_files_limit=65535
log-bin=mysql-bin
binlog_format=
混合服务器id=1
expire_logs_days=10
default_storage_engine=InnoDB
innodb_file_per_table=1
innodb_data_home_dir=/usr/local/alisql/data
innodb_data_file_path=ibdata1:10M: autoextend
innodb_log_group_home_dir=,通过innodb_buffer_pool_size=16 m/usr/local/alisql/data
innodb_log_file_size innodb_additional_mem_pool_size=2米=5 m
innodb_log_buffer_size=8 m
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
cp 支持文件/mysql.server /etc/init.d/mysqld
路径=/usr/地方/alisql/bin:/usr/地方/alisql/lib:美元路径
出口路径源/etc/profile
ln - s/usr/local/alisql/bin/mysql工作
chmod + x/etc/init.d/mysqld
服务mysqld开始
chkconfig——35级mysqld alt=" alisql的安装环境变量配置“>
mysqladmin -uroot -p 密码123456,,,
