daily pastebin goal
25%
SHARE
TWEET

Untitled

a guest Feb 22nd, 2018 37 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
  2. # Configuration name dbserver generated for @plazsoft.com at 2017-01-14 18:20:14
  3.  
  4. [mysql]
  5.  
  6. # CLIENT #
  7. port                           = 3306
  8. socket                         = /tmp/mysql.sock
  9.  
  10. [mysqld]
  11.  
  12. # GENERAL #
  13. user                           = mysql
  14. default-storage-engine         = InnoDB
  15. socket                         = /tmp/mysql.sock
  16. pid-file                       = C:/Program Files/MariaDB 10.1/data/mysql.pid
  17.  
  18. # MyISAM #
  19. key-buffer-size                = 32M
  20. myisam-recover                 = FORCE,BACKUP
  21.  
  22. # SAFETY #
  23. max-allowed-packet             = 16M
  24. max-connect-errors             = 1000000
  25. skip-name-resolve
  26. sql-mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
  27. sysdate-is-now                 = 1
  28. innodb                         = FORCE
  29.  
  30. # DATA STORAGE #
  31. datadir                        = C:/Program Files/MariaDB 10.1/data
  32.  
  33. # BINARY LOGGING #
  34. log-bin                        = mysql-bin
  35. expire-logs-days               = 14
  36. sync-binlog                    = 1
  37.  
  38. # CACHES AND LIMITS #
  39. tmp-table-size                 = 32M
  40. max-heap-table-size            = 32M
  41. query-cache-type               = 2
  42. query-cache-size               = 128M
  43. max-connections                = 500
  44. thread-cache-size              = 50
  45. open-files-limit               = 65535
  46. table-definition-cache         = 1024
  47. table-open-cache               = 256
  48.  
  49. # INNODB #
  50. innodb-log-files-in-group      = 2
  51. innodb-log-file-size           = 512M
  52. innodb-flush-log-at-trx-commit = 1
  53. innodb-file-per-table          = 1
  54. innodb-buffer-pool-size        = 2G
  55.  
  56. # LOGGING #
  57. log-error                      = C:/Program Files/MariaDB 10.1/data/mysql-error.log
  58. log-queries-not-using-indexes  = 1
  59. slow-query-log                 = 1
  60. slow-query-log-file            = C:/Program Files/MariaDB 10.1/data/mysql-slow.log
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top