{"id":32681,"date":"2019-10-31T21:48:22","date_gmt":"2019-10-31T18:48:22","guid":{"rendered":"https:\/\/prohoster.info\/blog\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\/"},"modified":"2019-10-31T21:48:22","modified_gmt":"2019-10-31T18:48:22","slug":"statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","title":{"rendered":"Statistika dhe monitorimi i skripteve PHP n\u00eb koh\u00eb reale. ClickHouse dhe Grafana vijn\u00eb n\u00eb ndihm\u00eb t\u00eb Pinba","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>N\u00eb k\u00ebt\u00eb artikull do t\u00eb flas p\u00ebr p\u00ebrdorimin e pinba n\u00eb bashk\u00ebpunim me clickhouse dhe grafana n\u00eb vend t\u00eb pinba_engine dhe pinboard.<\/p>\n<p>N\u00eb projektin php, pinba \u00ebsht\u00eb ndoshta m\u00ebnyra e vetme e besueshme p\u00ebr t\u00eb kuptuar se \u00e7far\u00eb po ndodh me performanc\u00ebn. Megjithat\u00eb, zakonisht pinba zbatohet vet\u00ebm n\u00eb momentin kur fillojn\u00eb t\u00eb shfaqen probleme dhe nuk dihet \u00abku t\u00eb g\u00ebrmohet\u00bb.<\/p>\n<p>Shpesh askush nuk ka ide se sa her\u00eb n\u00eb sekond\u00eb\/minut\u00eb ftohet nj\u00eb skenar dhe fillojn\u00eb optimizimet \u00abme ndjesi\u00bb, duke filluar nga ato vende q\u00eb duken m\u00eb logjike.<\/p>\n<p>Disa analizojn\u00eb loget nginx, nd\u00ebrsa disa t\u00eb tjer\u00eb k\u00ebrkesat e ngadalta n\u00eb db.<\/p>\n<p>Sigurisht q\u00eb pinba nuk do t\u00eb ishte e tep\u00ebrt, por ka disa arsye pse ajo nuk \u00ebsht\u00eb n\u00eb \u00e7do projekt.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/br\/zm\/qz\/brzmqzc8itwc2lt3gjp0q2p-kse.png\"><img decoding=\"async\" alt=\"Statistika dhe monitorimi i skripteve PHP n\u00eb koh\u00eb reale. ClickHouse dhe Grafana vijn\u00eb n\u00eb ndihm\u00eb t\u00eb Pinba\" src=\"\/wp-content\/uploads\/2019\/04\/cdf2dc9af2a131d1f9aaef6bbde9b914.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nArsyeja e par\u00eb \u00ebsht\u00eb instalimi.<\/p>\n<p>P\u00ebr t\u00eb marr\u00eb ndonj\u00eb lloj \u00abrezultati\u00bb nga implementimi i pinb\u00ebs, \u00ebsht\u00eb shum\u00eb e d\u00ebshirueshme t\u00eb shihet metrikat jo vet\u00ebm p\u00ebr minutat e fundit, por edhe p\u00ebr nj\u00eb periudh\u00eb m\u00eb t\u00eb gjat\u00eb kohe (nga dit\u00eb n\u00eb muaj).<\/p>\n<p>P\u00ebr k\u00ebt\u00eb \u00ebsht\u00eb e nevojshme:<\/p>\n<ul>\n<li>t\u00eb instaloni nj\u00eb ekstension p\u00ebr php (dhe ndoshta do t\u00eb d\u00ebshironit nj\u00eb modul p\u00ebr nginx)<\/li>\n<li>t\u00eb kompiloni ekstensionin p\u00ebr mysql<\/li>\n<li>t\u00eb instaloni pinboard dhe t\u00eb konfiguroni cron<\/li>\n<\/ul>\n<p>\nP\u00ebr shkak t\u00eb informacionit t\u00eb pamjaftuesh\u00ebm rreth pinb\u00ebs, shum\u00eb jan\u00eb krijuar p\u00ebrshtypjen se ajo punonte vet\u00ebm n\u00eb php5 dhe ka mbetur n\u00eb t\u00eb kaluar\u00ebn, por si\u00e7 do t\u00eb shohim m\u00eb von\u00eb \u2014 kjo nuk \u00ebsht\u00eb e v\u00ebrtet\u00eb.<\/p>\n<p>Hapi i par\u00eb \u2014 m\u00eb i lehti, vet\u00ebm duhet t\u00eb ekzekutoni komand\u00ebn:<\/p>\n<pre><code class=\"bash\">apt install php-pinba<\/code><\/pre>\n<p>\nN\u00eb depo, ky ekstension \u00ebsht\u00eb deri n\u00eb php 7.3 p\u00ebrfshir\u00eb dhe nuk keni nevoj\u00eb t\u00eb kompilon ndonj\u00eb gj\u00eb.<\/p>\n<p>Pas ekzekutimit t\u00eb komand\u00ebs s\u00eb instalimit, ne menj\u00ebher\u00eb marrim nj\u00eb zgjerim t\u00eb pun\u00ebs, i cili mbledh dhe d\u00ebrgon metrikat e \u00e7do skripti (koha e ekzekutimit, memoria, etj.) n\u00eb formatin <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/Protocol_Buffers\">protobuf<\/a><\/noindex> n\u00eb udp n\u00eb 127.0.0.1:30002.<\/p>\n<p>K\u00ebto paketa udp ende nuk ka kush i kap dhe i p\u00ebrpunon, por kjo nuk ndikon aspak n\u00eb shpejt\u00ebsin\u00eb apo stabilitetin e pun\u00ebs s\u00eb skripteve tuaja php.<\/p>\n<p>Derisa s\u00eb fundmi si aplikacion, i cili mund t\u00eb kap\u00eb dhe p\u00ebrpunoj\u00eb k\u00ebto paketa udp ishte vet\u00ebm <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tony2001\/pinba_engine\">pinba_engine<\/a><\/noindex>. P\u00ebrshkrimi &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tony2001\/pinba_engine\/wiki\/Installation\">i thjesht\u00eb dhe konciz<\/a><\/noindex>&#187; i instalimit ndalon d\u00ebshir\u00ebn p\u00ebr ta lexuar ndonj\u00ebher\u00eb p\u00ebrs\u00ebri dhe p\u00ebr t'u angazhuar. N\u00eb listat kilometrike t\u00eb var\u00ebsive ka si emrat e paketeve, ashtu edhe emrat e programeve dhe lidhjet n\u00eb faqet e tyre t\u00eb ve\u00e7anta p\u00ebr instalimin, dhe ato kan\u00eb lidhjet e tyre n\u00eb var\u00ebsi t\u00eb tjera. T\u00eb merresh me k\u00ebt\u00eb kaos askush nuk ka koh\u00eb dhe d\u00ebshir\u00eb.<\/p>\n<p>Procesi i instalimit <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/badoo\/pinba2\">pinba2<\/a><\/noindex> nuk u b\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/badoo\/pinba2\/blob\/master\/docs\/index.md#installation\">ve\u00e7an\u00ebrisht m\u00eb i leht\u00eb<\/a><\/noindex>.<\/p>\n<p>Ndoshta ndonj\u00ebher\u00eb pinba10 do t\u00eb mund t\u00eb instalohet me nj\u00eb ose dy komanda dhe pa lexuar nj\u00eb grumbull materialesh p\u00ebr t\u00eb kuptuar si ta b\u00ebsh, por p\u00ebr momentin nuk \u00ebsht\u00eb k\u00ebshtu.<\/p>\n<p>N\u00ebse megjithat\u00eb keni instaluar pinba_engine, kjo \u00ebsht\u00eb vet\u00ebm gjysma e pun\u00ebs. Sepse pa <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/intaro\/pinboard\">pinboard<\/a><\/noindex> do t'ju duhet t\u00eb kufizoheni me t\u00eb dh\u00ebnat vet\u00ebm p\u00ebr minutat e fundit ose t\u00eb gruponi vet\u00eb, ruani dhe vizualizoni t\u00eb dh\u00ebnat. E mira \u00ebsht\u00eb se pinboard \u00ebsht\u00eb mjaft e thjesht\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/intaro\/pinboard\/wiki\/Installation\">instalimin<\/a><\/noindex>.<\/p>\n<p>Duket se, pse t\u00eb duroni nj\u00eb mundim t\u00eb till\u00eb n\u00ebse t\u00eb gjitha metrikat nga php tashm\u00eb shkojn\u00eb n\u00eb portin udp n\u00eb formatin protobuf dhe gjith\u00e7ka q\u00eb nevojitet \u00ebsht\u00eb t\u00eb shkruhet nj\u00eb aplikacion q\u00eb do t'i kap\u00eb dhe t'i ruaj\u00eb n\u00eb ndonj\u00eb magazin\u00eb? Duket se atyre zhvillueseve q\u00eb kjo mendim iu ka shkuar n\u00ebp\u00ebr mendje, menj\u00ebher\u00eb jan\u00eb ulur p\u00ebr t\u00eb shkruar bi\u00e7ikletat e tyre, disa prej t\u00eb cilave arrit\u00ebn n\u00eb github.<\/p>\n<p>M\u00eb pas ndjek nj\u00eb p\u00ebrmbledhje t\u00eb kat\u00ebr projekteve open source, t\u00eb cilat ruajn\u00eb metrikat n\u00eb magazina, nga t\u00eb cilat t\u00eb dh\u00ebnat jan\u00eb leht\u00ebsisht t\u00eb aksesueshme dhe t\u00eb vizualizueshme, p\u00ebr shembuj, me ndihm\u00ebn e grafana.<\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-server\">olegfedoseev\/pinba-server<\/a><\/noindex> (n\u00ebntor 2017) <\/h4>\n<p>\nserver udp n\u00eb go, i cili ruan metrikat n\u00eb OpenTSDB. Ndoshta n\u00ebse OpenTSDB \u00ebsht\u00eb tashm\u00eb p\u00ebrdorur n\u00eb projekt, at\u00ebher\u00eb ky zgjidhje do t'ju p\u00ebrshtatet ndryshe, rekomandoj t\u00eb kaloni larg.<\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-influxdb\">olegfedoseev\/pinba-influxdb<\/a><\/noindex> (qershor 2018)<\/h4>\n<p>\nserver udp n\u00eb go, nga i nj\u00ebjti <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/users\/Aryoh\/\">habrayuser<\/a><\/noindex>, i cili k\u00ebt\u00eb her\u00eb ruan metrikat n\u00eb InfluxDB. N\u00eb shum\u00eb projekte p\u00ebr monitorimin tashm\u00eb po p\u00ebrdoret InfluxDB, k\u00ebshtu q\u00eb p\u00ebr ta kjo zgjidhje mund t\u00eb p\u00ebrshtatet shum\u00eb mir\u00eb.<\/p>\n<p>Avantazhet:<\/p>\n<ul>\n<li>InfluxDB <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-influxdb#influxdb-preparation\">lejon<\/a><\/noindex> t\u00eb grupohen metrikat e marra, nd\u00ebrsa origjinali t\u00eb fshihet pas nj\u00eb kohe t\u00eb caktuar.<\/li>\n<\/ul>\n<p>\nDisavantazhet:<\/p>\n<ul>\n<li>ky zgjidhje nuk ruan informacionin mbi timerat.<\/li>\n<li>InfluxDB do t\u00eb ruaj\u00eb adresat e faqeve t\u00eb internetit si etiketat dhe n\u00ebse keni shum\u00eb adresa unike faqeje, kjo do t\u00eb \u00e7oj\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/449352\/#comment_20085878\">shpenzimin e shtuar<\/a><\/noindex> t\u00eb memories operative. Nga nj\u00eb moment e tutje ai &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/2v\/68\/th\/2v68thch8ajln7abt-ghsmsbxgs.png\">do t\u00eb filloj\u00eb t\u00eb haj\u00eb memorie si t\u00eb \u00e7mendur<\/a><\/noindex>&#171;. (<noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@valyala\/insert-benchmarks-with-inch-influxdb-vs-victoriametrics-e31a41ae2893\">burimi<\/a><\/noindex>)<\/li>\n<\/ul>\n<p><\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClickHouse-Ninja\/Proton\">ClickHouse-Ninja\/Proton<\/a><\/noindex> (janar 2019) <\/h4>\n<p>\nserver udp n\u00eb go, i cili ruan metrikat n\u00eb ClickHouse. Ky zgjidhje \u00ebsht\u00eb nga shoku im. Pik\u00ebrisht pas njohjes me t\u00eb, vendosa se ishte koha t\u00eb merrem me pinb\u00ebn dhe clickhouse.<\/p>\n<p>Avantazhet:<\/p>\n<ul>\n<li>clickhouse p\u00ebrshtatet perfekt p\u00ebr k\u00ebto detyra, ai lejon t\u00eb kompresosh t\u00eb dh\u00ebnat aq shum\u00eb, saq\u00eb mund t\u00eb ruash t\u00eb gjitha t\u00eb dh\u00ebnat e pap\u00ebrpunuara edhe pa agregime<\/li>\n<li>n\u00ebse nevojitet, mund t\u00eb gruposh metrikat e marra leht\u00ebsisht<\/li>\n<li>nj\u00eb model t\u00eb gatsh\u00ebm p\u00ebr grafana<\/li>\n<li>ruan informacionin mbi timerat<\/li>\n<\/ul>\n<p>\nDisavantazhet:<\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/lurkmore.to\/%D0%A4%D0%B0%D1%82%D0%B0%D0%BB%D1%8C%D0%BD%D1%8B%D0%B9_%D0%BD%D0%B5%D0%B4%D0%BE%D1%81%D1%82%D0%B0%D1%82%D0%BE%D0%BA\">mang\u00ebsi fatale<\/a><\/noindex><\/li>\n<li>nuk ka asnj\u00eb konfigurim ku mund t\u00eb caktohet emri i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave dhe tabelave, adresa dhe porta e serverit.<\/li>\n<li>kur ruani t\u00eb dh\u00ebna t\u00eb pap\u00ebrpunuara, p\u00ebrdoret nj\u00eb tabel\u00eb ndihm\u00ebse p\u00ebr ruajtjen e adresave t\u00eb faqeve dhe domain\u00ebve, gj\u00eb q\u00eb e komplikon m\u00eb von\u00eb k\u00ebrkesat.<\/li>\n<li>detaje t\u00eb tjera t\u00eb vogla q\u00eb rrjedhin nga minus i par\u00eb.<\/li>\n<\/ul>\n<p><\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\">pinba-server\/pinba-server<\/a><\/noindex> (prill 2019) <\/h4>\n<p>\nserveri UDP n\u00eb PHP, i cili ruan metrikat n\u00eb ClickHouse. Ky \u00ebsht\u00eb zgjidhja ime, q\u00eb \u00ebsht\u00eb rezultati i njohjes me pinba, ClickHouse dhe protobuf. Nd\u00ebrsa po merresha me t\u00eb gjith\u00eb k\u00ebt\u00eb lidhje, shkrova nj\u00eb 'prov\u00eb koncepti', e cila p\u00ebr habin\u00eb time nuk konsumonte burime t\u00eb konsiderueshme (30 MB RAM dhe n\u00ebn 1% t\u00eb nj\u00eb prej tet\u00eb b\u00ebrthamave t\u00eb procesorit), p\u00ebr k\u00ebt\u00eb arsye vendosa ta ndaj at\u00eb me publikun.<\/p>\n<p>P\u00ebrpar\u00ebsit\u00eb jan\u00eb t\u00eb nj\u00ebjta si ato t\u00eb zgjidhjes s\u00eb m\u00ebparshme, gjithashtu kam p\u00ebrdorur emrat e njohur nga pinba_engine origjinale. Gjithashtu, kam shtuar nj\u00eb konfigurim q\u00eb lejon t\u00eb filloni menj\u00ebher\u00eb disa instanca t\u00eb serverit pinba p\u00ebr t\u00eb ruajtur metrikat n\u00eb tabela t\u00eb ndryshme \u2014 kjo \u00ebsht\u00eb e dobishme n\u00ebse d\u00ebshironi t\u00eb mbledhni t\u00eb dh\u00ebna jo vet\u00ebm nga PHP, por edhe nga Nginx.<br \/>\nMinuset \u2014 'mang\u00ebsi fatale' dhe ato detaje q\u00eb ndoshta nuk do t'ju p\u00eblqejn\u00eb, por zgjidhja ime \u00ebsht\u00eb 'e thjesht\u00eb si sandali' dhe p\u00ebrb\u00ebhet vet\u00ebm nga rreth 100 rreshta kodi, k\u00ebshtu q\u00eb \u00e7do zhvillues PHP mund t\u00eb b\u00ebj\u00eb disa ndryshime p\u00ebr disa minuta.<\/p>\n<p><b>Parimi i funksionimit<\/b><\/p>\n<p>Porti UDP 30002 d\u00ebgjohet. T\u00eb gjitha paketat e ardhshme dekodohen sipas skem\u00ebs protobuf dhe grumbullohen. Nj\u00eb her\u00eb n\u00eb minut\u00eb b\u00ebhet nj\u00eb futur grupi n\u00eb ClickHouse n\u00eb tabel\u00ebn pinba.requests. (t\u00eb gjitha parametrat jan\u00eb t\u00eb konfiguruesh\u00ebm n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/blob\/master\/config.json\">konfigurim<\/a><\/noindex>)<\/p>\n<p><b>Pak p\u00ebr ClickHouse<\/b><\/p>\n<p>ClickHouse mb\u00ebshtet engine t\u00eb ndryshme p\u00ebr ruajtjen e t\u00eb dh\u00ebnave. M\u00eb s\u00eb shpeshti p\u00ebrdoret \u2014 MergeTree. <\/p>\n<p>N\u00ebse ndonj\u00ebher\u00eb vendosni t\u00eb ruani t\u00eb dh\u00ebna t\u00eb grumbulluara p\u00ebr gjith\u00eb koh\u00ebn, nd\u00ebrsa ato t\u00eb pap\u00ebrpunuara vet\u00ebm p\u00ebr t\u00eb fundit, mund t\u00eb krijoni nj\u00eb pamje t\u00eb materializuar me grupim, nd\u00ebrsa tabela kryesore pinba.requests pastaj do t\u00eb pastrohet periodikisht, duke ruajtur t\u00eb gjitha t\u00eb dh\u00ebnat n\u00eb pamjen e materializuar. M\u00eb shum\u00eb, kur krijoni tabel\u00ebn pinba.requests mund t\u00eb tregoni 'engine = Null', k\u00ebshtu q\u00eb t\u00eb dh\u00ebnat e pap\u00ebrpunuara nuk ruhen n\u00eb disk dhe megjithat\u00eb ato do t\u00eb p\u00ebrfshihen n\u00eb pamjen e materializuar dhe t\u00eb ruhen t\u00eb grumbulluara. Un\u00eb p\u00ebrdor nj\u00eb skem\u00eb t\u00eb till\u00eb p\u00ebr metrikat Nginx, sepse kam rreth 50 her\u00eb m\u00eb shum\u00eb k\u00ebrkesa n\u00eb Nginx sesa n\u00eb PHP.<\/p>\n<p>K\u00ebshtu, keni kaluar nj\u00eb rrug\u00eb t\u00eb gjat\u00eb dhe nuk do t\u00eb doja t'ju lija n\u00eb mes t\u00eb rrug\u00ebs, k\u00ebshtu q\u00eb tani do t\u00eb jepet nj\u00eb p\u00ebrshkrim i detajuar i instalimit dhe konfigurimit t\u00eb zgjidhjes time dhe gjith\u00e7ka q\u00eb do t'ju nevojitet, si dhe pengesat, ndaj t\u00eb cilave jan\u00eb p\u00ebrplasje shum\u00eb anije. I gjith\u00eb procesi i instalimit \u00ebsht\u00eb p\u00ebrshkruar p\u00ebr Ubuntu 18.04 LTS dhe CentOS 7, n\u00eb shp\u00ebrndarje dhe versione t\u00eb tjera, procesi mund t\u00eb ndryshoj\u00eb pak.<\/p>\n<h4>Instalimi<\/h4>\n<p>\nT\u00eb gjitha komandat e nevojshme i kam nxjerr\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/tree\/master\/docker\">Dockerfile<\/a><\/noindex> p\u00ebr t\u00eb leht\u00ebsuar riprodhimin e instrukcioneve. M\u00eb posht\u00eb do t\u00eb p\u00ebrshkruhen vet\u00ebm pengesat.<\/p>\n<p><b>php-pinba<\/b><\/p>\n<p>Pas instalimit, sigurohuni q\u00eb n\u00eb skedarin \/etc\/php\/7.2\/fpm\/conf.d\/20-pinba.ini t\u00eb keni t\u00eb komentuar t\u00eb gjitha opsionet. N\u00eb disa shp\u00ebrndarje (p\u00ebr shembull, CentOS) ato mund t\u00eb jen\u00eb t\u00eb komentuar.<\/p>\n<pre><code class=\"plaintext\">extension=pinba.so\npinba.enabled=1\npinba.server=127.0.0.1:30002<\/code><\/pre>\n<p>\n<b>clickhouse<\/b><\/p>\n<p>Gjat\u00eb instalimit t\u00eb ClickHouse, do t\u00eb k\u00ebrkohet t\u00eb vendosni nj\u00eb fjal\u00ebkalim p\u00ebr p\u00ebrdoruesin default. N\u00eb m\u00ebnyr\u00eb t\u00eb paracaktuar ky p\u00ebrdorues \u00ebsht\u00eb i qassh\u00ebm nga t\u00eb gjitha IP-t\u00eb, k\u00ebshtu q\u00eb n\u00ebse nuk keni nj\u00eb firewall n\u00eb serverin tuaj, sigurohuni ta caktoni nj\u00eb fjal\u00ebkalim. Kjo mund t\u00eb b\u00ebhet gjithashtu pas instalimit n\u00eb skedarin \/etc\/clickhouse-server\/users.xml.<\/p>\n<p>Gjithashtu \u00ebsht\u00eb e r\u00ebnd\u00ebsishme t\u00eb mbani parasysh se ClickHouse p\u00ebrdor disa porte, p\u00ebrfshir\u00eb 9000. Ky port gjithashtu p\u00ebrdoret p\u00ebr PHP-FPM n\u00eb disa shp\u00ebrndarje (p\u00ebr shembull, CentOS). N\u00ebse ky port \u00ebsht\u00eb tashm\u00eb i p\u00ebrdorur, mund ta rregulloni n\u00eb nj\u00eb tjet\u00ebr n\u00eb skedarin \/etc\/clickhouse-server\/config.xml.<\/p>\n<p><b>Grafana me plugin p\u00ebr ClickHouse<\/b><\/p>\n<p>Pas instalimit t\u00eb Grafana, p\u00ebrdorni login admin dhe fjal\u00ebkalimin admin. N\u00eb hyrjen e par\u00eb, Grafana do t'ju k\u00ebrkoj\u00eb t\u00eb caktoni nj\u00eb fjal\u00ebkalim t\u00eb ri.<\/p>\n<p>M\u00eb pas, hyni n\u00eb menun\u00eb &#171;+&#187; -&gt; import dhe jepni numrin e dashboard-it p\u00ebr importim <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/dashboards\/10011\">10011<\/a><\/noindex>. Ky dashboard e kam p\u00ebrgatitur dhe ngarkuar, n\u00eb m\u00ebnyr\u00eb q\u00eb t\u00eb mos keni nevoj\u00eb ta b\u00ebni s\u00ebrish at\u00eb t\u00eb vet\u00eb.<\/p>\n<p>Grafana mb\u00ebshtet pun\u00ebn me ClickHouse p\u00ebrmes nj\u00eb plugin t\u00eb jasht\u00ebm, por p\u00ebr plugin\u00ebt e jasht\u00ebm, Grafana nuk punon me alerte (bilet\u00eb p\u00ebr k\u00ebt\u00eb prej vitesh).<\/p>\n<p><b>pinba-server<\/b><\/p>\n<p>Instalimi i protobuf dhe libevent \u2014 nuk \u00ebsht\u00eb i detyruesh\u00ebm, por p\u00ebrmir\u00ebson performanc\u00ebn e pinba-server. N\u00ebse e instaloni pinba-server n\u00eb nj\u00eb map\u00eb tjet\u00ebr p\u00ebrve\u00e7 \/opt, do t'ju duhet gjithashtu t\u00eb rregulloni <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/blob\/master\/systemd\/pinba-server.service\">skrypin systemd<\/a><\/noindex> skedarin.<\/p>\n<p><b>moduli pinba p\u00ebr Nginx<\/b><\/p>\n<p>P\u00ebr t\u00eb kompaktuar modul, nevojiten burimet e po asaj versioni t\u00eb Nginx q\u00eb \u00ebsht\u00eb tashm\u00eb i instaluar n\u00eb serverin tuaj, si dhe t\u00eb nj\u00ebjtat opsione kompaktimi, p\u00ebrndryshe nd\u00ebrtimi do t\u00eb kaloj\u00eb me sukses, por kur t\u00eb lidhet moduli do t\u00eb jepet nj\u00eb gabim se 'moduli nuk \u00ebsht\u00eb i p\u00ebrputhsh\u00ebm'. Opsionet e kompaktimit mund t\u00eb shihen me komand\u00ebn nginx -V.<\/p>\n<p><b>Lifehacks<\/b><\/p>\n<p>T\u00eb gjitha faqet e mia funksionojn\u00eb vet\u00ebm mbi https. Polin schema e b\u00ebn\u00eb pa kuptim, prandaj e p\u00ebrdor p\u00ebr t\u00eb ndar\u00eb web\/console.<\/p>\n<p>N\u00eb skriptet q\u00eb jan\u00eb t\u00eb disponueshme nga web-i p\u00ebrdor:<\/p>\n<pre><code class=\"php\">if (ini_get('pinba.enabled')) {\n    pinba_schema_set('web');\n}\n<\/code><\/pre>\n<p>\nDhe n\u00eb ato n\u00eb konsol\u00eb (p.sh., skriptet cron):<\/p>\n<pre><code class=\"php\">if (ini_get('pinba.enabled')) {\n    pinba_schema_set('console');\n}<\/code><\/pre>\n<p>\nN\u00eb panelin tim n\u00eb Grafana ka nj\u00eb nd\u00ebrrues web\/console p\u00ebr t\u00eb par\u00eb statistikat ve\u00e7mas.<\/p>\n<p>Po ashtu, n\u00eb Pinba mund t\u00eb kaloni etiketat tuaja, p.sh.:<\/p>\n<pre><code class=\"php\">pinba_tag_set('country', $countryCode);<\/code><\/pre>\n<p>\n<b>Kaq ishte gjith\u00e7ka. <\/b><\/p>\n<p>Ju lutem, p\u00ebrgjigjuni anketave n\u00ebn artikull.<\/p>\n<p>Tradicionalisht paralajm\u00ebroj q\u00eb nuk jap k\u00ebshilla dhe nuk ndihmoj p\u00ebrmes mesazheve personale n\u00eb Habra dhe rrjetet sociale.<\/p>\n<p>Hapni nj\u00eb bilet\u00eb n\u00eb GitHub.<\/p>\n<p>Gjithashtu, ju lutem mb\u00ebshtetni me p\u00eblqime <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/en\/post\/449818\/\">versionin anglisht<\/a><\/noindex> k\u00ebt\u00eb artikull <noindex><a rel=\"nofollow\" href=\"https:\/\/www.reddit.com\/r\/PHP\/comments\/bigszu\/statistics_and_monitoring_of_php_scripts_in_real\/\">n\u00eb Reddit<\/a><\/noindex>.<\/p>\n<p class=\"for_users_only_msg\">Vet\u00ebm p\u00ebrdoruesit e regjistruar mund t\u00eb marrin pjes\u00eb n\u00eb anket\u00eb. <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/auth\/login\/\">Hyni<\/a><\/noindex>, ju lutemi.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn OS po p\u00ebrdorni n\u00eb server?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Ubuntu<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    CentOS<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Debian<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Gentoo<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Red Hat<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Fedora<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    OpenSUSE<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    SuSE<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Unix<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Windows<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    tjet\u00ebr<\/p>\n<\/li>\n<\/ul>\n<p>    114 p\u00ebrdorues kan\u00eb votuar. 11 p\u00ebrdorues jan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn version t\u00eb PHP po p\u00ebrdorni n\u00eb server?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.3<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.2<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.1<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.0<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    5<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    tjet\u00ebr<\/p>\n<\/li>\n<\/ul>\n<p>    105 p\u00ebrdorues kan\u00eb votuar. 17 p\u00ebrdorues jan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">A e keni p\u00ebrdorur ndonj\u00ebher\u00eb pinba?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    po<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    jo, por do t\u00eb doja<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    jo dhe nuk doja<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    jo dhe nuk kam d\u00ebgjuar p\u00ebr t\u00eb<\/p>\n<\/li>\n<\/ul>\n<p>    100 p\u00ebrdorues kan\u00eb votuar. 14 p\u00ebrdorues jan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn version t\u00eb serverit pinba do t\u00eb donit t\u00eb provoni?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba_engine (mysql engine)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba2 (mysql engine)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinboard (php + mysql)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    olegfedoseev\/pinba-server (go + OpenTSDB)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    olegfedoseev\/pinba-influxdb (go + influxdb)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba-server\/pinba-server (go + clickhouse)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba-server\/pinba-server (php + clickhouse)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    do t\u00eb shkruaj versionin tim<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    tjet\u00ebr<\/p>\n<\/li>\n<\/ul>\n<p>    39 p\u00ebrdorues kan\u00eb votuar. 47 p\u00ebrdorues jan\u00eb abstenuar.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/444610\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":24468,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-32681","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PHP \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438. ClickHouse \u0438 Grafana \u0438\u0434\u0443\u0442 \u043d\u0430 \u043f\u043e\u043c\u043e\u0449\u044c \u043a Pinba | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:48:22+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:48:22+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Statistika dhe monitorimi i skripteve PHP n\u00eb koh\u00eb reale. ClickHouse dhe Grafana ndihmojn\u00eb Pinba | ProHoster","description":"N\u00eb k\u00ebt\u00eb artikull do t\u00eb flas p\u00ebr p\u00ebrdorimin e pinba n\u00eb bashk\u00ebpunim me clickhouse dhe grafana n\u00eb vend t\u00eb pinba_engine dhe pinboard. N\u00eb nj\u00eb projekt php, pinba \u00ebsht\u00eb ndoshta m\u00ebnyra e vetme t\u00eb besueshme p\u00ebr t\u00eb kuptuar se \u00e7far\u00eb ndodh me performanc\u00ebn. Sidoqoft\u00eb, zakonisht pinba integrohet vet\u00ebm kur tashm\u00eb ka probleme dhe nuk \u00ebsht\u00eb e qart\u00eb \"ku t\u00eb g\u00ebrmojm\u00eb\". Shpesh askush nuk ka ide se sa her\u00eb n\u00eb sekond\u00eb\/minut\u00eb thirret.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PHP \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438. ClickHouse \u0438 Grafana \u0438\u0434\u0443\u0442 \u043d\u0430 \u043f\u043e\u043c\u043e\u0449\u044c \u043a Pinba | ProHoster","og:description":"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:48:22+00:00","article:modified_time":"2019-10-31T18:48:22+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32681","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 12:02:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 02:54:26","updated":"2026-01-21 12:02:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/32681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=32681"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/32681\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/24468"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=32681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=32681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=32681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}