Guest User

Untitled

a guest
Aug 16th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. [mysqld]
  2. query_cache_type = 1
  3. query_cache_limit = 1M
  4. query_cache_size = 64M
  5. port = 3306
  6. socket = /var/lib/mysql/mysql.sock
  7. skip-locking
  8. key_buffer = 384M
  9. max_allowed_packet = 2M
  10. table_cache = 600
  11. sort_buffer_size = 2M
  12. myisam_sort_buffer_size = 4M
  13. read_buffer_size = 1M
  14. read_rnd_buffer_size = 4M
  15. long_query_time = 1
  16. log-slow-queries = /var/log/mysql/mysql-slow.log
  17. thread_cache_size = 8
  18. thread_concurrency = 2
  19.  
  20. max_heap_table_size = 32M
  21. tmp_table_size = 32M
  22.  
  23.  
  24. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  25. # if all processes that need to connect to mysqld run on the same host.
  26. # All interaction with mysqld must be made via Unix sockets or named pipes.
  27. # Note that using this option without enabling named pipes on Windows
  28. # (via the "enable-named-pipe" option) will render mysqld useless!
  29. #
  30. #skip-networking
  31.  
  32.  
  33. [mysqldump]
  34. quick
  35. max_allowed_packet = 16M
  36.  
  37. [mysql]
  38. no-auto-rehash
  39. #safe-updates
  40.  
  41. [isamchk]
  42. key_buffer = 128M
  43. sort_buffer_size = 128M
  44. read_buffer = 2M
  45. write_buffer = 2M
  46.  
  47. [myisamchk]
  48. key_buffer = 128M
  49. sort_buffer_size = 128M
  50. read_buffer = 2M
  51. write_buffer = 2M
  52.  
  53.  
  54. [mysqlhotcopy]
  55. interactive-timeout
Add Comment
Please, Sign In to add comment