Requirements
- php
- clickhouse
Installation
cd /optgit clone https://github.com/pinba-server/pinba-server.gitcd pinba-serverphp composer.phar installclickhouse-client -n < clickhouse/pinba.requests.sql
Usage
php workerman_clickhouse.php start -dphp workerman_clickhouse.php stop
Systemd autostart script
sudo cp systemd/pinba-server.service /usr/lib/systemd/system/pinba-server.servicesudo 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, 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