Guest User

Untitled

a guest
Dec 2nd, 2019
139
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

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×