QOS User's Manual
Prev		Next

InnoTbSpc

Name

InnoTbSpc -- Check MySQL InnoDB table space sizes

Synopsis

{ 'type'    : 'InnoTbSpc' ,
  'DB'      : 'website',
  'Table'   : 'session',
  'User'    : 'monitor',
  'Pass'    : 'abcd1234',
  'Host'    : 'db1.example.com',
  'Port'    : '3306',
  'status'  : 'on' ,
  'triggers': [{ 'level' : 'info',     'trigger' : '50000'}, 
               { 'level' : 'critical', 'trigger' : '20000'}, ],
}

Description

The InnoTbSpc Entity checks available table space in an MySQL InnoDB database. The Entity logs in to the specified host using the configured credentials and issues the SQL command SHOW TABLE STATUS LIKE "Table".

This Entity requires the MySQL client be installed on the Agent.

Fields

DB: Name of the database to connect to.
Table: Name of the table to check the available space of.
Table: Name of the table to check the available space of.
User: User name to provide when logging into the database.
Pass: Password to provide when logging into the database.
Host: Database host to connect to.
Port: Port on database host to connect to.

Trigger

The Trigger fires if the number of kilobytes of free table space is less than the trigger value.

Prev	Home	Next
EventLog	Up	Log