比较全而标准的mysql配置
来源:互联网 发布:js分页代码首页尾页 编辑:程序博客网 时间:2024/04/30 01:35
port = 3311
socket = /data/app/run/mysql-3311.sock
[mysqld]
port = 3311
socket = /data/app/run/mysql-3311.sock
skip-external-locking
skip-name-resolve
key_buffer_size = 512M
max_allowed_packet = 16M
table_open_cache = 2048
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 64
query_cache_size = 64M
max_connections = 8192
tmp_table_size = 256M
back_log = 512
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size = 4096M
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_log_file_size = 2G
innodb_log_buffer_size = 16M
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
datadir = /data/app/db/mysql-3311
explicit_defaults_for_timestamp
default-time-zone = Asia/Shanghai
slow-query-log
slow-query-log-file = /data/app/db/mysql-3311/slow.log
long_query_time = 0.1
log_queries_not_using_indexes
log-bin = mysql-bin
expire_logs_days = 3
server_id = 2
relay-log = mysql-slave-relay-bin
replicate-ignore-db = mysql
replicate-ignore-db = performance_schema
replicate-ignore-db = sys
master-info-repository = table
relay-log-info-repository = table
relay-log-recovery = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
prompt = "\u@\h:\d > "
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit = 8192
pid-file = /data/app/run/mysql-3311.pid
log-error = /data/app/db/mysql-3311/error.log
具体各参数具体作用,可以到这里
https://dev.mysql.com/doc/refman/5.6/en/server-options.html
查询,或者后续补齐
- 比较全而标准的mysql配置
- 比较标准的sqlMap配置
- 比较全的MySql命令
- 比较全的log4j 配置
- vsftp配置(比较全的)转载
- dns bind 配置, 比较全的
- 比较全的,可用的tomcat 连接池的配置
- 感觉比较全的 linux(CentOS) 配置网卡的 手册
- 比较全的mysql错误代码和消息对照表
- 比较全的mysql错误代码和消息对照表
- 一个比较全的VIM配置和tips网站
- 一个配置比较全的log4j.xml文件
- Oracle左(外)、右(外)、全(外)、(内)连接语法与SQL标准的比较
- MySQL的Grant命令 — 这个比较全,比较细致,记录下来,以备后用
- JSON 的标准:双引号而非单引号!
- 一个简单而标准的PL/SQL
- 一个配置比较全的log4j.xml文件,配置的正确性已在项目中验证。
- DOM4J 全而好的文章
- tab切换echarts无法正常显示
- 【C++】实现复数类
- python中的str()和repr()
- python二进制协议结构信息分析
- 【机房管理】操作关系整理
- 比较全而标准的mysql配置
- 开源许可协议
- 代理服务器
- Spring MVC 零配置 / Spring MVC JavaConfig
- 知名互联网公司系统架构图[第3期]
- 如何正确处理java interrupte
- DFS:110. Balanced Binary Tree
- react-native 调用原生方法
- Cannot find module 'express'