Skip to main content

MySQL table space monitoring.

Project description

# MySQL Table Space Graphing

![Build Status](https://travis-ci.org/dalenys/mytsgraph.svg?branch=master)

#### 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
BE CAREFUL:
- 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](https://pypi.python.org/pypi/mytsgraph/)

To install it with a [Python virtualenv](http://docs.python-guide.org/en/latest/dev/virtualenvs/)
(recommended):

```
$> 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:

```
[mytsgraph]
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.

Source Distribution

mytsgraph-1.0.1.tar.gz (3.8 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page