my.cnf 1.0 KB

123456789101112131415161718192021222324252627282930313233343536
  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 = 550
  11. key_buffer_size = 0
  12. read_buffer_size = 192K
  13. sort_buffer_size = 2M
  14. innodb_buffer_pool_size = 24M
  15. read_rnd_buffer_size = 256K
  16. tmp_table_size = 24M
  17. performance_schema = 0
  18. innodb-strict-mode = 0
  19. thread_cache_size = 8
  20. query_cache_type = 0
  21. query_cache_size = 0
  22. max_heap_table_size = 48M
  23. thread_stack = 128K
  24. skip-host-cache
  25. skip-name-resolve
  26. log-warnings = 0
  27. event_scheduler = 1
  28. interactive_timeout = 3610
  29. wait_timeout = 3610
  30. [client]
  31. default-character-set = utf8mb4
  32. [mysql]
  33. default-character-set = utf8mb4