NagiosXI specific Indexing

[rc00512011]

Hi Team,

Could you share the information or step by step guide for MariaDB NagiosXI specific indexing. Informaiton on how you guys are mainting and managing MariaDB.
I already have performance related document from Nagios LLC, but need suggestions and different ways to work on indexing and views.

Regards,
Ranjit Chavan

[dwasswa]

Which performance related docs have you seen?
Here are the performance docs for increasing performance in Nagios XI...Please see below....

https://support.nagios.com/kb/article.php?id=70

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

What are you looking for exactly?

[dwhitfield]

need suggestions and different ways to work on indexing and views.

I assume you mean SQL views, and not XI views. Can you clarify?

We do not recommend modifying the database directly as it is very likely to cause XI to fail. We do, however, offer custom development. If you would be interested in a quote, please email [email protected]

[mcapra]

NDOUtils has some tables that index columns with timestamps (for reporting purposes I assume). That's about it.

If you did a recursive grep through the Nagios XI installation tarball for files ending in sql, you can review all of this independently for your specific use case. Fortunately it's not a ton of stuff to sift through.

[dwhitfield]

Thanks @mcapra!

OP, if you aren't using the latest version, you can find old versions at https://assets.nagios.com/downloads/nag ... rsions.php