[Vtigercrm-developers] slow vtiger server

[Sutharsan J]

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>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/d28d5d81/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/d28d5d81/attachment-0004.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/d28d5d81/attachment-0005.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/d28d5d81/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_web.png
Type: image/png
Size: 15612 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200818/d28d5d81/attachment-0007.png>