Skip to main content

MySQL table space monitoring.

Project description

# MySQL Table Space Graphing

![Build Status](

#### Table of contents

1. [Overview] (#overview)
2. [Usage] (#usage)
3. [Notices] (#notices)
4. [Installation] (#installation)
5. [Development] (#development)

## Overview
This program put in statsd (graphite stack) some metrics about your database
and table space consumption.

For all your databases/tables, you will have

- data_length: size of the table
- index_length: size of the index
- data_free: free space in table space
- row_count: the (approximative) number of rows

## Usage

usage: mytsgraph [-h] --config CONFIG

optional arguments:
-h, --help show this help message and exit
--config CONFIG, -c CONFIG
Configuration file


## Notices
- It could be very slow (especially on heavy loaded servers or servers with a
huge databases/tables count.
You surely want to run this tool on a slave instead of a master

## Installation [pypi link](

To install it with a [Python virtualenv](

$> virtualenv myenv
$> source myenv/bin/activate
(myenv) $> pip install mytsgraph
(myenv) $> mysql-monitor -h

Or on your system, without virtualenv:

$> pip install mytsgraph
$> mysql-monitor -h

## Retention policy

I suggest to use a not fine grained retention since this script should be used
only a few time a day. Something like this should be enough:

pattern = database.*
retentions = 4h:3y

## Development

To start hacking on the project, run:

$> virtualenv myenv
$> source myenv/bin/activate
(myenv) $> pip install -e .
(myenv) $> mytsgraph -h

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for mytsgraph, version 1.0.1
Filename, size File type Python version Upload date Hashes
Filename, size mytsgraph-1.0.1.tar.gz (3.8 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page