Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:60812ce9f2e1a0f09ce203155c986cb4

Created January 15, 2018 21:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/60812ce9f2e1a0f09ce203155c986cb4 to your computer and use it in GitHub Desktop.
Save mdcallag/60812ce9f2e1a0f09ce203155c986cb4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
processManagement:
fork: true
systemLog:
destination: file
path: /data/mysql/mmon360/log
logAppend: true
storage:
syncPeriodSecs: 600
dbPath: /data/mysql/mmon360/data
journal:
enabled: true
operationProfiling.slowOpThresholdMs: 2000
replication.oplogSizeMB: 4000
storage.wiredTiger.collectionConfig.blockCompressor: none
storage.wiredTiger.engineConfig.journalCompressor: none
storage.wiredTiger.engineConfig.cacheSizeGB: 180
# 1 - syncPeriodSecs=60, oplogSizeMB=4000
# 2 - syncPeriodSecs=60, oplogSizeMB=16000
# 3 - syncPeriodSecs=600, oplogSizeMB=16000
# 4 - syncPeriodSecs=60, oplogSizeMB=16000, checkpoint=1g
# 5 - syncPeriodSecs=600, oplogSizeMB=16000, checkpoint=1g
# 6 - syncPeriodSecs=600, oplogSizeMB=4000
# 7 - syncPeriodSecs=600, oplogSizeMB=4000, eviction_dirty_target=20, eviction_dirty_trigger=40
# 8 - syncPeriodSecs=600, oplogSizeMB=4000, eviction=(threads_min=4,threads_max=8)
# 9 - syncPeriodSecs=600, oplogSizeMB=4000, eviction_dirty_target=60, eviction_dirty_trigger=80
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment