Logo
Explore Help
Sign In
mirror/librenms-librenms
Watch 1
Star 0
Fork 0
mirror of https://github.com/librenms/librenms.git synced 2024-10-07 16:52:45 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
Files
php73
librenms-librenms/sql-schema/273.sql
T

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

2 lines
78 B
SQL
Raw Permalink Normal View History

Add additional composite index to speed up display of pages where a device has a lot of syslogs. In our environment, this took page loads for some devices from over 60 seconds to nearly instant
2018-12-03 10:44:03 -06:00
ALTER TABLE `syslog` ADD KEY `device_id-timestamp` (`device_id`,`timestamp`);
Reference in New Issue Copy Permalink
Powered by Gitea Page: 933ms Template: 3ms
edge-auto
English
Bahasa Indonesia Deutsch English Español Français Gaeilge Italiano Latviešu Magyar nyelv Nederlands Polski Português de Portugal Português do Brasil Suomi Svenska Türkçe Čeština Ελληνικά Български Русский Українська فارسی മലയാളം 日本語 简体中文 繁體中文(台灣) 繁體中文(香港) 한국어
Licenses API