my.cnf 850 B

12345678910111213141516171819202122232425262728
  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. performance_schema = 0
  12. innodb-strict-mode = 0
  13. innodb_buffer_pool_size = 96M
  14. key_buffer = 16M
  15. thread_cache_size = 8
  16. query_cache_type = 0
  17. query_cache_size = 0
  18. thread_stack = 128K
  19. skip-host-cache
  20. skip-name-resolve
  21. log-warnings = 0
  22. event_scheduler = 1
  23. [client]
  24. default-character-set = utf8mb4
  25. [mysql]
  26. default-character-set = utf8mb4