Hi all,

I have a new Observium setup (verion 18.9.9428 (9th September 2018)) with the following VM spec:

Cores 4

Memory 64GB

HD 500GB

CentOS 7

PHP 7.0.31

MySQL 5.5.60-MariaDB

and with the following network devices to be monitored:

Devices - 634 (total), 597 (up), 37 (down)

Ports - 58,032 (total), 27,664 (up), 19,967 (down)

Sensors - 47,639 (total), 43,243 (ok), 4,396 (down)

Statuses - 5,880 (total), 5,854 (ok), 10 (alert)

---

Issue is that we are frequently seeing the following error when connecting on GUI/CLI, with slow response time on GUI/CLI:

DB Error 1040: Too many connections

And we are seeing gaps (broken graphs) like the following:

We have tried to bump up the number of 'max_connections' from original 151 to 500 and then 200, but it didn't help:

sjc-observium-1:/etc# grep max_conn my.cnf

max_connections=200

sjc-observium-1:/etc#

And it's observed that the CPU load is heavy with 'mysqld':

top - 09:36:17 up 35 days, 18:54,  2 users,  load average: 74.18, 89.49, 82.67

Tasks: 665 total,  79 running, 586 sleeping,   0 stopped,   0 zombie

%Cpu(s): 62.9 us, 36.9 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.2 si,  0.0 st

KiB Mem : 65810376 total,  2511836 free,  5989292 used, 57309248 buff/cache

KiB Swap:  4193020 total,  4141016 free,    52004 used. 59172312 avail Mem  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND

5152 mysql     20   0 2749132 664216   9164 S  20.7  1.0   4058:17 mysqld

31879 root      20   0  419676  27564   8264 R   4.2  0.0   0:00.13 php

31769 root      20   0  417212  25532   8336 S   3.6  0.0   0:00.12 php

31933 root      20   0  416868  25116   8148 S   3.2  0.0   0:00.10 php

31935 root      20   0  416736  24700   7832 S   3.2  0.0   0:00.10 php

<snip>

My 'config.php' is pretty much with default values.

---

I'm new to Observium.  It'd be greatly appreciated if someone can shed some light how it can be resolved.

Thanks.

- Gordon