SHARE
TWEET

Untitled

a guest Oct 9th, 2019 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # For advice on how to change settings please see
  2. # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
  3.  
  4. [mysqld]
  5. character-set-server=utf8mb4
  6. collation-server=utf8mb4_unicode_ci
  7. #
  8. # Remove leading # and set to the amount of RAM for the most important data
  9. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  10. # innodb_buffer_pool_size = 128M
  11. #
  12. # Remove leading # to turn on a very important data integrity option: logging
  13. # changes to the binary log between backups.
  14. # log_bin
  15. #
  16. # Remove leading # to set options mainly useful for reporting servers.
  17. # The server defaults are faster for transactions and fast SELECTs.
  18. # Adjust sizes as needed, experiment to find the optimal values.
  19. # join_buffer_size = 128M
  20. # sort_buffer_size = 2M
  21. # read_rnd_buffer_size = 2M
  22. datadir=/var/lib/mysql
  23. socket=/var/lib/mysql/mysql.sock
  24.  
  25. 111111 ===========>
  26. max_connections = 1000
  27.  
  28. default-time-zone = '+07:00'
  29.  
  30. # Disabling symbolic-links is recommended to prevent assorted security risks
  31. symbolic-links=0
  32.  
  33. sql_mode=''
  34. log-error=/var/log/mysqld.log
  35. pid-file=/var/run/mysqld/mysqld.pid
  36.  
  37. default-storage-engine = myisam
  38. #default-storage-engine = innodb
  39. read_only=0
  40.  
  41. ft_min_word_len = 1
  42.  
  43. #ngram_token_size=1
  44.  
  45. max_allowed_packet=100M
  46.  
  47. slow_query_log = 1
  48. slow_query_log_file = /var/log/mysql-slow.log
  49. long_query_time = 1
  50.  
  51.  
  52. [myisamchk]
  53. ft_min_word_len=1
  54.  
  55. [Service]
  56. 22222222 ===========>
  57. LimitNOFILE=2000
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