MySQL5.5如何设置配置文件
这篇文章主要介绍了MySQL 5.5如何设置配置文件,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。
创新互联是一家从事企业网站建设、网站设计制作、网站制作、行业门户网站建设、网页设计制作的专业的建站公司,拥有经验丰富的网站建设工程师和网页设计人员,具备各种规模与类型网站建设的实力,在网站建设领域树立了自己独特的设计风格。自公司成立以来曾独立设计制作的站点上千家。
在MySQL数据库中,可以没有配置文件,在这种情况下,MySQL会安装编译时的默认参数设置启动实例
用以下命令查看,当MYSQL数据库实例启动时,它会在哪些位置查找配置文件
[root@localhost test]# mysql --help | grep my.cnf
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
MySQL里面有启动参数、系统参数,启动参数通过show variables无法查询到,可以在mysqld的选项中查到
例如关于二进制日志有Startup Options Used with Binary Logging、System Variables Used with Binary Logging两种参数
[root@localhost log]# mysqld --verbose --help > 02.txt
[root@localhost log]# vim 02.txt
..
--binlog-do-db=nameTells the master it should log updates for the specified
database, and exclude all others not explicitly
mentioned.
..
[root@localhost log]# vim /etc/my.cnf
..
# log
server-id = 10000
log-bin = /log/binlog/mysql-bin
binlog_format = MIXED
binlog-do-db = test
[root@localhost data]# vim /etc/my.cnf
[client]
port = 3306
socket=/mysql_data/70005/mysql.sock
# Mysql server
[mysqld]
port = 3306
user = mysql
socket=/mysql_data/70005/mysql.sock
pid-file = /mysql_data/70005/mysqld.pid
basedir = /software
datadir = /data
#tmpdir =
open_files_limit = 10240
max_connections = 500
max_connect_errors = 100000
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
wait_timeout = 100
# Cache
table_open_cache = 400
thread_cache_size = 300
# Buffer
max_allowed_packet = 256M
max_heap_table_size = 256M
net_buffer_length = 8K
sort_buffer_size = 4M
join_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
#query_cache_size = 32M
# Log
server-id = 1
log-bin = /log/binlog/mysql-bin
sync_binlog = 2
binlog_cache_size = 32M
max_binlog_cache_size = 512M
max_binlog_size = 512M
binlog_format = MIXED
#binlog_cache_use = 100
#binlog_cache_disk_use = 50
log_output = FILE
log_error = /log/err.log
slow_query_log = 1
slow_query_log_file = /log/slow_query.log
long_query_time = 10
log-short-format = 0
log_slow_admin_statements = 0
log_queries_not_using_indexes = 0
#log_throttle_queries_not_using_indexes = 0
log_slow_slave_statements = 0
general_log = 0
general_log_file = /log/general_query.log
# InnoDB
innodb_data_file_path = ibdata1:12M:autoextend:max:100G
#innodb_data_file_path = /ibdata/ibdata1:12M:autoextend:max:100G
innodb_data_home_dir = /ibdata
innodb_file_per_table = 1
innodb_log_group_home_dir = /log/innodb
#innodb_log_file_size = 256M
#innodb_log_files_in_group = 3
innodb_log_buffer_size = 8M
innodb_buffer_pool_size = 100M
# InnoDB undo __ Mysql 5.6 or higher
#innodb_undo_directory = /log/undo
#innodb_undo_tablespaces = 2
#innodb_undo_logs = 200
innodb_fast_shutdown = 1
innodb_flush_log_at_trx_commit = 1
innodb_buffer_pool_instances = 5
# MyISAM
#skip-external-locking
#key_buffer_size = 128M
#myisam_sort_buffer_size = 64M
# Character set
#character_set_server = gbk
#collation_server = gbk_bin
# Federated storage engine
federated
# Transaction
init_connect='SET autocommit=0'
[mysql]
no-auto-rehash
default-character-set = gbk
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
#key_buffer_size = 256M
#sort_buffer_size = 256M
#read_buffer = 2M
#write_buffer = 2M
[mysqlhotcopy]
#interactive-timeout
感谢你能够认真阅读完这篇文章,希望小编分享的“MySQL 5.5如何设置配置文件”这篇文章对大家有帮助,同时也希望大家多多支持创新互联,关注创新互联行业资讯频道,更多相关知识等着你来学习!
网站题目:MySQL5.5如何设置配置文件
文章起源:http://myzitong.com/article/ishgii.html