Hi Adam, thanks for you reply. You are right 11 million entries look quite much. I had the housekeeping setting for syslog to keep 30 days and eventlogt o keep 365 days. I reduced both now to 7 days. Housekeeping script crunched like half an hour on those entries. I reduced syslog to 2.5 million and eventlog to 232k. +-------------------------------+-----------+ | Table | Size (MB) | +-------------------------------+-----------+ | eventlog | 5469 | | syslog | 3275 | | accesspoints-state | 2861 | | notifications_queue | 902 | | alert_log | 464 | | vlans_fdb | 248 | | bill_data | 131 |
But the problem still exist. The response times of the quick search is not faster. :( Any other advise? Kind regards, Florian Von: Adam Armstrong via observium <[email protected]> Gesendet: Montag, 25. November 2024 17:09 An: Observium <[email protected]> Cc: Adam Armstrong <[email protected]> Betreff: [Observium] Re: Quick Search Slow - how to troubleshoot? EXTERNER ABSENDER: Klicken Sie nur dann auf Links und Anhänge, wenn Sie dem Absender der Nachricht vertrauen. Diese Nachricht stammt von außerhalb der UMR! 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 <[email protected]<mailto:[email protected]>> 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 -- [email protected]<mailto:[email protected]> To unsubscribe send an email to [email protected]<mailto:[email protected]>
_______________________________________________ observium mailing list -- [email protected] To unsubscribe send an email to [email protected]
