[Vtigercrm-developers] slow vtiger server

[Rubén A. Estrada Orozco]

Hi Sutharsan,

Thanks for the tips. In fact I ended up increasing server resources to 8GB
RAM and 4 cores. Problem is solved now.
I was already using ssd drive, so that didn't change.



Saludos

Rubén


On Tue, Aug 18, 2020 at 5:31 AM Sutharsan J <ajstharsan at gmail.com> wrote:

> Hi Ruben
>
> Mostly it is hardware, because Vtiger is not an app developed on mongodb,
> it is MySQL  :)
>
>    1. From  past experience 2GB RAM was not enough when crm_entity table
>    arrives 1M. You may try 4GB
>    2. Is the disk SSD/M2? If not that can be one of the  causes.
>    3. 50 Users - I had issues starting when concurrent users increased
>    above 20 which increases sessions, so might be proportion to RAM
>    4. Entire list view performance can be affected, if any of the user
>    runs a un-filtered (or poorly filtered) Report
>    5. An archiving solution may help by moving unused leads out to
>    archive .
>
> Modtracker? IMHO it won't affect list view.
>
> Thanks
> Sutharsan Jeganathan
>
> On Tue, Aug 4, 2020 at 12:34 AM Rubén A. Estrada Orozco <
> rulotec1 at gmail.com> wrote:
>
>> Hi everyone,
>>
>> I'm having a performance issue with one of my clients. vtiger takes too
>> long to load listviews and sometimes 503 http errors are returned.
>> Apparently the server has a great workload. Before increasing resources, I
>> want to rule out there's something else that can be done.
>>
>>    - The server has a centos OS, 2GB RAM, 2 virtual CPUs, 2GB swap
>>    memory.
>>    - Vtgier version 7.1, PHP 7.0 fpm, Mariadb 5.5, apache 2.4.6
>>    - Aprox. 50 concurrent users
>>    - vtiger_crmentity table has 822 164 not deleted records and 23 380
>>    deleted records (almost all of them are leads)
>>
>> Upon activating the slow queries log I see that the queries getting the
>> listview of the leads module sometimes takes between 10 - 40 seconds with
>> aprox 1million rows examined:
>>
>> [image: image.png]
>>
>> Queries to the vtiger_modtracker table also take a while (36s in the
>> example below with 3.3 million rows examined):
>>
>> [image: image.png]
>>
>> This is a resources consumption graph of the server from 8am to 2pm:
>>
>> [image: image.png]
>> Any help will be appreciated.
>>
>> Alan Lord, you previously commented that you have clientes with huge
>> databases (several million rows). It would be really helpful to get some
>> advice from you.
>>
>> Thanks in advance
>> Rubén
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> --
>
>
>
>
>
>
>
>
>
> *Development Manager Radus28 Software Solution [image: Radus28 Software
> Solution] 123, Level 2, Mc Larens Building Baudhaloka Mw. Colombo 04 Sri
> Lanka M : +94773795291 E  : sutharsan at radus28.com <sutharsan at radus28.com> W
> : www.radus28.com <http://www.radus28.com>*
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/774af085/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 57454 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/774af085/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 36591 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/774af085/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 117163 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/774af085/attachment-0005.png>