linux mysql cnf_linux下mysql的配置文件my.cnf里的设置

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

# For advice on how to change settings please see

#

http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

#innodb

# Remove leading

# and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 4000M

innodb_additional_mem_pool_size=60M

innodb_data_home_dir=

innodb_date_file_path=ibdata1:20M:autoextend

innodb_log_group_home_dir=/var/log/innodb_log

innodb_log_files_in_group=2

innodb_log_file_size=30M

innodb_log_buffer_size=3M

innodb_doublewrite=ON

innodb_open_file=2000

innodb_file_per_table=ON

innodb_max_dirty_page_pct=50

back_log=80

interactive_timeout=3600

key_buffer_size=10M

max_allow_packet=40440

max_connections=200

max_tmp_tables=60

query_cache_size=10M

sor_buffer_size=10M

table_open_cache=2000

# Remove leading

# to turn on a very important data integrity option: logging

# changes to the binary log between backups.

#lob_bin

log_bin=ON

log_bin_basename=/var/lib/mysql/mysqld-bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

character_set_server=utf8

#init_connect='SET NAMES utf8'

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#general_log

general_log=ON

general_log_file=/var/lib/mysql/localhost.log

#slow_query_log

slow_query_log=ON

slow_query_log_file=/var/lib/mysql/localhost-slow.log

slow_launch_time=2

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值