---检查依赖包
rpm -qa libaio
---检查mysql是否预安装
rpm -qa msyql
自定义mysql安装目录：
比如 /monitor/,将安装包上传到该目录下;
##root 用户
groupadd mysql
useradd -r -g mysql mysql
mkdir /monitor/
cd /monitor/
tar zxvf mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.31-linux-glibc2.5-x86_64 mysql
chown -R mysql:mysql ./mysql
mv /etc/my.cnf /etc/my.cnf.bak
touch /etc/my.cnf
cat > /etc/my.cnf << eof
[client]
socket = /tmp/mysql.sock
default-character-set=utf8
[mysqld]
innodb_buffer_pool_size = 300M
basedir = /monitor/mysql/
datadir = /monitor/mysql/data
port = 3306
back_log = 100
socket = /tmp/mysql.sock
# 默认innodb存储引擎, 默认utf8字符集
default-storage-engine = INNODB
#>=5.5
character-set-server=utf8
# for 5.1 default-character-set=utf8
language = /12c/mysql/mysql/share/english
eof
####################################################
#####优化配置参数，需要根据服务器配置进行调整
####################################################
cat > /etc/my.cnf << eof
[client]
socket = /tmp/mysql.sock
default-character-set=utf8
[mysqld]
innodb_buffer_pool_size = 300M
basedir = /monitor/mysql
datadir = /monitor/mysql/data
port = 3306
back_log = 100
socket = /tmp/mysql.sock
# 默认innodb存储引擎, 默认utf8字符集
default-storage-engine = INNODB
character-set-server=utf8
language = /12c/mysql/mysql/share/english
# 文件系统中小写表名，避免兼容性问题
lower_case_table_names=1
# 不解析dns，忽略外部锁
skip-name-resolve
skip-external-locking
# table and thread cache
table_open_cache = 512
table_definition_cache = 128
thread_cache_size = 128
#事务隔离级别
transaction-isolation = READ-COMMITTED
max_heap_table_size = 32M
# max_length_for_sort_data 避免再次回表获得数据，使用优化过的排序算法
max_length_for_sort_data = 16k
#最大连接数
max_connections=2000
# 加大该次数，以免is blocked的报错
max_connect_errors = 1000000
max_allowed_packet = 2000M
################################ per thread memory ################################
thread_stack = 512k
net_buffer_length = 8K
sort_buffer_size = 2M
join_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 512k
# 最大内存临时表大小
tmp_table_size = 32M
binlog_cache_size = 2M
################################ innodb parameter ################################
# innodb 独立表空间
innodb_file_per_table
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir=/home/akira/data/mysqldata3306
innodb_data_file_path=ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir=/home/akira/data/mysqldata3306
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 2048M
#innodb_additional_mem_pool_size = 20M
#保障innodb tx log #innodb_flush_log_at_trx_commit = 1
# 我们这里丢失一些数据没有关系
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
# 在innodb lru list 先呆一秒再放到lru头
innodb_old_blocks_time=1000
# 取消二阶段事务
innodb_support_xa = OFF
# O_DIRECT 刷新
innodb_flush_method=O_DIRECT
innodb_rollback_on_timeout = 1
innodb_io_capacity = 400
innodb_change_buffering=inserts
innodb_use_native_aio = 1
innodb_strict_mode = 1
innodb_purge_threads=1
innodb_read_io_threads = 8
innodb_write_io_threads = 8
eof
########################################################################################################
####################################################
---初始化数据库
---启动mysql 数据库
# Next command is optional
# 开机自启动mysql服务报告
cp support-files/mysql.server /etc/init.d/mysql.server
cp /etc/init.d/mysql.server /etc/init.d/mysqld56
chkconfig --add mysqld56
chkconfig --level 2345 mysqld56 on
service mysqld56 start
*******************************
***problem solvetion
*******************************
Mysql 5.6 Can't find messagefile '/usr/share/mysql/errmsg.sys'解决方法
(1)将源码包里面的sql/share/english/errmsg.sys复制到/usr/share/mysql/errmsg.sys
(2) my.cnf 添加 language = /12c/mysql/mysql/share/english