First truncate the syslog and eventlog tables, 11 million entries is unreasonable.

Make sure you have housekeeping configured to keep the size of those tables down, MySQL is really unsuitable for large log storage.

You need to truncate the tables first though, because housekeeping will take forever on those large tables.

After those tables are at a manageable size you can see if it’s any faster.

Adam.

Sent from my iPhone

On 25 Nov 2024, at 14:49, Meyer, Florian via observium <observium@lists.observium.org> wrote:



Hi all,

 

i have a problem with the quick search in my installation of observium professional. The results are displayed with a big delay. It varies from 3 to 10 seconds.

 

Everything else is very fast (in my opinion):

<image001.png>

 

Sometimes only a part of the string i entered is searched.

My MariaDB is on another virtual server. The problem started when i upgraded the OS from 10 to 12 a month ago.

 

Does anybody have an idea how i can troubleshoot this issue?

 

 

 

 

Version Information

Observium

24.10.13681 (20th October 2024)

OS

Linux 5.15.0-126-generic [amd64] (Ubuntu 22.04)

Apache

2.4.52 (Ubuntu)

PHP

8.1.2-1ubuntu2.19 (OPcache: ENABLED) (Memory: 1GB)

Python

3.10.12

MariaDB

10.11.6-MariaDB-0+deb12u1 (extension: mysqli 8.1.2-1ubuntu2.19)

SNMP

NET-SNMP 5.9.1

RRDtool

1.7.2 (rrdcached 1.7.2: unix:/var/run/rrdcached.sock)

Fping

5.1 (IPv4 and IPv6)

Fetch

cURL 7.81.0 (OpenSSL/3.0.2, LibZ 1.2.11, LibIDN 2.3.2)

Browser & Timezone Information

User-Agent

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36

Browser

Chrome 130.0 (Windows)

Screen Resolution

3840x1600

Timezone

+01:00 (System), +01:00 (PHP), +01:00 (DB), +01:00 (User)

 

Statistics

 DB size

15.5GB

 RRD size

116GB

 Devices

779

 Ports

41280

 IPv4 Addresses

3271

 IPv4 Networks

3497

 IPv6 Addresses

287

 IPv6 Networks

21

 Services

 Applications

5

 Processors

1330

 Memory pools

1055

 Storage Entries

858

 Disk I/O Entries

1996

 HR-MIB Entries

875

 Entity-MIB Entries

52783

 Syslog Entries

11299175

 Eventlog Entries

11656552

 Sensors

135228

 Printer Supplies

0

 Netscaler VServers

641

 Netscaler Services

503

 Virtual Machines

0

 IP SLAs

 

 

Kind regards,

Florian

 

 

_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org