[GitHub] smartheye opened a new issue #1290: [Question]GET /db/_all_docs is slow, which index is it using?

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

smartheye opened a new issue #1290: [Question]GET /db/_all_docs is slow, which index is it using?
URL: https://github.com/apache/couchdb/issues/1290
 
 
   <!--- Provide a general summary of the issue in the Title above -->
   Hi, I am using couchdb 2.1.1. It's found that when query /db/_all_doc interface, it took time to respond and used high cpu. I understood that it's rebuilding index so a lot of time and cpu must be used.
   But I cannot find which index is /db/_all_doc using. 
   If I know the index I could warm it by query it after data update
   ## Expected Behavior
   <!--- If you're describing a bug, tell us what should happen -->
   <!--- If you're suggesting a change/improvement, tell us how it should work -->
   It might not be a bug. Can you tell me which index is /db/_all_doc using? 
   And, what's mrview? is it related?
   ## Current Behavior
   <!--- If describing a bug, tell us what happens instead of the expected behavior -->
   <!--- If suggesting a change/improvement, explain the difference from current behavior -->
   query /db/_all_doc is using high cpu and a lot of time.
   some of them would take more than 30 seconds, it caused application timeout
   ## Possible Solution
   <!--- Not obligatory, but suggest a fix/reason for the bug, -->
   <!--- or ideas how to implement the addition or change -->
   tell me which index is /db/_all_doc using.
   ## Steps to Reproduce (for bugs)
   <!--- Provide a link to a live example, or an unambiguous set of steps to -->
   <!--- reproduce this bug. Include code to reproduce, if relevant -->
   1. changed a lot of data in couchdb
   2. query GET /db/_all_docs
   3. it took a lot of time
   4.
   
   ## Context
   <!--- How has this issue affected you? What are you trying to accomplish? -->
   <!--- Providing context helps us come up with a solution that is most useful in the real world -->
   when the data changed, query /_all_docs would trigger a rebuild of view, which took a lot of time (more than 30 seconds at max, most of them were 10~20 seconds)
   the query would timeout.
   So I just want to rewarm the index but I cannot find what index /_all_docs used.
   And I found mrview occured in the log but I don't know what it is
   
   ## Your Environment
   <!--- Include as many relevant details about the environment you experienced the bug in -->
   * Version used: 2.1.1
   * Browser Name and version: Chrome/Firefox
   * Operating System and version (desktop or mobile): ubuntu 1604
   * Link to your project: http://github.com/hyperledger/fabric
   

----------------------------------------------------------------
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