Opspack Marketplace

MariaDB

MariaDB Opspack Overview

MariaDB (created by the original developers of MySQL) is one of the most popular database servers in the world and turns data into structured information for a wide variety of applications. Popular as ever since its first release as an alternative to MySQL, it is important to monitor all of your systems using MariaDB to make sure they are always at top performance.

What You Can Monitor 

By monitoring over 39 performance metrics, including connects, sessions, hits and free blocks, Opsview helps IT teams ensure that their MariaDB databases are at top performance. With our MariaDB Opspack, IT teams will be able to monitor all of the storage engines, plugins, and other tools within its robust environment. Here are a few specific benefits: 

  • Performance Metrics: Provides a wide variety of performance metrics that allows you to make sure your database is running at full speed, enabling you to monitor any performance changes in your environment over a period of time 
  • Clear Graphing and Reporting: Shows exactly what the database is doing and measures its performance over time via graphs that pinpoint insights that are easy to analyze 
  • Notifications: The new MariaDB Opspack combined with Opsview Monitor’s many notification integrations will make sure you get the right alerts to the right people at the right time

Checks

Aborted connects

Bytes recieved 

Bytes sent

Connections

Delayed errors

Key blocks not flushed

Key blocks unused

Key blocks used

Key read request

Key reads

Key write requests

Key writes

Listener

Low memory prunes

Max used Connections

Open Files

Open streams

Open tables

Processes

Qcache free blocks

Qcache free memory

Qcache hits

Qcache inserts

Qcache not cached

Qcache queries incache

Qcache total blocks

Slave open temp tables

Slave retired transactions

SSL renegotiates

SSL session cache hits

SSL session cache misses

SSL session cache overflows

SSL session cache timeouts

Threads connected

Threads running

XtraDB log pending FSyncs

XtraDB log pending writes

XtraDB waits

Setup and configuration:

To configure and utilize this Opspack, you simply need to add the 'Database - MariaDB' Opspack to the host running MariaDB and specify database login credentials via the variable MARIADBCREDENTIALS which need to be added to the host.

Step 1: Add the host template

MariaDB Opsview

Step 2: Add and configure the host variable

MariaDB Service Check Name

Step 3: Reload and view the MariaDB statistics

Maria DB Notification Summary

Opsview Supported
Average rating: 
0

No votes yet

Runs on: 
Opsview
Author: 
twebb
twebb's picture
Opspack type: 
Database