Advertisement
ianhuet

Untitled

Nov 19th, 2018
306
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. [mysqld]
  2. bind-address = ::ffff:127.0.0.1
  3. local-infile=0
  4. datadir=/var/lib/mysql
  5. socket=/var/lib/mysql/mysql.sock
  6.  
  7. # Added 07 Nov 2018
  8. # https://support.plesk.com/hc/en-us/articles/213401729-Slow-performance-of-the-MySQL-on-Plesk-server
  9. innodb_buffer_pool_size=756M
  10. query_cache_size=64M
  11.  
  12. # Disabling symbolic-links is recommended to prevent assorted security risks
  13. symbolic-links=0
  14.  
  15. # Settings user and group are ignored when systemd is used.
  16. # If you need to run mysqld under a different user or group,
  17. # customize your systemd unit file for mariadb according to the
  18. # instructions in http://fedoraproject.org/wiki/Systemd
  19.  
  20. [mysqld_safe]
  21. log-error=/var/log/mariadb/mariadb.log
  22. pid-file=/var/run/mariadb/mariadb.pid
  23.  
  24. slow_query_log = 1
  25. log-slow-queries = /var/log/mariadb/mariadb-slow.log
  26. long_query_time = 5s
  27.  
  28. #
  29. # include all files from the config directory
  30. #
  31. !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement