Pinba - andreydiveev/wiki GitHub Wiki

# apt-get install cmake libncurses5-dev libevent-dev libjudy-dev curl libcurl3 libcurl3-dev php5 php5-mysql php5-fpm php5-curl dpkg-dev git mc automake libtool nginx

# locale-gen

# apt-get source mysql-server-5.5
# cd mysql-5.5-5.5.47/
# cmake .
# make
# make install

# cd ../
# git clone 'https://github.com/tony2001/pinba_engine'
# cd pinba_engine/
# ./buildconf.sh

# cd ../
# cp -R mysql-5.5-5.5.47/ /var/tmp/mysql-5.5-5.5.47
# cd pinba_engine/

# ./configure --with-mysql='/var/tmp/mysql-5.5-5.5.47' --with-judy --with-event --libdir='/usr/lib/mysql/plugin/'
# make
# make install

# mysql --execute="INSTALL PLUGIN pinba SONAME 'libpinba_engine.so';" --user=root -p
# mysql --execute="CREATE DATABASE pinba DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;" --user=root -p
# mysql --user=root -p 'pinba' < 'default_tables.sql'
# mysql --user=root -p --execute="grant all on pinba.* to pinba@localhost identified by 'password'" -p

# touch /etc/mysql/conf.d/pinba.cnf
# mcedit /etc/mysql/conf.d/pinba.cnf

pinba.conf

pinba_port = 30002
pinba_address = 127.0.0.1
pinba_stats_gathering_period = 10000
pinba_stats_history = 900
pinba_temp_pool_size = 10000
pinba_request_pool_size = 10000

Restarting MySQL:

# service mysql restart

Intaro Pinboard:

# cd ~/
# curl -sS https://getcomposer.org/installer | php

# cd /var/www/
# git clone git://github.com/intaro/pinboard.git
# cd pinboard/
# php ~/composer.phar install

# ./console migrations:migrate
# ./console register-crontab

# mcedit /etc/nginx/sites-available/pinboard.conf
# ln -s /etc/nginx/sites-available/pinboard.conf /etc/nginx/sites-enabled/pinboard.conf

# service nginx restart

/var/www/pinboard/config/parameters.yml

db:
    host: 127.0.0.1
    name: pinba
    user: pinba
    pass: password
base_url: /
logging:
    long_request_time:
        global: !!float 1
    heavy_request:
        global: 30000
    heavy_cpu_request:
        global: 1
locale: en
#cache: apc
cache: array
records_lifetime: P1M
aggregation_period: PT15M
pagination:
    row_per_page: 50
secure:
    enable: false

/etc/nginx/sites-available/pinboard.conf

server {
    listen 80;
    server_name pinba.ourdomian;
    access_log /var/log/nginx/pinba.access.log;
    error_log /var/log/nginx/pinba.error.log;
    root /var/www/pinboard/web;

    location = / {
        try_files @site @site;
    }

    location / {
        try_files $uri $uri/ @site;
    }

    location ~ \.php$ {
       return 404;
    }

    location @site {
        fastcgi_pass unix:///var/run/php5-fpm.sock;
        include fastcgi_params;
        fastcgi_param  SCRIPT_FILENAME $document_root/index.php;
    }

    location ~ /\.(ht|svn|git) {
        deny  all;
    }
}

Link:

https://prudnitskiy.pro/2015/11/26/pinba/
https://howto.biapy.com/en/debian-gnu-linux/servers/mysql/install-pinba-mysql-engine-on-debian