my.cnf 941 B

12345678910111213141516171819202122232425262728293031
  1. [mysqld]
  2. character-set-client-handshake = FALSE
  3. character-set-server = utf8mb4
  4. collation-server = utf8mb4_unicode_ci
  5. #innodb_file_per_table = TRUE
  6. #innodb_file_format = barracuda
  7. #innodb_large_prefix = TRUE
  8. #sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  9. max_allowed_packet = 192M
  10. max-connections = 500
  11. innodb-strict-mode = 0
  12. innodb_buffer_pool_size = 96M
  13. key_buffer = 16M
  14. thread_cache_size = 8
  15. query_cache_type = 0
  16. query_cache_size = 0
  17. sort_buffer_size = 12M
  18. read_rnd_buffer_size = 2M
  19. tmp_table_size = 48M
  20. max_heap_table_size = 48M
  21. thread_stack = 128K
  22. skip-host-cache
  23. skip-name-resolve
  24. log-warnings = 0
  25. event_scheduler = 1
  26. [client]
  27. default-character-set = utf8mb4
  28. [mysql]
  29. default-character-set = utf8mb4