js/mysqlnd-analytics

The JSMysqlndAnalytics library is a library to process statistics collected by PHP's myslqnd module and providing guidance for improving applications using ext/mysql, mysqli or pdo_mysql.

v1.1.1 2014-03-31 16:46 UTC

Requires

• php: >=5.3.2
• ext-mysqli: *
• ext-mysqlnd: *
• rezzza/formulate: 1.0.*

BSD-3-Clause

• Johannes Schlüter
• JSMysqlndAnalytics Community

• database
• mysql
• mysqlnd
• profiler

README

The Mysqlnd Analytics library provides a way for an application to easily collect statistics about MySQL operations for a given period by making use of mysqlnd's statistic collection. This library then provides analytics on top of these statistics to help the user to improve his application.

Requirements

For making use of this library need an application running on a PHP setup where the mysqli extension is activated and mysqlnd is being used. The mysqli extension is only used to retrieve data. It is no requirement for your application to use to use mysqli. Applications using Doctrine and PDO are fully supported.

This library depends on rezzza/Formulate.

Composer

This library can be installed using composer:

$ php composer.phar require "js/mysqlnd-analytics=dev-master"

Take a look at the page on Packagist web site for more details and up-to-date version numbers.

Usage Example

A simple use case might llook like this:

<?php
use JS\Mysqlnd\Analytics\Engine;
use JS\Mysqlnd\Analytics\DefaultRuleProvider;
use JS\Mysqlnd\Analytics\Calculator;
use JS\Mysqlnd\Analytics\Collector;

$collector = new Collector();
$collector->start();
/* run ext/mysql, mysqli or PDO_mysql queries */

$data = $collector->collect();
$analytics = new Engine(new DefaultRuleProvider(), new Calculator($data));

foreach ($analytics as $analytic) {
    if ($analytic->getMatched()) {
        echo $analytic->getName() . '(Severity: '. $analytic->getSeverity() . ")\n";
        echo $analytic->getGuidance()."\n\n";
    }
}

Notes

For Symfony applications an bundle using this library exists.