MySQL二进制包安装简略过程
l 软件目录
[root@MASTER_03 ~]# mkdir -pv /data/software
[root@MASTER_03 ~]# cd /data/software/
[root@MASTER_03 mysql-5.6.28-linux-glibc2.5-x86_64]# tar xvf mysql-5.6.28-linux-glibc2.5-x86_64.tar.gz
l 软件下载
[root@MASTER_03 software]# wget http://120.198.244.50:9999/cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.28-linux-glibc2.5-x86_64.tar.gz
l 安装过程
[root@MASTER_03 ~]# groupadd mysql
[root@MASTER_03 ~]# useradd -g mysql -d /usr/local/mysql -s /sbin/nologin mysql
[root@MASTER_03 data]# mkdir -pv /opt/app/mysql
[root@MASTER_03 ~]# chown -R mysql.mysql /usr/local/mysql/
[root@MASTER_03 data]# chown -R mysql.mysql /opt/app/mysql/
[root@MASTER_03 data]# mkdir -pv /data/3306/{tmp,logs,data}
[root@MASTER_03 ~]# chown -R mysql.mysql /data/mysql
[root@MASTER_03 ~]# cd /data/software/
[root@MASTER_03 ~]# mv mysql-5.6.28-linux-glibc2.5-x86_64/* /opt/app/mysql/
[root@MASTER_03 ~]# cd /opt/app/mysql/
[root@MASTER_03 mysql]# ./scripts/mysql_install_db --basedir=/opt/app/mysql --datadir=/data/3306/data --user=mysql
[root@MASTER_03 mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@MASTER_03 mysql]# chmod +x /etc/init.d/mysqld
=============================my.cnf的配置=========================================================
[client]
port = 3306
socket = /data/3306/tmp/mysql.sock
# The MySQL server
[mysqld]
###base
explicit_defaults_for_timestamp=true
port = 3306
user = mysql
basedir = /opt/app/mysql
datadir = /data/3306/data
pid-file = /data/3306/tmp/mysql.pid
socket = /data/3306/tmp/mysql.sock
character_set_server = utf8
tmpdir = /dev/shm
server-id = 033306
skip_name_resolve = 1
skip_external_locking = 1
lower_case_table_names = 1
# logs
long_query_time = 1
slow_query_log = 1
slow_query_log_file = /data/3306/logs/slow.log
log_error = /data/3306/logs/error.log
# binlog
binlog_format = row
log_bin = /data/3306/logs/mysql-bin
binlog_cache_size = 8M
max_binlog_size = 1G
max_binlog_cache_size = 4G
expire_logs_days = 5
log_bin_trust_function_creators = 1
############ myisam
key_buffer_size = 64M
#bulk_insert_buffer_size = 32M
########## PGA
sort_buffer_size = 8M
read_buffer_size = 8M
join_buffer_size = 32M
read_rnd_buffer_size = 32M
query_cache_type = 0
query_cache_size = 0M
table_open_cache = 6144
table_definition_cache = 4096
open_files_limit = 65536
back_log = 512
max_connections = 1100
max_user_connections = 1000
max_connect_errors = 10000
max_allowed_packet = 128M
thread_cache_size = 64
thread_stack=192k
tmp_table_size=128M
max_heap_table_size=128M
# InnoDB
transaction_isolation = READ-COMMITTED
innodb_data_home_dir = /data/3306/data
innodb_log_group_home_dir = /data/3306/data
innodb_data_file_path = ibdata1:1G:autoextend
innodb_buffer_pool_size = 1G
innodb_buffer_pool_instances = 8
#innodb_additional_mem_pool_size = 16M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 64M
innodb_log_files_in_group = 3
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 10
innodb_sync_spin_loops = 40
innodb_max_dirty_pages_pct = 80
innodb_thread_concurrency = 0
innodb_thread_sleep_delay = 500
innodb_concurrency_tickets = 1000
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_read_io_threads = 20
innodb_write_io_threads = 20
innodb_io_capacity = 600
innodb_file_format = Barracuda
innodb_purge_threads=1
innodb_purge_batch_size = 32
innodb_old_blocks_pct=50
innodb_stats_on_metadata=0
#
optimizer_switch='mrr=on,mrr_cost_based=off,batched_key_access=on'
# wait
#wait_timeout = 28800
#interactive_timeout = 120
#connect_timeout = 20
#slave-net-timeout = 30
[mysqldump]
quick
max_allowed_packet = 128M
#myisam_max_sort_file_size = 10G
[mysql]
no-auto-rehash
max_allowed_packet = 128M
default_character_set = utf8
[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 512k
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
==================================/etc/init.d/mysqld中需要修改的2个地方=====================================
basedir=/opt/app/mysql
datadir=/data/3306/data
最新文章
- 使用 itext、flying-saucer 实现html转PDF(转)
- python模拟登陆知乎并爬取数据
- DBCC DROPCLEANBUFFERS失效了?
- DedeCMS学习
- [CareerCup] 17.7 English Phrase Describe Integer 英文单词表示数字
- [Effective JavaScript 笔记]第65条:不要在计算时阻塞事件队列
- [Java解惑]异常
- [转载] iptables配置实践
- <;meta http-equiv = ";X-UA-Compatible"; cotent = ";IE=edge,chrome=1";/>;
- 获取手机 id 与 ip
- Linux系统目录结构介绍
- 查看oracle数据库的连接数以及用户 (转:http://blog.itpub.net/24558279/viewspace-752293/)
- 【Android 应用开发】Android 网络编程 API笔记 - java.net 包相关 接口 api
- (三十三)Xcode项目的重要工程文件
- ES6解构过程添加一个默认值和赋值一个新的值
- you-get 下载视频
- Django-rest-framework 接口实现 限制:(Throttle)
- PHP 转义
- 软件工程(五)UML
- CMDB资产管理
热门文章
- 调用腾讯QQ启动
- lucene 加速索引建立速度
- 虚拟机安装Ubuntu 12.04 出现提示“Ubuntu is running in low-graphics mode?”
- 在Window系统中使用Redis缓存策略
- Html Table用JS导出excel格式问题 导出EXCEL后单元格里的000412341234会变成412341234 7-14 会变成 2018-7-14(7月14) 自定义格式 web利用table表格生成excel格式问题 js导出excel增加表头、mso-number-format定义数据格式 数字输出格式转换 mso-number-format:";\@";
- 数据库面试题.net
- set hive.exec.parallel
- RAD Studio XE5破解补丁及方法
- DM36x IPNC OSD显示中文 --- 基础知识篇
- >;/dev/null 2>;&;1的作用