my-large.cnf 975 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. [client]
  2. port=3306
  3. socket=/run/mysqld/mysqld.sock
  4. default-character-set=utf8mb4
  5. [mysql]
  6. default-character-set=utf8mb4
  7. [mysqld_safe]
  8. socket=/run/mysqld/mysqld.sock
  9. [mysqld]
  10. user=mysql
  11. pid-file=/run/mysqld/mysqld.pid
  12. socket=/run/mysqld/mysqld.sock
  13. port=3306
  14. basedir=/usr
  15. datadir=/var/lib/mysql
  16. tmpdir=/tmp
  17. lc-messages-dir=/usr/share/mysql
  18. log_error=/var/log/mysql/error.log
  19. collation-server = utf8mb4_unicode_520_ci
  20. init-connect='SET NAMES utf8mb4'
  21. character-set-server = utf8mb4
  22. symbolic-links=0
  23. local-infile=0
  24. skip-external-locking
  25. key_buffer_size = 256M
  26. max_allowed_packet = 32M
  27. table_open_cache = 256
  28. sort_buffer_size = 1M
  29. read_buffer_size = 1M
  30. read_rnd_buffer_size = 4M
  31. myisam_sort_buffer_size = 64M
  32. thread_cache_size = 8
  33. query_cache_size= 16M
  34. #innodb_use_native_aio = 0
  35. innodb_file_per_table
  36. max_connections=200
  37. max_user_connections=50
  38. wait_timeout=10
  39. interactive_timeout=50
  40. long_query_time=5
  41. !includedir /etc/mysql/conf.d/
  42. !includedir /etc/mysql/mariadb.conf.d/