QOS User's Manual
Prev		Next

MyInnoTbSpc

Name

MyInnoTbSpc -- Check MySQL InnoDB table space sizes

Synopsis

{ 'type'    : 'MyInnoTbSpc' ,
  'subents' : [
                {
                  'name'    : 'website',
                  'MyDB'    : 'website',
                  'MyUser'  : 'monitor',
                  'MyPass'  : 'abcd1234',
                  'MyHost'  : 'db1.example.com',
                  'Port'    : '3306',
                  'status'  : 'on' ,
                  'triggers': [{ 'level' : 'info',     'trigger' : '50000'}, 
                               { 'level' : 'critical', 'trigger' : '20000'}, ],
                 },
              ],
}

Description

The MyInnoTbSpc 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.

This agent is different from the InnoTbSpc entity by using a Python module to access the database, as opposed to running the mysql command. InnoTbSpc can also query the size of a specific table rather than viewing all of the tables on the system.

This Entity requires the MySQL client and the MySQL Python module be installed on the Agent.

Fields

MyDB: Name of the database to connect to.
MyUser: User name to provide when logging into the database.
MyPass: Password to provide when logging into the database.
MyHost: Database host to connect to. If this field is omitted then the Entity defaults to connecting to localhost.

Trigger

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

Prev	Home	Next
Mem	Up	ODS