Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

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.

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 hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page