Mysql系统变量系列之（五）路径相关的变量

最新推荐文章于 2022-05-09 16:37:53 发布

weixin_44260058

最新推荐文章于 2022-05-09 16:37:53 发布

阅读量180

点赞数

分类专栏： Mysql

本文链接：https://blog.youkuaiyun.com/weixin_44260058/article/details/104310119

版权

Mysql 专栏收录该内容

9 篇文章

订阅专栏

[mysqld]

############### PATH ##############
basedir = /usr/

datadir = /var/lib/mysql //mysql的数据存储目录
#innodb_data_home_dir = /opt/mysql/data
#innodb_log_group_home_dir = /opt/mysql/data
#innodb_undo_directory = /opt/mysql/data

log_error = /var/log/mysqld.log //mysql的错误日志文件
#general_log_file = /opt/mysql/log/general.log
slow_query_log_file = /var/log/mysql_slow.log //mysql的慢查询日志文件
log_bin = mysql-bin //开启mysql的binary log功能
#log_bin_index = /opt/mysql/log/mysql-bin.index
#relay_log = /opt/mysql/log/relay-log //开启mysql的中继日志功能
#relay_log_index = /opt/mysql/log/relay-log.index

#tmpdir = /opt/mysql/tmp
socket = /var/lib/mysql/mysql.sock //mysql的unix socket路径
pid_file = /var/run/mysqld/mysqld.pid //mysql进程先关的pid文件信息