mysql配置文件my.cnf
来源:互联网 发布:商标域名抢注案例 编辑:程序博客网 时间:2024/06/09 23:56
[client]
port = 3306
socket = /usr/local/mysql/mysql.sock
default-character-set = utf8
[mysql]
no-auto-rehash
default-character-set = utf8
[mysqld]
socket = /usr/local/mysql/mysql.sock
character-set-server = utf8
basedir = /usr/local/mysql
max_allowed_packet = 32M
datadir = /data/mysql/data
explicit_defaults_for_timestamp = true
skip-ssl
#secure-file-priv = /home/book/shell/mytools/practice
lower_case_table_names = 1
back_log = 300
max_connections = 3000
max_connect_errors = 100
table_open_cache = 4096
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 16M
join_buffer_size = 16M
thread_cache_size = 16
query_cache_size = 128M
ft_min_word_len = 8
thread_stack = 512K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 128M
max_heap_table_size = 128M
#binlog
log-bin = mysql-bin
binlog_format = mixed
server-id = 1
read-only = 0
#binlog-do-db = hello
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
auto-increment-increment = 10
auto-increment-offset = 1
#####slow query parameters#######
long_query_time = 6
slow_query_log
slow_query_log_file = /data/mysql/log/slow.log
[mysqldump]
quick
max_allowed_packet = 32M
[mysqld_safe]
open-files-limit = 8192
port = 3306
socket = /usr/local/mysql/mysql.sock
default-character-set = utf8
[mysql]
no-auto-rehash
default-character-set = utf8
[mysqld]
socket = /usr/local/mysql/mysql.sock
character-set-server = utf8
basedir = /usr/local/mysql
max_allowed_packet = 32M
datadir = /data/mysql/data
explicit_defaults_for_timestamp = true
skip-ssl
#secure-file-priv = /home/book/shell/mytools/practice
lower_case_table_names = 1
back_log = 300
max_connections = 3000
max_connect_errors = 100
table_open_cache = 4096
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 16M
join_buffer_size = 16M
thread_cache_size = 16
query_cache_size = 128M
ft_min_word_len = 8
thread_stack = 512K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 128M
max_heap_table_size = 128M
#binlog
log-bin = mysql-bin
binlog_format = mixed
server-id = 1
read-only = 0
#binlog-do-db = hello
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
auto-increment-increment = 10
auto-increment-offset = 1
#####slow query parameters#######
long_query_time = 6
slow_query_log
slow_query_log_file = /data/mysql/log/slow.log
[mysqldump]
quick
max_allowed_packet = 32M
[mysqld_safe]
open-files-limit = 8192
log-error=/data/mysql/log/mysql_3306.err
0 0
- mysql 配置文件my.cnf
- mysql配置文件my.cnf
- mysql配置文件my.cnf设置
- MySQL配置文件my.cnf中文版
- MySQL配置文件my.cnf中文版
- MySQL配置文件my.cnf中文版
- Mysql配置文件my.cnf详解
- MySQL my.cnf 配置文件注释
- Mysql配置文件my.cnf详解
- MYSQL my.cnf配置文件详解
- MySQL配置文件my.cnf详解
- MySQL配置文件my.cnf中文版
- mysql配置文件my.cnf详解
- MySQL配置文件my.cnf优化
- [MySQL] 配置文件my.cnf详解
- MySQL配置文件my.cnf中文版
- MySQL配置文件my.cnf设置
- mysql配置文件my.cnf详解
- Web测试方法总结
- findViewById返回Null
- Redis协议说明
- 浏览器快捷使用方式——vimium
- javascript数据结构4-队列
- mysql配置文件my.cnf
- 缓存使用总结
- javascript数据结构4-队列2-基数排序
- 爬网站静态代码工具
- 大数据系列修炼-Scala课程84
- 【Android】Android开发之Activity的管理类,结束关闭指定的Activity,单例模式封装
- js中数组,对象 的相关操作
- javascript数据结构5-链表(包括循环链表 双向链表)
- 新浪天气api