[GitHub] jasons316 opened a new issue #1653: Slow reads when view indexes generating

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

jasons316 opened a new issue #1653: Slow reads when view indexes generating
URL: https://github.com/apache/couchdb/issues/1653
 
 
   I don't know if this is the right place to ask this, but we are currently getting issues when data is being inserted, or view indexes are being built. During this process, reading data from CouchDB becomes slow, often taking several seconds to return data, and sometimes even timing out.
   
   We have an n3q8 cluster, running v2.1.1. Each node is running CentOS 7.2 and has 16 CPU cores (32 threads), 128GB RAM and 1TB of SSD storage.
   
   We mostly run the default configuration, but have changed the following parameters:
   vm.args
   +A 64
   
   local.ini
   max_dbs_open = 5000
   os_process_limit = 2000
   os_process_soft_limit = 1000
   
   We have also increased the OS and couchdb user ulimit to 65535.
   
   I don't know if there is an issue with our configuration, but I would like to be able to read records from the database/views at the same time that views are being indexed with minimal delay. Is there anyway to prioritise read traffic, or reserve processing power for this purpose?
   
   Any help would be appreciated.
   
   Thanks.
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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


With regards,
Apache Git Services