NagiosXI database tining with Performance_schema

[rc00512011]

Hi Team,
We have 100 + NagiosXI servers and we are in phase of database tuning, i have come across mariaDB performance_schema which on enabling will give us measured data which we can use for standardizing below things:
# MEMORY variables
#Temp Table
# Query Cache
# Session variables
# Other buffers and caches
# MySQL error log
# log_timestamps
# Slow Query Log
# General Query Log
# Performance Schema
# Slave variables

Does NagiosXI recommend use of Performance_schema, if what would be th ebest ways to finetune DB. What all different options other than performance_schema and best options to use any method.

Request you to share your experiences in order to enhance the DB performances. Also we would like to know what different editors you guys have used for managing 100 + Databases.

Regards,
Ranjit Chavan

[dwhitfield]

The following document goes through database optimization: https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Please let us know if you need any additional details.