[Vtigercrm-developers] slow vtiger server

[Rubén A. Estrada Orozco]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200803/9d00b3a0/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/20200803/9d00b3a0/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/20200803/9d00b3a0/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/20200803/9d00b3a0/attachment-0005.png>