Advertisement
Prozaik

Untitled

Nov 8th, 2017
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. key_cache_division_limit = 70
  2. thread_stack = 192K
  3. tmp_table_size = 128M
  4. max_heap_table_size = 128M
  5. key_buffer_size = 256M
  6. sort_buffer_size = 16M
  7. read_buffer_size = 16M
  8. read_rnd_buffer_size = 12M
  9. wait_timeout = 360
  10. interactive_timeout = 360
  11. myisam_sort_buffer_size = 64M
  12.  
  13. # This replaces the startup script and checks MyISAM tables if needed
  14. # the first time they are touched
  15.  
  16. myisam-recover = BACKUP
  17. max_connections = 500
  18. table-cache = 5000
  19. table-open-cache = 5000
  20. thread-cache-size = 500
  21. query_cache_limit = 2M
  22. query_cache_size = 128M
  23. join_buffer_size = 64M
  24.  
  25.  
  26. expire_logs_days = 10
  27. max_binlog_size = 100M
  28. innodb_buffer_pool_size = 32M
  29. innodb_buffer_pool_instances = 2
  30. innodb_flush_log_at_trx_commit = 2
  31. innodb_flush_method = O_DIRECT
  32. innodb_log_file_size = 128M
  33. innodb_log_buffer_size = 128M
  34.  
  35. # Here you can see queries with especially long duration
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement