my-small.cnf 671 B

1234567891011121314151617181920212223242526272829303132333435
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. symbolic-links=0
  5. skip-external-locking
  6. key_buffer_size = 16K
  7. max_allowed_packet = 1M
  8. table_open_cache = 4
  9. sort_buffer_size = 64K
  10. read_buffer_size = 256K
  11. read_rnd_buffer_size = 256K
  12. net_buffer_length = 2K
  13. thread_stack = 240K
  14. #innodb_use_native_aio = 0
  15. innodb_file_per_table
  16. max_connections=30
  17. max_user_connections=20
  18. wait_timeout=10
  19. interactive_timeout=50
  20. long_query_time=5
  21. #slow_query_log=1
  22. #slow_query_log_file=/var/log/mysql-slow-queries.log
  23. [mysqld_safe]
  24. log-error=/var/log/mysqld.log
  25. pid-file=/var/run/mysqld/mysqld.pid
  26. #
  27. # include all files from the config directory
  28. #
  29. !includedir /etc/my.cnf.d