zortje/mysql-keeper

Find incorrect configurations or missed optimization opportunities in MySQL databases

MySQL Keeper

Find incorrect configurations or missed optimization opportunities in MySQL databases., _(*1)

, _(*2)

, _(*3)

Features

Detects the following issues, _(*4)

• Duplicate indices
• Missing primary key on auto_increment column
• Redundant unique index on primary key
• Redundant key index on primary key
• Inconsistent usage of collation between table and columns

Installing via Composer

The recommended way to install MySQL Keeper is though Composer., _(*5)

{
    "require": {
        "zortje/mysql-keeper": "~0.0"
    }
}

Usage

$pdo = new PDO('mysql:host=127.0.0.1;dbname=myapp', 'root', '');

$database = DatabaseFactory::create($pdo);
$databaseResult = $database->getResult();

The $databaseResult array will look something like this with the first level keys being table names., _(*6)

[
    'users' => [
        'issues' => [
            [
                'type' => 'field',
                'field' => 'id',
                'description' => 'Set as auto_increment but has no primary key'
            ],
            [
                'type' => 'field',
                'field' => 'id',
                'description' => 'Set as auto_increment but is not set as primary'
            ]
        ],
        'optimizations' => [
            [
                'type' => 'field',
                'field' => 'id',
                'description' => 'Field should be unsigned, as no field values are negative'
            ]
        ]
    ]
];

Usage with Melody

Melody allows inline Composer requirements to simply execute PHP scripts., _(*7)

mysql-keeper_myapp.php, _(*8)

<?php

<<<CONFIG
packages:
    - "zortje/mysql-keeper": "~0.0"
CONFIG;

$pdo = new PDO('mysql:host=127.0.0.1;dbname=myapp', 'root', '');

$database = Zortje\MySQLKeeper\DatabaseFactory::create($pdo);

print_r($database->getResult());

Simply run:, _(*9)

$ melody run mysql-keeper_myapp.php