Guest User

Untitled

a guest
May 26th, 2016
18
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2.  
  3. #tmpdir=/dev/shm
  4. tmpdir=/tmp/mysqltmp/
  5.  
  6. slow_query_log=1
  7. slow_query_log_file=/var/log/mysql/slow.log
  8. long_query_time=1
  9. #log_queries_not_using_indexes=1
  10.  
  11. max_connections=150
  12. max_user_connections=18
  13.  
  14. innodb_file_per_table=1
  15. local-infile=0
  16. max_allowed_packet=268435456
  17. open_files_limit=43762
  18. ft_min_word_len=3
  19.  
  20. # was not there, was default 8M
  21. key_buffer_size=1400
  22.  
  23. thread_cache_size=12
  24. max_connections=200
  25. innodb_buffer_pool_size=760M
  26. join_buffer_size=64M
  27. sort_buffer_size=64M
  28.  
  29. #was not there, was default 128k
  30. read_buffer_size=64M
  31.  
  32. # was 512M
  33. query_cache_size=512M
  34. query_cache_limit=512M
  35. table_cache=1024
  36. table_open_cache=1024
  37. tmp_table_size=512M
  38. max_heap_table_size=512M
  39.  
  40. default-storage-engine=MyISAM
  41. [myisamchk]
  42. ft_min_word_len=3
RAW Paste Data