Advertisement
rez0n

my.cnf for Vesta on DigitalOcean

Sep 8th, 2013
1,356
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.94 KB | None | 0 0
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. user=mysql
  5. symbolic-links=0
  6. #max_connections=40
  7. #max_user_connections=20
  8. wait_timeout=10
  9. interactive_timeout=50
  10. long_query_time=5
  11. log-queries-not-using-indexes
  12. log-slow-queries=/var/log/mysql/log-slow-queries.log
  13.  
  14. key_buffer=32M
  15. myisam_sort_buffer_size=64M
  16. join_buffer_size=16M
  17. read_buffer_size=1M
  18. sort_buffer_size=2M
  19. table_cache=1024
  20. thread_cache_size=256
  21. thread_stack=192K
  22. interactive_timeout=25
  23. connect_timeout=5
  24. max_allowed_packet=16M
  25. max_connect_errors=1000
  26. query_cache_limit=8M
  27. query_cache_size=4M
  28. query_cache_type=1
  29. tmp_table_size=96M
  30.  
  31. innodb_buffer_pool_size=16M
  32. max_heap_table_size=32M
  33. tmpdir = /var/shm/mysql
  34. max_binlog_size=32M
  35.  
  36. innodb_use_native_aio = 1
  37. innodb_file_per_table
  38.  
  39. [mysqld_safe]
  40. log-error=/var/log/mysqld.log
  41. pid-file=/var/run/mysqld/mysqld.pid
  42.  
  43. [mysqldump]
  44. quick
  45. quote-names
  46. max_allowed_packet=16M
  47. default-character-set=utf8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement