Guest User

Untitled

a guest
Oct 20th, 2015
48
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. I have VPS with 17 500 MB RAM,free -m:
  2. # free -m
  3. total used free shared buffers cached
  4. Mem: 17500 10805 6694 0 0 5934
  5. -/+ buffers/cache: 4871 12628
  6. Swap: 1024 1024 0
  7.  
  8. /etc/my.cnf
  9.  
  10. max_connections=200
  11. max_user_connections=18
  12.  
  13. innodb_file_per_table=1
  14. local-infile=0
  15. max_allowed_packet=268435456
  16. open_files_limit=43762
  17. ft_min_word_len=3
  18.  
  19. # was not there, was default 8M
  20. key_buffer_size=1400
  21.  
  22. thread_cache_size=12
  23. max_connections=200
  24. innodb_buffer_pool_size=760M
  25. join_buffer_size=16M
  26.  
  27. #was not there, was default 128k
  28. read_buffer_size=16M
  29.  
  30. # was 512M
  31. query_cache_size=512M
  32. query_cache_limit=512M
  33. table_cache=6024
  34. table_open_cache=5000
  35. tmp_table_size=1024M
  36. max_heap_table_size=1024M
RAW Paste Data