my-large.cnf 815 B

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