def __init__(self, argv=(), env={}, debug=False):
"""Populate Munin Plugin with MuninGraph instances.
@param argv: List of command line arguments.
@param env: Dictionary of environment variables.
@param debug: Print debugging messages if True. (Default: False)
"""
MuninPlugin.__init__(self, argv, env, debug)
self.envRegisterFilter('engine', '^\w+$')
self._host = self.envGet('host')
self._port = self.envGet('port')
self._database = self.envGet('database')
self._user = self.envGet('user')
self._password = self.envGet('password')
self._dbconn = MySQLinfo(self._host, self._port, self._database,
self._user, self._password)
if self.graphEnabled('mysql_connections'):
graph = MuninGraph(
'MySQL - Connections per second',
'MySQL',
info=
'MySQL Database Server new and aborted connections per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'conn',
'conn',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of connection attempts to the MySQL server.')
graph.addField(
'abort_conn',
'abort_conn',
draw='LINE2',
type='DERIVE',
min=0,
info=
'The number of failed attempts to connect to the MySQL server.'
)
graph.addField(
'abort_client',
'abort_client',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of connections that were aborted, because '
'the client died without closing the connection properly.')
self.appendGraph('mysql_connections', graph)
if self.graphEnabled('mysql_traffic'):
graph = MuninGraph(
'MySQL - Network Traffic (bytes/sec)',
'MySQL',
info=
'MySQL Database Server Network Traffic in bytes per second.',
args='--base 1000 --lower-limit 0',
vlabel='bytes in (-) / out (+) per second')
graph.addField('rx',
'bytes',
draw='LINE2',
type='DERIVE',
min=0,
graph=False)
graph.addField('tx',
'bytes',
draw='LINE2',
type='DERIVE',
min=0,
negative='rx',
info="Bytes In (-) / Out (+) per second.")
self.appendGraph('mysql_traffic', graph)
if self.graphEnabled('mysql_slowqueries'):
graph = MuninGraph(
'MySQL - Slow Queries per second',
'MySQL',
info='The number of queries that have taken more than '
'long_query_time seconds.',
args='--base 1000 --lower-limit 0')
graph.addField('queries',
'queries',
draw='LINE2',
type='DERIVE',
min=0)
self.appendGraph('mysql_slowqueries', graph)
if self.graphEnabled('mysql_rowmodifications'):
graph = MuninGraph(
'MySQL - Row Insert, Delete, Updates per second',
'MySQL',
info='MySQL Inserted, Deleted, Updated Rows per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'insert',
'insert',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to insert a rows into tables.')
graph.addField(
'update',
'update',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to update a rows in a tables.')
graph.addField(
'delete',
'delete',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to delete rows from tables.')
self.appendGraph('mysql_rowmodifications', graph)
if self.graphEnabled('mysql_tablelocks'):
graph = MuninGraph('MySQL - Table Locks per second',
'MySQL',
info='MySQL Table Locks per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'waited',
'waited',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of times that a request for a table lock '
'could not be granted immediately and a wait was needed.')
graph.addField(
'immediate',
'immediate',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of times that a request for a table lock '
'could be granted immediately.')
self.appendGraph('mysql_tablelocks', graph)
if self.graphEnabled('mysql_threads'):
graph = MuninGraph('MySQL - Threads',
'MySQL',
info='MySQL Database Server threads status.',
args='--base 1000 --lower-limit 0')
graph.addField('running',
'running',
draw='AREASTACK',
type='GAUGE',
info="Number of threads executing queries.")
graph.addField(
'idle',
'idle',
draw='AREASTACK',
type='GAUGE',
info="Number of idle threads with connected clients.")
graph.addField(
'cached',
'cached',
draw='AREASTACK',
type='GAUGE',
info="Number of cached threads without connected clients.")
graph.addField('total',
'total',
draw='LINE2',
type='GAUGE',
colour='000000',
info="Total number of threads.")
self.appendGraph('mysql_threads', graph)
def __init__(self, argv=(), env=None, debug=False):
"""Populate Munin Plugin with MuninGraph instances.
@param argv: List of command line arguments.
@param env: Dictionary of environment variables.
@param debug: Print debugging messages if True. (Default: False)
"""
MuninPlugin.__init__(self, argv, env, debug)
self.envRegisterFilter('engine', '^\w+$')
self._host = self.envGet('host')
self._port = self.envGet('port', None, int)
self._database = self.envGet('database')
self._user = self.envGet('user')
self._password = self.envGet('password')
self._category = 'MySQL'
self._engines = None
self._genStats = None
self._genVars = None
self._dbList = None
self._dbconn = MySQLinfo(self._host, self._port, self._database,
self._user, self._password)
if self.graphEnabled('mysql_connections'):
graph = MuninGraph(
'MySQL - Connections per second',
self._category,
info='MySQL Server new and aborted connections per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'conn',
'conn',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of connection attempts to the MySQL server.')
graph.addField(
'abort_conn',
'abort_conn',
draw='LINE2',
type='DERIVE',
min=0,
info=
'The number of failed attempts to connect to the MySQL server.'
)
graph.addField(
'abort_client',
'abort_client',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of connections that were aborted, because '
'the client died without closing the connection properly.')
self.appendGraph('mysql_connections', graph)
if self.graphEnabled('mysql_traffic'):
graph = MuninGraph(
'MySQL - Network Traffic (bytes/sec)',
self._category,
info='MySQL Server Network Traffic in bytes per second.',
args='--base 1000 --lower-limit 0',
vlabel='bytes in (-) / out (+) per second')
graph.addField('rx',
'bytes',
draw='LINE2',
type='DERIVE',
min=0,
graph=False)
graph.addField('tx',
'bytes',
draw='LINE2',
type='DERIVE',
min=0,
negative='rx',
info="Bytes In (-) / Out (+) per second.")
self.appendGraph('mysql_traffic', graph)
if self.graphEnabled('mysql_slowqueries'):
graph = MuninGraph(
'MySQL - Slow Queries per second',
self._category,
info='The number of queries that have taken more than '
'long_query_time seconds.',
args='--base 1000 --lower-limit 0')
graph.addField('queries',
'queries',
draw='LINE2',
type='DERIVE',
min=0)
self.appendGraph('mysql_slowqueries', graph)
if self.graphEnabled('mysql_rowmodifications'):
graph = MuninGraph(
'MySQL - Row Insert, Delete, Updates per second',
self._category,
info='MySQL Server Inserted, Deleted, Updated Rows per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'insert',
'insert',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to insert a rows into tables.')
graph.addField(
'update',
'update',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to update a rows in a tables.')
graph.addField(
'delete',
'delete',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of requests to delete rows from tables.')
self.appendGraph('mysql_rowmodifications', graph)
if self.graphEnabled('mysql_rowreads'):
graph = MuninGraph('MySQL - Row Reads per second',
self._category,
info='MySQL Server Row Reads per second.',
args='--base 1000 --lower-limit 0')
for (field, desc) in (
('first', 'Requests to read first entry in index.'),
('key', 'Requests to read a row based on a key.'),
('next', 'Requests to read the next row in key order.'),
('prev', 'Requests to read the previous row in key order.'),
('rnd', 'Requests to read a row based on a fixed position.'),
('rnd_next',
'Requests to read the next row in the data file.'),
):
graph.addField(field,
field,
draw='AREASTACK',
type='DERIVE',
min=0,
info=desc)
self.appendGraph('mysql_rowreads', graph)
if self.graphEnabled('mysql_tablelocks'):
graph = MuninGraph('MySQL - Table Locks per second',
self._category,
info='MySQL Server Table Locks per second.',
args='--base 1000 --lower-limit 0')
graph.addField(
'waited',
'waited',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of times that a request for a table lock '
'could not be granted immediately and a wait was needed.')
graph.addField(
'immediate',
'immediate',
draw='AREASTACK',
type='DERIVE',
min=0,
info='The number of times that a request for a table lock '
'could be granted immediately.')
self.appendGraph('mysql_tablelocks', graph)
if self.graphEnabled('mysql_threads'):
graph = MuninGraph(
'MySQL - Threads',
self._category,
info='Number of active and idle threads for MySQL Server.',
args='--base 1000 --lower-limit 0')
graph.addField('running',
'running',
draw='AREASTACK',
type='GAUGE',
info="Number of threads executing queries.")
graph.addField(
'idle',
'idle',
draw='AREASTACK',
type='GAUGE',
info="Number of idle threads with connected clients.")
graph.addField(
'cached',
'cached',
draw='AREASTACK',
type='GAUGE',
info="Number of cached threads without connected clients.")
graph.addField('total',
'total',
draw='LINE2',
type='GAUGE',
colour='000000',
info="Total number of threads.")
self.appendGraph('mysql_threads', graph)
if self.graphEnabled('mysql_proc_status'):
graph = MuninGraph(
'MySQL - Process Status',
self._category,
info='Number of threads discriminated by process status.',
args='--base 1000 --lower-limit 0')
for (field, label, desc) in (
('locked', 'locked', 'The query is locked by another query.'),
('sending_data', 'sending',
'The thread is processing rows for a SELECT statement and also'
' is sending data to the client.'),
('updating', 'updating',
'The thread is searching for rows to update and is updating them.'
),
('sorting_result', 'sorting',
'For a SELECT statement, this is similar to Creating sort'
' index, but for non-temporary tables.'),
('closing_tables', 'closing',
'The thread is flushing the changed table data to disk and'
' closing the used tables.'),
('copying_to_tmp_table', 'copying',
'The thread is processing an ALTER TABLE statement. This state'
' occurs after the table with the new structure has been'
' created but before rows are copied into it.'),
('preparing', 'preparing',
'This state occurs during query optimization.'),
('statistics', 'statistics',
'The server is calculating statistics to develop a query'
' execution plan. If a thread is in this state for a long'
' time, the server is probably disk-bound performing other work.'
),
('reading_from_net', 'net_read',
'The server is reading a packet from the network.'),
('writing_to_net', 'net_write',
'The server is writing a packet to the network.'),
('login', 'login',
'The initial state for a connection thread until the client'
' has been authenticated successfully.'),
('init', 'init',
'This occurs before the initialization of ALTER TABLE, DELETE,'
' INSERT, SELECT, or UPDATE statements.'),
('end', 'end',
'This occurs at the end but before the cleanup of ALTER TABLE,'
' CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements.'
),
('freeing_items', 'freeing',
'The thread has executed a command. This state is usually'
' followed by cleaning up.'),
('other', 'other', 'Other valid state.'),
('unknown', 'unknown',
'State not recognized by the monitoring application.'),
('idle', 'idle', 'Idle threads.'),
):
graph.addField(field,
label,
draw='AREASTACK',
type='GAUGE',
info=desc)
self.appendGraph('mysql_proc_status', graph)
if self.graphEnabled('mysql_proc_db'):
if self._dbList is None:
self._dbList = self._dbconn.getDatabases()
self._dbList.sort()
graph = MuninGraph(
'MySQL - Processes per Database',
self._category,
info='Number of Threads discriminated by database.',
args='--base 1000 --lower-limit 0',
autoFixNames=True)
for db in self._dbList:
graph.addField(
db,
db,
draw='AREASTACK',
type='GAUGE',
info=
"Number of threads attending connections for database %s."
% db)
self.appendGraph('mysql_proc_db', graph)
if self.graphEnabled('mysql_commits_rollbacks'):
graph = MuninGraph(
'MySQL - Commits and Rollbacks',
self._category,
info='MySQL Server Commits and Rollbacks per second.',
args='--base 1000 --lower-limit 0')
graph.addField('commit',
'commit',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of commits per second.')
graph.addField('rollback',
'rollback',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of rollbacks per second.')
self.appendGraph('mysql_commits_rollbacks', graph)
if self.graphEnabled('mysql_qcache_memory'):
graph = MuninGraph(
'MySQL - Query Cache - Memory Use (bytes)',
self._category,
info='Memory utilization for MySQL Server Query Cache.',
args='--base 1000 --lower-limit 0')
graph.addField('used',
'used',
draw='AREASTACK',
type='GAUGE',
info="Used space (bytes) in Query Cache.")
graph.addField('free',
'free',
draw='AREASTACK',
type='GAUGE',
info="Free space (bytes) in Query Cache.")
self.appendGraph('mysql_qcache_memory', graph)
if self.graphEnabled('mysql_qcache_hits'):
graph = MuninGraph(
'MySQL - Query Cache - Hits',
self._category,
info='MySQL Server Query Cache Hits vs. Select Queries.',
args='--base 1000 --lower-limit 0')
graph.addField(
'hits',
'hits',
draw='AREASTACK',
type='DERIVE',
min=0,
info=
'Hits - Number of select queries responded from query cache.')
graph.addField('misses',
'misses',
draw='AREASTACK',
type='DERIVE',
min=0,
info='Misses - Number of select queries executed.')
self.appendGraph('mysql_qcache_hits', graph)
if self.graphEnabled('mysql_qcache_prunes'):
graph = MuninGraph(
'MySQL - Query Cache - Inserts/Prunes per second',
self._category,
info='MySQL Server Query Cache Inserts and Low Memory Prune'
' operations per second.',
args='--base 1000 --lower-limit 0')
graph.addField('insert',
'insert',
draw='LINE2',
type='DERIVE',
min=0,
info='Number of queries added to the query cache.')
graph.addField(
'prune',
'prune',
draw='LINE2',
type='DERIVE',
min=0,
info='The number of queries that were deleted from the'
' query cache because of low memory.')
self.appendGraph('mysql_qcache_prunes', graph)
if self.engineIncluded('myisam'):
if self.graphEnabled('mysql_myisam_key_buffer_util'):
graph = MuninGraph(
'MyISAM - Key Buffer Utilization (bytes)',
self._category,
info='MySQL Server MyISAM Key Buffer Utilization'
' in bytes.',
args='--base 1000 --lower-limit 0')
graph.addField('dirty',
'dirty',
draw='AREASTACK',
type='GAUGE',
info="Key space used by dirty blocks.")
graph.addField('clean',
'clean',
draw='AREASTACK',
type='GAUGE',
info="Key space used by dirty blocks..")
graph.addField('free',
'free',
draw='AREASTACK',
type='GAUGE',
info="Free space in key buffer.")
graph.addField('total',
'total',
draw='LINE2',
type='GAUGE',
colour='000000',
info="Total size of key buffer.")
self.appendGraph('mysql_myisam_key_buffer_util', graph)
if self.graphEnabled('mysql_myisam_key_read_reqs'):
graph = MuninGraph(
'MyISAM - Key Block Read Requests per second',
self._category,
info='MySQL Server MyISAM Key block read requests satisfied '
' from block cache (hits) vs. disk (misses).',
args='--base 1000 --lower-limit 0')
graph.addField(
'disk',
'disk',
draw='AREASTACK',
type='DERIVE',
min=0,
info='Misses - Key block read requests requiring'
' read from disk.')
graph.addField(
'buffer',
'buffer',
draw='AREASTACK',
type='DERIVE',
min=0,
info='Misses - Key block read requests satisfied'
' from block cache without requiring read'
' from disk.')
self.appendGraph('mysql_myisam_key_read_reqs', graph)
if self.engineIncluded('innodb'):
if self.graphEnabled('mysql_innodb_buffer_pool_util'):
graph = MuninGraph(
'InnoDB - Buffer Pool Utilization (bytes)',
self._category,
info=
'MySQL Server InnoDB Buffer Pool Utilization in bytes.',
args='--base 1000 --lower-limit 0')
graph.addField('dirty',
'dirty',
draw='AREASTACK',
type='GAUGE',
info="Buffer pool space used by dirty pages.")
graph.addField('clean',
'clean',
draw='AREASTACK',
type='GAUGE',
info="Buffer pool space used by clean pages.")
graph.addField(
'misc',
'misc',
draw='AREASTACK',
type='GAUGE',
info="Buffer pool space used for administrative overhead.")
graph.addField('free',
'free',
draw='AREASTACK',
type='GAUGE',
info="Free space in buffer pool.")
graph.addField('total',
'total',
draw='LINE2',
type='GAUGE',
colour='000000',
info="Total size of buffer pool.")
self.appendGraph('mysql_innodb_buffer_pool_util', graph)
if self.graphEnabled('mysql_innodb_buffer_pool_activity'):
graph = MuninGraph(
'InnoDB - Buffer Pool Activity (Pages per second)',
self._category,
info='MySQL Server Pages read into, written from and created'
' in InnoDB buffer pool.',
args='--base 1000 --lower-limit 0')
for (field, desc) in (
('created', 'Pages created in the buffer pool without'
' reading corresponding disk pages.'),
('read', 'Pages read into the buffer pool from disk.'),
('written',
'Pages written to disk from the buffer pool.')):
graph.addField(field,
field,
draw='LINE2',
type='DERIVE',
min=0,
info=desc)
self.appendGraph('mysql_innodb_buffer_pool_activity', graph)
if self.graphEnabled('mysql_innodb_buffer_pool_read_reqs'):
graph = MuninGraph(
'InnoDB - Buffer Pool Read Requests per second',
self._category,
info=
'MySQL Server read requests satisfied from InnoDB buffer'
' pool (hits) vs. disk (misses).',
args='--base 1000 --lower-limit 0')
graph.addField('disk',
'disk',
draw='AREASTACK',
type='DERIVE',
min=0,
info='Misses - Logical read requests requiring'
' read from disk.')
graph.addField('buffer',
'buffer',
draw='AREASTACK',
type='DERIVE',
min=0,
info='Misses - Logical read requests satisfied'
' from buffer pool without requiring read'
' from disk.')
self.appendGraph('mysql_innodb_buffer_pool_read_reqs', graph)
if self.graphEnabled('mysql_innodb_row_ops'):
graph = MuninGraph(
'InnoDB - Row Operations per Second',
self._category,
info='MySQL Server InnoDB Inserted, updated, deleted, read'
' rows per second.',
args='--base 1000 --lower-limit 0')
for field in ('inserted', 'updated', 'deleted', 'read'):
graph.addField(field,
field,
draw='AREASTACK',
type='DERIVE',
min=0,
info="Rows %s per second." % field)
self.appendGraph('mysql_innodb_row_ops', graph)
