Advertisement
Guest User

Untitled

a guest
Oct 9th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement