I already talked about Pinba, this great Application Performance Monitoring (APM) tool that is made of :
- a MySQL storage engine (pinba-mysql-5.5),
- a PHP extension (php5-pinba),
- and even a python module, pynba, (thanks to my IsCool Entertainment friends) and an experimental Nginx module.
But since MySQL 5.1 support has been discontinued on Dotdeb, it was impossible to install the Pinba MySQL storage engine, just because it depended on a non-existant MySQL 5.1 version.
This problem is now fixed and I’m proud to announce that the Pinba storage engine version 1.0.0 is now compatible with Dotdeb’s MySQL 5.5 packages. Just install the pinba-mysql-5.5 package and add the following line to your MySQL configuration file :
plugin-load=libpinba_engine.so
About the PHP extensions, they will be updated from version 0.0.6 to version 1.0.0 with the upcoming PHP 5.4.6 and 5.3.16 packages.
Please visit the Pinba website fore more info (changes, installation, support…).
mikhal
Is this safe with yours mysql percona package (5.5.25a-27.1-log)? When i try to install, it ask to install mysql-server-core-5.5
apt-get install pinba-mysql-5.5
….
The following NEW packages will be installed:
libjudydebian1 libprotobuf-lite6 mysql-server-core-5.5 pinba-mysql-5.5
Guillaume Plessis
@mikhal : Sadly, because of the internal MySQL storage engine mechanics, Pinba from Dotdeb is strongly tied with the MySQL version it has been built against. You’ll have to :
mikhal
@Guillaume Plessis, seems i have to install mysql 5.5 to another server to collect pinba data and do not corrupt production server
thanks for the answer and for this cool site with latest builds
silver price
To upgrade to 5.1 from any previous version, MySQL recommends that you dump your tables with mysqldump before upgrading and reload the dump file after upgrading.
Mayur Ahir
I am getting this error,
# sudo apt-get install php5-pinba
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
php5-pinba : Depends: libprotobuf6 but it is not installable
E: Unable to correct problems, you have held broken packages.
Please help.
Guillaume Plessis
@Mayur Ahir : sorry, but libprotobuf6 is present in Debian Squeeze :
http://packages.debian.org/search?keywords=libprotobuf6
You can know what is preventing libprotobuf6 from installing by using a decent package manager, such as dselect or aptitude