SHARE
TWEET

Untitled

a guest Aug 22nd, 2019 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [client]
  2. port            = 3306
  3. socket          = /var/run/mysqld/mysqld.sock
  4.  
  5. [mysqld_safe]
  6. socket          = /var/run/mysqld/mysqld.sock
  7. pid-file                = /var/run/mysqld/mysqld.pid
  8. nice            = -10
  9.  
  10. [mysqld]
  11. user            = mysql
  12. pid-file        = /var/run/mysqld/mysqld.pid
  13. socket          = /var/run/mysqld/mysqld.sock
  14. port            = 3306
  15. basedir         = /usr
  16. datadir         = /var/lib/mysql
  17. tmpdir          = /dev/shm
  18. lc-messages-dir     = /usr/share/mysql
  19. symbolic-links      = 0
  20. skip-external-locking
  21. skip-name-resolve
  22. explicit_defaults_for_timestamp
  23.  
  24. sql_mode        = NO_ENGINE_SUBSTITUTION
  25.  
  26. log-error               = /var/log/mysql/error.log
  27. slow_query_log_file     = /var/log/mysql/mysql-slow.log
  28. long_query_time     = 4
  29. slow_query_log      = 1
  30.  
  31. local-infile            = 0
  32. bind-address            = 196.52.8.11
  33.  
  34. key_buffer_size         = 128M
  35. sort_buffer_size    = 2M
  36. read_buffer_size    = 2M
  37. join_buffer_size        = 20M
  38. max_allowed_packet      = 400M
  39. open_files_limit        = 100000
  40. thread_stack            = 256K
  41. thread_cache_size       = 48
  42.  
  43. myisam-recover-options  = BACKUP
  44.  
  45. max_connections         = 5000
  46. max_user_connections    = 1000
  47. back_log        = 256
  48. max_connect_errors  = 9999999
  49. net-write-timeout   = 180
  50. net-read-timeout    = 90
  51. max-allowed-packet  = 64M
  52. open_files_limit    = 220000
  53.  
  54. table_open_cache        = 262000
  55. table_definition_cache  = 4096
  56.  
  57. query_cache_type = 0
  58. query_cache_size = 0
  59.  
  60. table_open_cache_instances = 128
  61.  
  62. expire_logs_days        = 30
  63. max_binlog_size         = 400M
  64.  
  65. tmp_table_size = 4G
  66. max_heap_table_size = 4G
  67. bulk_insert_buffer_size = 2G
  68.  
  69. innodb_buffer_pool_size=20G
  70. innodb_buffer_pool_instances=20
  71. innodb_read_io_threads=16
  72. innodb_write_io_threads=16
  73. innodb_log_file_size=3G
  74. innodb_log_buffer_size=12M
  75. innodb_flush_log_at_trx_commit=0
  76. innodb_thread_concurrency=0
  77. innodb_file_per_table=ON
  78. thread_pool_size=36
  79. innodb_flush_method = O_DIRECT
  80. innodb_open_files = 262000
  81. innodb_checksum_algorithm=crc32
  82. innodb_io_capacity=50000
  83. innodb_io_capacity_max=65000
  84. innodb_large_prefix     = true
  85. innodb_support_xa=ON
  86.  
  87. #
  88. # chroot = /var/lib/mysql/
  89. #
  90. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  91. #
  92. # ssl-ca=/etc/mysql/cacert.pem
  93. # ssl-cert=/etc/mysql/server-cert.pem
  94. # ssl-key=/etc/mysql/server-key.pem
  95.  
  96.  
  97. [mysqldump]
  98. quick
  99. quote-names
  100. max_allowed_packet      = 1200M
  101.  
  102. [mysql]
  103.  
  104. [isamchk]
  105. key_buffer              = 16M
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