Guest User

Untitled

a guest
Dec 2nd, 2019
143
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. bind-address=0.0.0.0
  3. datadir=/var/lib/mysql
  4. socket=/var/run/mysqld/mysql.sock
  5. tmpdir=/mnt/tmpfs
  6. max_heap_table_size=1280M
  7. tmp_table_size=1280M
  8. max_allowed_packet=128M
  9. thread_stack=512K
  10. max-connect-errors=10000
  11. max_connections=300
  12. default-storage-engine=innodb
  13. symbolic-links=1
  14. transaction-isolation=READ-COMMITTED
  15. slow_query_log = ON
  16. long_query_time=5
  17. slow_query_log_file = /var/log/mariadb10.2/mysql-slow.log
  18. #######################################
  19. innodb_file_per_table=1
  20. innodb_log_file_size = 5G
  21. innodb_log_buffer_size = 4M
  22. innodb_flush_log_at_trx_commit=2
  23. innodb_flush_method=O_DIRECT
  24. innodb_io_capacity = 3000
  25. innodb_io_capacity_max = 6000
  26. innodb_strict_mode=OFF
  27. #######################################
  28. interactive_timeout=60
  29. wait_timeout=20
  30. connect_timeout=20
  31. #######################################
  32. ###GLOBAL
  33. table_cache = 4096
  34. table_definition_cache = 4096
  35. table_cache=512
  36. thread_cache_size=128
  37. table_open_cache=4000
  38. query_cache_size = 128M
  39. query_cache_type=1
  40. query_cache_limit=4M
  41. innodb_buffer_pool_size=35G
  42. key_buffer_size=2G
  43. #######################################
  44. myisam_sort_buffer_size=128M
  45. innodb_buffer_pool_instances = 37
  46. join_buffer_size=128M
  47. read_buffer_size = 4M
  48. sort_buffer_size = 4M
  49. read_rnd_buffer_size = 4M
  50. #######################################
  51. [mysqld_safe]
  52. log-error=/var/log/mysqld.log
  53. [mysqld]
  54. collation-server=utf8_general_ci
  55. init-connect='SET NAMES utf8'
  56. character-set-server=utf8
  57. [client]
  58. default-character-set=utf8
  59. socket=/var/run/mysqld/mysql.sock
  60. [mysql]
  61. default-character-set=utf8
RAW Paste Data