{"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":"Statistikat dhe monitorimi i skripteve PHP n\u00eb koh\u00eb reale. ClickHouse dhe Grafana ndihmojn\u00eb Pinba","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>N\u00eb k\u00ebt\u00eb artikull do flas p\u00ebr se si t\u00eb p\u00ebrdorni pinba s\u00eb bashku me clickhouse dhe grafana n\u00eb vend t\u00eb pinba_engine dhe pinboard.<\/p>\n<p>N\u00eb projektin php, pinba \u00ebsht\u00eb ndoshta e vetmja m\u00ebnyr\u00eb e besueshme p\u00ebr t\u00eb kuptuar se \u00e7far\u00eb po ndodh me performanc\u00ebn. Megjithat\u00eb, zakonisht pinba implementohet vet\u00ebm kur tashm\u00eb jan\u00eb v\u00ebrejtur probleme dhe nuk \u00ebsht\u00eb e qart\u00eb \"ku t\u00eb fillohet\".<\/p>\n<p>Shpesh askush nuk e ka iden\u00eb se sa her\u00eb n\u00eb sekond\u00eb\/minut\u00eb thirret nj\u00eb skenar i caktuar dhe fillojn\u00eb t\u00eb optimizojn\u00eb \"n\u00eb gisht\" duke filluar nga ato vende q\u00eb duket se jan\u00eb m\u00eb logjike.<\/p>\n<p>Dikush analizon loget e nginx, nd\u00ebrsa dikush tjet\u00ebr k\u00ebrkesat e ngadalta n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave.<\/p>\n<p>Sigurisht, pinba nuk do t\u00eb ishte e pad\u00ebshiruar, por ka disa arsye pse ajo nuk \u00ebsht\u00eb e pranishme 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=\"Statistikat dhe monitorimi i skripteve PHP n\u00eb koh\u00eb reale. ClickHouse dhe Grafana ndihmojn\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 \"rezultat\" nga implementimi i pinb\u00ebs, \u00ebsht\u00eb shum\u00eb e d\u00ebshirueshme t\u00eb shihen metrikat jo vet\u00ebm p\u00ebr minutat e fundit, por edhe p\u00ebr nj\u00eb periudh\u00eb m\u00eb t\u00eb gjat\u00eb (nga dit\u00ebt deri n\u00eb muajt).<\/p>\n<p>P\u00ebr k\u00ebt\u00eb nevojitet:<\/p>\n<ul>\n<li>t\u00eb instalohet 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-in<\/li>\n<\/ul>\n<p>\nP\u00ebr shkak t\u00eb numrit t\u00eb vog\u00ebl t\u00eb informacionit mbi pinba, shumic\u00ebs i \u00ebsht\u00eb formuar p\u00ebrshtypja se ajo funksiononte vet\u00ebm n\u00eb php5 dhe ka mbetur n\u00eb t\u00eb kaluar\u00ebn, por si\u00e7 do ta shohim m\u00eb tej \u2014 kjo nuk \u00ebsht\u00eb e v\u00ebrtet\u00eb.<\/p>\n<p>Hapi i par\u00eb \u2014 m\u00eb i thjesht\u00eb, thjesht duhet t\u00eb ekzekutoni komand\u00ebn:<\/p>\n<pre><code class=\"bash\">apt install php-pinba<\/code><\/pre>\n<p>\nN\u00eb repository kjo ekstension \u00ebsht\u00eb deri n\u00eb php 7.3 p\u00ebrfshir\u00eb dhe nuk keni nevoj\u00eb t\u00eb kompilonit asgj\u00eb.<\/p>\n<p>Pas ekzekutimit t\u00eb komand\u00ebs s\u00eb instalimit, menj\u00ebher\u00eb marrim nj\u00eb ekstension q\u00eb funksionon, i cili mbledh dhe d\u00ebrgon metrike p\u00ebr \u00e7do skenar (koh\u00ebzgjatjen e pun\u00ebs, kujtes\u00ebn etj.) n\u00eb formatin <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/Protocol_Buffers\">protobuf<\/a><\/noindex> p\u00ebrmes udp n\u00eb 127.0.0.1:30002.<\/p>\n<p>K\u00ebto paketa udp p\u00ebr momentin askush nuk i kap dhe nuk i p\u00ebrpunon, por kjo nuk ndikon aspak negativisht n\u00eb shpejt\u00ebsi ose stabilitetin e funksionimit t\u00eb skenar\u00ebve tuaj php.<\/p>\n<p>Derisa koh\u00ebt e fundit, aplikacioni q\u00eb mund t\u00eb kapte dhe p\u00ebrpunonte 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 lakonik<\/a><\/noindex>&#187; e instalimeve e frikon ndonj\u00ebher\u00eb leximin e m\u00ebtejsh\u00ebm dhe p\u00ebrfshirjen. N\u00eb listat e gjat\u00eb t\u00eb var\u00ebsive ndodhen emrat e paketave, emrat e programeve dhe lidhjet n\u00eb faqet e ve\u00e7anta p\u00ebr instalimin e tyre, gjithashtu ato kan\u00eb lidhje t\u00eb tjera p\u00ebr var\u00ebsi t\u00eb tjera. Askush nuk ka koh\u00eb apo d\u00ebshir\u00eb t\u00eb merret me k\u00ebt\u00eb kaos.<\/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\">n\u00eb m\u00ebnyr\u00eb t\u00eb ve\u00e7ant\u00eb m\u00eb t\u00eb leht\u00eb<\/a><\/noindex>.<\/p>\n<p>Mund t\u00eb vij\u00eb nj\u00eb moment kur pinba10 do t\u00eb mund t\u00eb instalohet me nj\u00eb ose dy komanda pa pasur nevoj\u00eb t\u00eb lexosh shum\u00eb materiale p\u00ebr t\u00eb kuptuar si ta b\u00ebsh k\u00ebt\u00eb, por p\u00ebr momentin nuk \u00ebsht\u00eb k\u00ebshtu.<\/p>\n<p>N\u00ebse ndonj\u00ebher\u00eb e keni instaluar pinba_engine, at\u00ebher\u00eb 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 n\u00eb t\u00eb dh\u00ebnat vet\u00ebm p\u00ebr minutat e fundit ose t\u00eb angazhoheni p\u00ebr t\u00eb grumbulluar, ruajtur dhe vizualizuar t\u00eb dh\u00ebnat. Fatmir\u00ebsisht, pinboard \u00ebsht\u00eb mjaft i thjesht\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/intaro\/pinboard\/wiki\/Installation\">instalimin<\/a><\/noindex>.<\/p>\n<p>Duket se, p\u00ebrse t\u00eb kalosh n\u00ebp\u00ebr kaq vuajtje kur t\u00eb gjitha metrikat nga php shkojn\u00eb p\u00ebrmes portit udp n\u00eb formatin protobuf dhe e gjith\u00eb ajo q\u00eb \u00ebsht\u00eb e nevojshme \u00ebsht\u00eb t\u00eb shkruash nj\u00eb aplikacion q\u00eb do t'i kap\u00eb dhe t'i ruaj\u00eb n\u00eb nj\u00eb depo? M\u00eb duket se ato zhvillues q\u00eb kan\u00eb pasur k\u00ebt\u00eb mendim e kan\u00eb vendosur menj\u00ebher\u00eb t\u00eb fillojn\u00eb t\u00eb shkruajn\u00eb bi\u00e7ikletat e tyre, disa prej t\u00eb cilave p\u00ebrfunduan n\u00eb GitHub.<\/p>\n<p>M\u00eb posht\u00eb \u00ebsht\u00eb nj\u00eb p\u00ebrmbledhje e kat\u00ebr projekteve open-source q\u00eb ruajn\u00eb metrikat n\u00eb depo, nga t\u00eb cilat k\u00ebto t\u00eb dh\u00ebna leht\u00eb mund t\u00eb merren dhe vizualizohen, p\u00ebr shembull, 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, q\u00eb ruan metrikat n\u00eb OpenTSDB. M\u00eb duket se n\u00ebse OpenTSDB po p\u00ebrdoret tashm\u00eb n\u00eb projektin tuaj, at\u00ebher\u00eb ky zgjidhje mund t'ju p\u00ebrshtatet, p\u00ebrndryshe rekomandoj ta kaloni p\u00ebrpara.<\/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 monitorim, InfluxDB tashm\u00eb po p\u00ebrdoret, prandaj p\u00ebr to ky zgjidhje mund t\u00eb jet\u00eb shum\u00eb i p\u00ebrshtatsh\u00ebm.<\/p>\n<p>Avantazhet:<\/p>\n<ul>\n<li>InfluxDB <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-influxdb#influxdb-preparation\">mund\u00ebson<\/a><\/noindex> grumbulloni metrikat e marra dhe fshini origjinalin pas nj\u00eb kohe t\u00eb caktuar.<\/li>\n<\/ul>\n<p>\nDisavantazhet:<\/p>\n<ul>\n<li>ky zgjidhje nuk ruan informacion mbi timer\u00ebt.<\/li>\n<li>InfluxDB do t\u00eb ruaj\u00eb adresat e faqeve t\u00eb internetit si etiketa dhe n\u00ebse keni shum\u00eb adresa unike faqe, kjo do t\u00eb \u00e7oj\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/449352\/#comment_20085878\">shpenzime t\u00eb rritura<\/a><\/noindex> memorie operative. Nga nj\u00eb pik\u00eb e caktuar ai &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/2v\/68\/th\/2v68thch8ajln7abt-ghsmsbxgs.png\">filloj\u00eb t\u00eb haj\u00eb memorie pa fund<\/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, q\u00eb ruan metrikat n\u00eb ClickHouse. Ky \u00ebsht\u00eb nj\u00eb zgjidhje nga miku im. Pik\u00ebrisht pas njohjes me t\u00eb, vendosa se ishte koha t\u00eb merrem me pinbu dhe ClickHouse.<\/p>\n<p>Avantazhet:<\/p>\n<ul>\n<li>ClickHouse \u00ebsht\u00eb perfekt p\u00ebr k\u00ebt\u00eb lloj pune, ai lejon kompresimin e t\u00eb dh\u00ebnave aq shum\u00eb saq\u00eb mund t\u00eb ruani t\u00eb gjitha t\u00eb dh\u00ebnat e pap\u00ebrpunuara madje edhe pa grumbullime<\/li>\n<li>n\u00ebse \u00ebsht\u00eb e nevojshme, at\u00ebher\u00eb mund t\u00eb grumbulloni leht\u00ebsisht metrikat e marra<\/li>\n<li>m\u00ebnyr\u00eb t\u00eb gatshme p\u00ebr grafana<\/li>\n<li>ruan informacion mbi timer\u00ebt<\/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 konfigurim n\u00eb t\u00eb cilin mund t\u00eb rregullohet emri i databaz\u00ebs dhe tabelave, adres\u00ebn dhe portin e serverit.<\/li>\n<li>kur ruani t\u00eb dh\u00ebnat e pap\u00ebrpunuara p\u00ebrdoret nj\u00eb tabel\u00eb ndihm\u00ebse p\u00ebr ruajtjen e adresa e faqeve dhe domen\u00ebve, gj\u00eb q\u00eb e b\u00ebn t\u00eb komplikuar 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>\nserver udp n\u00eb php, i cili ruan metricat n\u00eb ClickHouse. Kjo \u00ebsht\u00eb zgjidhja ime, rezultati i njohjes me pinba, ClickHouse dhe protobuf. Nd\u00ebrsa meresha me t\u00eb gjith\u00eb k\u00ebt\u00eb lidhje, shkrova nj\u00eb \u00abproof of concept\u00bb q\u00eb p\u00ebr \u00e7udi p\u00ebr mua nuk konsumonte burime t\u00eb konsiderueshme (30 mb memorie operative dhe m\u00eb pak se 1% nga nj\u00eb nga tet\u00eb b\u00ebrthamat e procesorit), prandaj vendosa ta ndaj at\u00eb me publikun.<\/p>\n<p>Plus\u00ebt \u2014 jan\u00eb t\u00eb nj\u00ebjta me zgjidhjen e m\u00ebparshme, gjithashtu kam p\u00ebrdorur em\u00ebrtimet e zakonshme nga pinba_engine origjinale. Po ashtu kam shtuar nj\u00eb konfigurim q\u00eb lejon nisjen e disa instancave t\u00eb serverit pinba, p\u00ebr t\u00eb ruajtur metricat 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 \/>\nMinus\u00ebt \u2014 \u00abdefekt fatal\u00bb dhe ato detaje t\u00eb vogla q\u00eb nuk do t'ju k\u00ebnaqin personalisht, por zgjidhja ime \u00ebsht\u00eb \u00abe thjesht\u00eb si nj\u00eb sandale\u00bb dhe p\u00ebrb\u00ebhet nga rreth 100 rreshta kodi, k\u00ebshtu q\u00eb \u00e7do zhvillues php mund t\u00eb ndryshoj\u00eb brenda pak minutash at\u00eb q\u00eb nuk i p\u00eblqen.<\/p>\n<p><b>Parimi i funksionimit<\/b><\/p>\n<p>Ndiqet porti udp 30002. T\u00eb gjitha paketat e ardhshme dekodehen sipas skem\u00ebs protobuf dhe agregohen. \u00c7do minut\u00eb b\u00ebhet nj\u00eb insert grupi n\u00eb clickhouse n\u00eb tabel\u00ebn pinba.requests. (t\u00eb gjitha parametrat rregullohen 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 rreth clickhouse<\/b><\/p>\n<p>Clickhouse mb\u00ebshtet motor\u00eb t\u00eb ndrysh\u00ebm ruajtjeje t\u00eb t\u00eb dh\u00ebnave. M\u00eb i p\u00ebrdoruri \u00ebsht\u00eb MergeTree. <\/p>\n<p>N\u00ebse n\u00eb ndonj\u00eb moment vendosni t\u00eb ruani t\u00eb dh\u00ebnat e agreguara p\u00ebr t\u00eb gjith\u00eb koh\u00ebn dhe t\u00eb dh\u00ebnat e pap\u00ebrpunuara vet\u00ebm p\u00ebr t\u00eb fundit, mund t\u00eb krijoni nj\u00eb materialized view me grupim, nd\u00ebrsa tabela kryesore pinba.requests duhet t\u00eb pastrrohet periodikisht, p\u00ebr k\u00ebt\u00eb t\u00eb dh\u00ebnat do t\u00eb mbeten n\u00eb materialized view. M\u00eb tej, gjat\u00eb krijimit t\u00eb tabel\u00ebs pinba.requests mund t\u00eb tregoni \u00abengine = Null\u00bb, at\u00ebher\u00eb t\u00eb dh\u00ebnat e pap\u00ebrpunuara nuk do t\u00eb ruhen kurr\u00eb n\u00eb disk dhe megjithat\u00eb ato do t\u00eb kalojn\u00eb n\u00eb materialized view dhe do t\u00eb ruhen t\u00eb agreguara. Un\u00eb p\u00ebrdor nj\u00eb skem\u00eb t\u00eb till\u00eb p\u00ebr metricat nginx, sepse n\u00eb nginx kam rreth 50 her\u00eb m\u00eb shum\u00eb k\u00ebrkesa se sa 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, prandaj do t\u00eb ndjek\u00eb nj\u00eb p\u00ebrshkrim t\u00eb detajuar t\u00eb instalimit dhe konfigurimit t\u00eb zgjidhjes time dhe gjith\u00e7ka q\u00eb ju nevojitet, si dhe uj\u00ebrat e rrezikshme mbi t\u00eb cilat jan\u00eb thyer shum\u00eb anije. I gjith\u00eb procesi i instalimit \u00ebsht\u00eb p\u00ebrshkruar p\u00ebr Ubuntu 18.04 LTS dhe CentOS 7, n\u00eb distribucione 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 p\u00ebrmbledhur 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 p\u00ebrs\u00ebritshm\u00ebrin\u00eb e udh\u00ebzimeve. M\u00eb posht\u00eb do t\u00eb p\u00ebrshkruhen vet\u00ebm uj\u00ebrat e rrezikshme.<\/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 shkruar t\u00eb gjitha opsionet. N\u00eb disa distribucione (p\u00ebr shembull, CentOS) ato mund t\u00eb jen\u00eb t\u00eb shkruara komente.<\/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, clickhouse do t'ju k\u00ebrkoj\u00eb t\u00eb vendosni nj\u00eb fjal\u00ebkalim p\u00ebr p\u00ebrdoruesin default. Me default, ky p\u00ebrdorues \u00ebsht\u00eb i aksesuesh\u00ebm nga t\u00eb gjitha IP-t\u00eb, k\u00ebshtu q\u00eb n\u00ebse nuk keni nj\u00eb firewall n\u00eb server, sigurohuni t\u00eb vendosni nj\u00eb fjal\u00ebkalim p\u00ebr t\u00eb. 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 v\u00ebreni se clickhouse p\u00ebrdor disa porte, duke p\u00ebrfshir\u00eb 9000. Ky port gjithashtu p\u00ebrdoret p\u00ebr php-fpm n\u00eb disa distribucione (p\u00ebr shembull, CentOS). N\u00ebse ky port \u00ebsht\u00eb tashm\u00eb n\u00eb p\u00ebrdorim, mund ta ndryshoni 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 grafan\u00ebs, p\u00ebrdorni emrin admin dhe fjal\u00ebkalimin admin. N\u00eb hyrjen e par\u00eb, grafana do t'ju k\u00ebrkoj\u00eb t\u00eb vendosni nj\u00eb fjal\u00ebkalim t\u00eb ri.<\/p>\n<p>M\u00eb pas hyjm\u00eb n\u00eb menun\u00eb &#171;+&#187; -&gt; import dhe tregojm\u00eb numrin e panelit 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 krijoni at\u00eb vet\u00eb p\u00ebrs\u00ebri.<\/p>\n<p>Grafana mb\u00ebshtet pun\u00ebn me clickhouse p\u00ebrmes nj\u00eb plugin-i t\u00eb tret\u00eb, por p\u00ebr plugin-t e tret\u00eb, grafana nuk funksionon me alarmin (kjo k\u00ebrkes\u00eb ka qen\u00eb e hapur p\u00ebr disa vite).<\/p>\n<p><b>pinba-server<\/b><\/p>\n<p>Instalimi i protobuf dhe libevent 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 dosje tjet\u00ebr p\u00ebrve\u00e7 \/opt, do t'ju duhet gjithashtu t\u00eb p\u00ebrmir\u00ebsoni <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/blob\/master\/systemd\/pinba-server.service\">skribin systemd<\/a><\/noindex> fajllin.<\/p>\n<p><b>moduli pinba p\u00ebr nginx<\/b><\/p>\n<p>P\u00ebr t\u00eb kompiluar modulin, ju nevojiten skedar\u00ebt burimor\u00eb t\u00eb versionit t\u00eb nj\u00ebjt\u00eb t\u00eb nginx q\u00eb \u00ebsht\u00eb instaluar n\u00eb serverin tuaj, si dhe t\u00eb nj\u00ebjtat mund\u00ebsi kompilimi; p\u00ebrndryshe, nd\u00ebrtimi do t\u00eb kaloj\u00eb me sukses, por gjat\u00eb lidhjes s\u00eb modulit do t\u00eb shfaqet nj\u00eb gabim se 'moduli nuk \u00ebsht\u00eb i p\u00ebrputhsh\u00ebm me binar.' Mund\u00ebsit\u00eb e kompilimit mund t\u00eb shihen me komand\u00ebn nginx -V<\/p>\n<p><b>K\u00ebshillat e jet\u00ebs<\/b><\/p>\n<p>T\u00eb gjitha faqet e mia funksionojn\u00eb vet\u00ebm me https. Fusha schema b\u00ebhet e panevojshme, k\u00ebshtu q\u00eb un\u00eb e p\u00ebrdor at\u00eb p\u00ebr ndarjen e web\/console.<\/p>\n<p>N\u00eb skriptet q\u00eb jan\u00eb t\u00eb qasshme nga web-i un\u00eb 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 konsol\u00eb (p.sh., skriptet kron):<\/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, kam nj\u00eb kalues web\/console p\u00ebr t\u00eb par\u00eb statistikat ve\u00e7mas.<\/p>\n<p>Gjithashtu, n\u00eb pinba mund t\u00eb d\u00ebrgoni etiketat tuaja, p\u00ebr shembull:<\/p>\n<pre><code class=\"php\">pinba_tag_set('country', $countryCode);<\/code><\/pre>\n<p>\n<b>Kjo \u00ebsht\u00eb gjith\u00e7ka. <\/b><\/p>\n<p>P\u00ebr nj\u00eb k\u00ebrkes\u00eb t\u00eb madhe, ju lutem p\u00ebrgjigjuni pyetjeve pas artikullit.<\/p>\n<p>Tradicionalisht paralajm\u00ebroj se un\u00eb nuk ofroj konsultime dhe ndihm\u00eb p\u00ebrmes mesazheve private t\u00eb Habr\u00ebs dhe rrjeteve 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> ky 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 lutem.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn OS po p\u00ebrdorni n\u00eb serverin tuaj?<\/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>                    t\u00eb tjera<\/p>\n<\/li>\n<\/ul>\n<p>    114 p\u00ebrdorues kan\u00eb votuar. 11 p\u00ebrdorues kan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn version t\u00eb php po p\u00ebrdorni n\u00eb serverin tuaj?<\/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>                    t\u00eb tjera<\/p>\n<\/li>\n<\/ul>\n<p>    105 p\u00ebrdorues kan\u00eb votuar. 17 p\u00ebrdorues kan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">A 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 do t\u00eb 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 kan\u00eb abstenuar.<\/p>\n<h2 class=\"default-block__polling-title\">Cil\u00ebn version t\u00eb serverit pinba do d\u00ebshironit 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 (motor mysql)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba2 (motor mysql)<\/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>                    t\u00eb tjera<\/p>\n<\/li>\n<\/ul>\n<p>    39 p\u00ebrdorues kan\u00eb votuar. 47 p\u00ebrdorues kan\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.2 - 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.\" \/>\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.2\" \/>\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.\" \/>\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 vijn\u00eb n\u00eb ndihm\u00eb Pinba | ProHoster","description":"N\u00eb k\u00ebt\u00eb artikull do t\u00eb flas p\u00ebr si t\u00eb p\u00ebrdorim pinba n\u00eb bashk\u00ebpunim me clickhouse dhe grafana n\u00eb vend t\u00eb pinba_engine dhe pinboard. N\u00eb projektin php, pinba \u00ebsht\u00eb ndoshta m\u00ebnyra e vetme t\u00eb besueshme p\u00ebr t\u00eb kuptuar se \u00e7far\u00eb ndodh.","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.","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}]}}