Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Subject: Re: High CPU when changing / adding view
To: user@couchdb.apache.org
References: <5617EE54.5010004@open-net.biz>
 <3A02D120-7C5D-4A8F-8F6E-F973609251C4@googlemail.com>
 <CAG+HO1yE_tQ-j5tKbrB05eTTA8kkWB5GPEgeHpgUZXSAtPPZfg@mail.gmail.com>
 <CAGsxEDKXygEkR_ABZR4w7Tg3iByR2H_9+9cP4L+RXcimKDAZOw@mail.gmail.com>
From: Kiril Stankov <kiril@open-net.biz>
Message-ID: <561CED50.20508@open-net.biz>
Date: Tue, 13 Oct 2015 14:38:56 +0300
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.1.0
MIME-Version: 1.0
In-Reply-To: 
 <CAGsxEDKXygEkR_ABZR4w7Tg3iByR2H_9+9cP4L+RXcimKDAZOw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------070407020606030508040103"

--------------070407020606030508040103
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

I would ask a "silly" question, if it wasn't a problem.
Yes, the overall performance of the machine is affected - another code 
also runs on the same machine.
During the view update, it gets so slow, that I'm getting timeout on 
http connections.
------------------------------------------------------------------------
*With best regards,*
Kiril Stankov

On 09-Oct-15 10:04 PM, Kyle Snavely wrote:
> Silly question -- is the CPU consumption affecting the rest of the machine,
> or is it simply free for CouchDB to use? How does load average look during
> the high CPU consumption?
>
> - Kyle
>
> On Fri, Oct 9, 2015 at 2:41 PM, Andrey Kuprianov <
> andrey.kouprianov@gmail.com> wrote:
>
>> It would help, but views would build slower tho
>>
>> On Sat, Oct 10, 2015 at 12:10 AM, Sebastian Rothbucher <
>> sebastianrothbucher@googlemail.com> wrote:
>>
>>> Hi,
>>>
>>> You could renice it but i'm not sure it would help - worth a try though
>>>
>>>     Sebastian
>>>
>>> Von meinem iPhone gesendet
>>>
>>>> Am 09.10.2015 um 18:41 schrieb Kiril Stankov <kiril@open-net.biz>:
>>>>
>>>> Hi all,
>>>>
>>>> I have already ~ 50000 docs in one db.
>>>> Their structure is pretty simple.
>>>> When I add or modify a view, Couchdb eats 80-90% CPU and becomes very
>>> slow to answer requests.
>>>> Though it takes ~ 2 min to build the views, it is a point of concern,
>> as
>>> I expect this DB to grow to millions of documents.
>>>> I don't mind if it'd take more time to build/update the view, but is
>>> there a way to limit the CPU this process will take?
>>>> Thanks in advance!
>>>>
>>>>
>> ------------------------------------------------------------------------
>>>> *With best regards,*
>>>> Kiril Stankov


--------------070407020606030508040103--