NagiosXI database tining with Performance_schema
Posted: Mon Aug 21, 2017 3:12 am
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
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