Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. [mysqld]
  2. datadir=/disk3/mysql
  3. performance-schema=0
  4. table_definition_cache=2000
  5. table_open_cache=3000
  6. open_files_limit=50000
  7.  
  8. innodb_buffer_pool_instances=16
  9. innodb_buffer_pool_size=60G
  10. innodb_log_file_size=1G
  11. innodb_log_buffer_size=256M
  12. innodb_file_per_table=1
  13. innodb_stats_on_metadata=OFF
  14.  
  15. innodb_purge_threads=8
  16. table_open_cache_instances=16
  17.  
  18. open_files_limit=30000
  19.  
  20. default_storage_engine=InnoDB
  21.  
  22. max_allowed_packet=268435456
  23. myisam_sort_buffer_size=64M
  24.  
  25. key_buffer_size=1G
  26. join_buffer_size=256k
  27. tmp_table_size=576M
  28. max_heap_table_size=576M
  29. max_connections=600
  30.  
  31. slow-query-log=1
  32. slow-query-log-file=/output/mysql-slow.log
  33. long_query_time=1
  34. log_warnings=2
  35.  
  36. query_cache_type=OFF
  37. query_cache_size=0
  38.  
  39. expire_logs_days=5
  40. sort_buffer_size=2M
  41. innodb_io_capacity_max=10000
  42. innodb_io_capacity=5000
  43. innodb_lru_scan_depth=100
  44. thread_cache_size=100
  45. innodb_flush_neighbors=0
  46. query_cache_limit=1024
  47. key_cache_age_threshold=64800
  48. max_write_lock_count=16
  49. thread_concurrency=30
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement