Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- bind-address = ::ffff:127.0.0.1
- local-infile=0
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- # Added 07 Nov 2018
- # https://support.plesk.com/hc/en-us/articles/213401729-Slow-performance-of-the-MySQL-on-Plesk-server
- innodb_buffer_pool_size=756M
- query_cache_size=64M
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- # Settings user and group are ignored when systemd is used.
- # If you need to run mysqld under a different user or group,
- # customize your systemd unit file for mariadb according to the
- # instructions in http://fedoraproject.org/wiki/Systemd
- [mysqld_safe]
- log-error=/var/log/mariadb/mariadb.log
- pid-file=/var/run/mariadb/mariadb.pid
- slow_query_log = 1
- log-slow-queries = /var/log/mariadb/mariadb-slow.log
- long_query_time = 5s
- #
- # include all files from the config directory
- #
- !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement