生产环境Linux二进制安装配置MySQL

　　<人力资源/> 　　

一、环境检查
rpm qa | grep libaio #如果没有安装libaio则需要安装。
df - h
山/dev/sr0/mnt
二,安装过程
1)上传安装程序
通过FTP/SFTP上传安装包
2)创建创用户,组,创建目录
groupadd mysql
useradd mysql - r - g - s/bin/false mysql
mkdir - p/mysql/数据/3306/
这里的3306是mysql默认端口号,/mysql/数据目录mysql的安装目录,
/mysql/数据/3306/数据是mysql数据目录。
mkdir - p/mysql/日志/3306

3)解压安装程序包
cd/mysql/app
焦油zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar。广州
ln - s/mysql/app/mysql-5.7.20-linux-glibc2.12-x86_64.tar。广州/mysql/app/mysql
4)修改权限
乔恩- r mysql: mysql/mysql

5)配置环境变量
第六~/. bash_profile
=$ PATH:/mysql/app/mysql/bin: $ HOME/bin

测试
[root@db1 ~] # mysql——版本
卸载系统自带的mysql
百胜将mysql
[root@db1 ~] # mysql
/mysql/app/mysql/bin/mysql
6)准备参数文件
mysql默认读取此路径的配/etc/my . cnf中所做置文件。
cd/mysql/数据/3306/
/mysql/日志/3306/itpuxdb-error联系。犯错
乔恩- r mysql: mysql/mysql/日志/3306/itpuxdb-error.err

vi/mysql/数据/3306

//my . cnf中所做　　

[客户]
=3306港
套接字=/mysql/数据/3306/mysql.sock

　　(mysql)

no-beep
提示符=癨 u@db1 \ R: \ m: \ s (\ d)比;“
# no-auto-rehash
auto-rehash
default-character-set=utf8

(mysqld) # # # # # # # # # # # # # # # #基本设置
服务器id=3306
端口=3306
用户=mysql
bind_address=192.168.1.51
basedir=/mysql/app/mysql
datadir=/mysql/数据/3306/
套接字=/mysql/数据/3306/mysql.sock
pid文件=/mysql/数据/3306/mysql。pid
character-set-server=utf8
skip-character-set-client-handshake=1
autocommit # skip_name_resolve=1=0

max_connections=800
max_connect_errors=1000
default-storage-engine=INNODB
transaction_isolation=读取提交
explicit_defaults_for_timestamp=1
sort_buffer_size=32 m

tmp_table_size join_buffer_size=128=72
max_allowed_packet=16 m
sql_mode=癝TRICT_TRANS_TABLES, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER"
interactive_timeout=1800
wait_timeout=1800
read_buffer_size=16 m
read_rnd_buffer_size=32 m

query_cache_type=1

table_open_cache query_cache_size=1米=2000
thread_cache_size=768
myisam_max_sort_file_size=10 g

key_buffer_size myisam_sort_buffer_size=135=32 m
read_buffer_size=8 m

read_rnd_buffer_size=4米　　

back_log=1024
# flush_time=0
open_files_limit=65536
table_definition_cache=1400
# binlog_row_event_max_size=8 k
# sync_master_info=10000
# sync_relay_log # sync_relay_log_info=10000=10000

# # # # # # # # # # # # # # # #日志设置
日志输出文件
general_log==0
general_log_file=/mysql/日志/3306/db1。犯错
在
slow_query_log_file slow_query_log==/mysql/日志/3306/db1.err
long_query_time=10
日志错误=/mysql/日志/3306/db1-error.err

log_queries_not_using_indexes=1
log_slow_admin_statements=1
log_slow_slave_statements=1
log_throttle_queries_not_using_indexes=10
expire_logs_days=90
min_examined_row_limit=100
# log_bin=?日志/bin_log/binlog"

# # # # # # # # # # # # # # # #复制设置
# master_info_repository=表

# # relay_log_info_repository=表log_bin=本。日志
# sync_binlog=1 # gtid_mode
=
# enforce_gtid_consistency=1
# log_slave_updates

# # binlog_format=行relay_log=继电器。日志
# relay_log_recovery=1
# binlog_gtid_simple_recovery=1
# slave_skip_errors=ddl_exist_errors

# # # # # # # # innodb设置# # # # # # # #

innodb_io_capacity=4000
innodb_io_capacity_max通过innodb_buffer_pool_size=500=8000

innodb_buffer_pool_instances=8
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_at_shutdown=1
innodb_lru_scan_depth=2000
innodb_lock_wait_timeout=5
# innodb_flush_method=O_DIRECT

innodb_log_files_in_group innodb_log_file_size=200=2
innodb_log_buffer_size=16 m

innodb_undo_logs=128
innodb_undo_tablespaces=3
innodb_undo_log_truncate=1
innodb_max_undo_log_size=2 g

innodb_flush_neighbors=1
innodb_purge_threads=4
innodb_large_prefix=1
innodb_thread_concurrency=64
innodb_print_all_deadlocks=1