[GitHub] [couchdb] molecular commented on issue #3047: Increase slack_db min priority (was: Upgrade from 2.3.1 to 3.1.0 - leads to 100% CPU Usage on both CentOs 7 and Mac-os)

[GitBox <gi...@apache.org>]

molecular commented on issue #3047:
URL: https://github.com/apache/couchdb/issues/3047#issuecomment-803536567


   I ran into this (100% cpu 1-2 minutes after couchdb start). It was a view compaction being constantly triggered on a ~5 million document db that gets new document(s) every 10 seconds.
   
   I copied the defaults from https://docs.couchdb.org/en/latest/maintenance/compaction.html#channel-configuration and that resulted in much less frequent view compaction being triggered. 
   
   So those "defaults2 are likely not the defaults on my system (archlinux, couchdb 3.1.1-2)
   
   I also learned how to interpret db metadata to evaluate what's a good treshold priority
   
   ```sh
   curl -s -u admin:<pw> -X GET http://blackbox:5984/solar | jq '(.sizes.file - .sizes.active) / 1E6'
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org