MySQL plugin and storage engine

Documentation
Support
Bugtracker
Pinba on GitHub

Pinba is a MySQL storage engine that acts as a realtime monitoring/statistics server for PHP using MySQL as a read-only interface.

It accumulates and processes data sent over UDP by multiple PHP processes and displays statistics in a nice human-readable form of simple "reports", also providing read-only interface to the raw data in order to make possible generation of more sophisticated reports and stats.

With Pinba extension users also can measure particular parts of the code using timers with arbitrary tags.

Pinba is not a debugging tool in a common sense, since you're not supposed to do debugging on production servers, but its main goal is to help developers to monitor performance of PHP scripts, locate bottlenecks in realtime and direct developers' attention to the code that really needs it.

Read on for more details.

Binary packages

Source code

Latest release: pinba_engine-1.0.0.tar.gz
Previous release: pinba_engine-0.0.6.tar.gz

Installation from sources

Interfaces

Clients

Even though Pinba was written with PHP in mind, any kind of client can create and send a Pinba packet to the server. Here are clients I know of:

Drop me an email if you know more.

Engine Changelog

1.0.0 - 17 Aug 2012
0.0.6 - 26 Nov 2010
0.0.5 - 19 Oct 2009
0.0.4 - 26 August 2009
0.0.3 - 04 May 2009
Preview release

PHP Extension Changelog

1.0.0 - 17 Aug 2012
0.0.6 - 26 Nov 2010
0.0.5 - 19 Oct 2009
0.0.4 - 26 Aug 2009
0.0.3 - 04 May 2009
Initial release.