数据库日志配置文件

来源:互联网 发布:风险概率影响矩阵案例 编辑:程序博客网 时间:2024/06/05 04:23
[root@ovp-5420-002 log]# cat /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used (fedora >= 15).# If you need to run mysqld under a different user or group,# customize your systemd unit file for mysqld according to the# instructions in http://fedoraproject.org/wiki/Systemduser=mysql# Semisynchronous Replication# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html# uncomment next line on MASTER;plugin-load=rpl_semi_sync_master=semisync_master.so# uncomment next line on SLAVE;plugin-load=rpl_semi_sync_slave=semisync_slave.so# Others options for Semisynchronous Replication;rpl_semi_sync_master_enabled=1;rpl_semi_sync_master_timeout=10;rpl_semi_sync_slave_enabled=1# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html;performance_schemaslow_query_log = 1slow_query_log_file = /var/log/mysqlslow.log[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

0 0
原创粉丝点击