Requirements

• php
• clickhouse

Installation

• cd /opt
• git clone https://github.com/pinba-server/pinba-server.git
• cd pinba-server
• php composer.phar install
• clickhouse-client -n < clickhouse/pinba.requests.sql

Usage

• php workerman_clickhouse.php start -d
• php workerman_clickhouse.php stop

Systemd autostart script

• sudo cp systemd/pinba-server.service /usr/lib/systemd/system/pinba-server.service
• sudo systemctl daemon-reload && systemctl enable pinba-server && systemctl start pinba-server

Stats for 24 hours with about 10 RPS on php-fpm and 450 RPS on nginx:

table	rows	size, Mb	description
requests	1kk	26	raw data
report_by_all	56k	2	aggregated data by minutes
nginx_requests	45kk	0	raw data, engine=null
nginx_report_by_all	300k	9	aggregated data by minutes

Info

• publications: reddit(en), habr(ru)
• the installation of ClickHouse, pinba-server, pinba module for php and nginx on Ubuntu 18.04 LTS and Centos 7.

Grafana

dashboard #10011

License

MIT License.

See also

• ClickHouse-Ninja/Proton - golang version of pinba-server for clickhouse
• olegfedoseev/pinba-influxdb - golang version of pinba-server for influxdb
• nginxhouse - nginx logs visualizer