Advertisement
Guest User

Untitled

a guest
Mar 19th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. [mysqld]
  2. local-infile=0
  3. max_connections = 600
  4. max_user_connections=1000
  5. key_buffer_size = 512M
  6. myisam_sort_buffer_size = 64M
  7. read_buffer_size = 1M
  8. table_open_cache = 5000
  9. thread_cache_size = 384
  10. wait_timeout = 20
  11. connect_timeout = 10
  12. tmp_table_size = 256M
  13. max_heap_table_size = 128M
  14. max_allowed_packet=268435456
  15. net_buffer_length = 16384
  16. max_connect_errors = 10
  17. concurrent_insert = 2
  18. read_rnd_buffer_size = 786432
  19. bulk_insert_buffer_size = 8M
  20. query_cache_limit = 5M
  21. query_cache_size = 128M
  22. query_cache_type = 1
  23. query_prealloc_size = 262144
  24. query_alloc_block_size = 65535
  25. transaction_alloc_block_size = 8192
  26. transaction_prealloc_size = 4096
  27. max_write_lock_count = 8
  28. slow_query_log
  29. log-error
  30. external-locking=FALSE
  31. open_files_limit=50000
  32.  
  33. innodb_buffer_pool_size=134217728
  34. [mysqld_safe]
  35.  
  36. [mysqldump]
  37. quick
  38. max_allowed_packet = 16M
  39.  
  40. [isamchk]
  41. key_buffer = 384M
  42. sort_buffer = 384M
  43. read_buffer = 256M
  44. write_buffer = 256M
  45.  
  46. [myisamchk]
  47. key_buffer = 384M
  48. sort_buffer = 384M
  49. read_buffer = 256M
  50. write_buffer = 256M
  51.  
  52. #### Per connection configuration ####
  53. sort_buffer_size = 1M
  54. join_buffer_size = 1M
  55. thread_stack = 192K
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement