MySQL Performance Monitoring Database

MySQL is an open-source relational database management system (RDBMS). MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal. MySQL is developed, distributed, and supported by Oracle Corporation.

Telegraf Input Plugin: MySQL

Collect and graph statistics from your MySQL monitoring database to keep it performant. Check for metrics that will indicate that it is running slowly (latency, errors), and executing queries as expected and in a timely manner. This plugin gathers the statistic data from MySQL server:

• Global statuses
• Global variables
• Slave statuses
• Binlog size
• Process list
• User Statistics
• Info schema auto increment columns
• InnoDB metrics
• Table I/O waits
• Index I/O waits
• Perf Schema table lock waits
• Perf Schema event waits
• Perf Schema events statements
• File events statistics
• Table schema statistics

MySQL Basics

As a relational database, MySQL stores data in separate tables, and its structures are organized into physical files optimized for speed:

• The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment.
• You set up rules governing the relationships between different data fields, such as one-to-one, one-to-many, unique, required or optional, and“pointers” between different tables.
• The database enforces these rules, so that with a well-designed database, your application never sees inconsistent, duplicate, orphan, out-of-date, or missing data.