Pinba engine 1.0.0

August 17, 2012 · Guillaume Plessis

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 August 17, 2012
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 August 18, 2012
  @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 :
  - install MySQL 5.5 from Dotdeb if you want to install pinba-mysql-5.5
  - or rebuild pinba-mysql-5.5 against your MySQL/Percona version (might be tricky)
mikhal August 18, 2012
@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 August 28, 2012
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 December 11, 2012
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 December 11, 2012
  @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
Ovidiu May 17, 2014
trying to install:
‘apt-get install pinba-engine-mysql-5.5 -u 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: pinba-engine-mysql-5.5 : Depends: mysql-server-core-5.5 (< 5.5.36) but 5.5.37-0+wheezy1 is to be installed E: Unable to correct problems, you have held broken packages.'
'apt-get install mysql-server-core-5.5 -u -s Reading package lists… Done Building dependency tree Reading state information… Done The following NEW packages will be installed: mysql-server-core-5.5 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Inst mysql-server-core-5.5 (5.5.37-0+wheezy1 Debian-Security:7.0/stable [amd64]) Conf mysql-server-core-5.5 (5.5.37-0+wheezy1 Debian-Security:7.0/stable [amd64])'
So I guess I need to install mysql-server-core-5.5 from Dotdeb not from Debian-Security
Can I get a hint on how to do that?
- Guillaume Plessis May 17, 2014
  @Ovidiu : sorry, I have to rebuild pinba-engine-mysql-5.5 against the latest packages from Debian security to satisfy the dependency. It should be fixed in the next few hours.
  - Ovidiu May 17, 2014
    Awesome! No stress!
  - Ovidiu May 24, 2014
    Hi Guillaume,
    did you get a chance to look at this?
    - Guillaume Plessis May 27, 2014
      @Ovidiu : Yes, sorry for the delay. I just updated the pinba-mysql-engine packages to match MySQL 5.5.37 from Wheezy.
Ovidiu May 28, 2014
Does this error ring any bells with you? Will also google it, thought to ask here first…
An error occurred while installing the database: │ │ mysql said: ERROR 1126 (HY000) at line 1: Can’t open shared library │ ‘/usr/lib/mysql/plugin/libpinba_engine.so’ (errno: 2 │ /usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: │ _ZN7handler22read_multi_range_firstEPP18st_key_multi_rangeS1_jbP17st) │ │ If at this point you choose “retry”, you will be prompted with all the │ configuration questions once more and another attempt will be made at performing
- Guillaume Plessis May 28, 2014
  @Ovidiu : I’ll take a further look and keep you posted. Could you please give me the result of this command?
```
dpkg -l '*mysql*' | grep '^.i'
```
  Thanks
Ovidiu June 2, 2014
sorry,was out of town and offline :-/
dpkg -l ‘mysql’ | grep ‘^.i’ ii dovecot-mysql 1:2.1.7-7 amd64 MySQL support for Dovecot ii libdbd-mysql-perl 4.021-1+b1 amd64 Perl5 database interface to the MySQL database ii libmysqlclient18:amd64 5.6.17-1~~dotdeb.1 amd64 MySQL database client library ii mysql-client 5.6.17-1~~dotdeb.1 all MySQL database client (metapackage depending on the latest version) ii mysql-client-5.5 5.5.37-0+wheezy1 amd64 MySQL database client binaries ii mysql-client-5.6 5.6.17-1~~dotdeb.1 amd64 MySQL database client binaries ii mysql-client-core-5.6 5.6.17-1~~dotdeb.1 amd64 MySQL database core client binaries ii mysql-common 5.6.17-1~~dotdeb.1 all MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.6.17-1~~dotdeb.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.6 5.6.17-1~~dotdeb.1 amd64 MySQL database server binaries and system database setup ii mysql-server-core-5.5 5.5.37-0+wheezy1 amd64 MySQL database server binaries ii mysql-server-core-5.6 5.6.17-1~~dotdeb.1 amd64 MySQL database server binaries ii mysql-utilities 1.0.5-1 all collection of scripts for managing MySQL servers ii php5-mysqlnd 5.4.28-1~~dotdeb.1 amd64 MySQL module for php5 (Native Driver) ii pinba-engine-mysql-5.5 1.0.0-4~~dotdeb.2 amd64 realtime statistics server for PHP using MySQL as a read-only interface ii postfix-mysql 2.9.6-2 amd64 MySQL map support for Postfix ii pure-ftpd-mysql 1.0.36-1.1 amd64 Secure and efficient FTP server with MySQL user authentication ii python-mysql.connector 0.3.2-1 all pure Python implementation of MySQL Client/Server protocol ii python-mysqldb 1.2.3-2 amd64 Python interface to MySQL
- Guillaume Plessis June 9, 2014
  @Ovidiu : the Pinba storage engine has been build against MySQL 5.5. Could you please install ‘*-5.5’ packages only and try to load the module?
  - Ovidiu June 12, 2014
    Hi Guillaume,
    I tried fixing it on my own for a few days then gave up and removed it alltogether. Didn’T have the time to keep trying and fixing it. Maybe with the next release I’ll try again.
Phil August 5, 2014
Hi, there is still a error in pinba:
pinba-engine-mysql-5.5 : Depends: mysql-server-core-5.5 (< 5.5.38) but 5.5.38-0+wheezy1 is to be installed
- Guillaume Plessis August 20, 2014
  @Phil : sorry for that, packages with updated dependencies are currently building.

sudo apt-get install php5-pinba