Advertisement
AhmadFazliIsmail

/etc/my.cnf.d/server.cnf

Nov 19th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. # SAFETY #
  2. max-allowed-packet = 128M
  3. max-connect-errors = 1000000
  4. #skip-name-resolve
  5. sysdate-is-now = 1
  6. innodb = FORCE
  7. innodb-strict-mode = 1
  8.  
  9. # CACHES AND LIMITS #
  10. tmp-table-size = 32M
  11. max-heap-table-size = 32M
  12. query-cache-type = 0
  13. query-cache-size = 0
  14. max-connections = 15000
  15. thread-cache-size = 50
  16. open-files-limit = 65535
  17. table-definition-cache = 1024
  18. table-open-cache = 2048
  19.  
  20. # INNODB #
  21. innodb-flush-method = O_DIRECT
  22. innodb-log-files-in-group = 2
  23. #innodb-log-file-size = 128M
  24. innodb-flush-log-at-trx-commit = 2
  25. innodb-file-per-table = 1
  26. #innodb-buffer-pool-size = 1456M
  27. innodb_fast_shutdown = 0
  28. innodb_use_native_aio = 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement