# PMM Gravana does not show all data **URL:** \ **Category:** PMM 1.x\ **Created:** [February 17, 2017, 5:03am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417 "2017-02-17T05:03:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 17, 2017, 5:03am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/1 "2017-02-17T05:03:33Z")
Centos 7, percona server 5.7.17. We have to servers connected to PMM. Both configured to send same info to PMM Grafana. But one of them do that successfully, other lost some info, buh not all. For example: mysqld.cnf from good server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock bind-address = 0.0.0.0 character\_set\_server = utf8 collation\_server = utf8\_general\_ci max\_allowed\_packet = 256M innodb\_buffer\_pool\_size = 10G innodb\_page\_size = 32K innodb\_data\_file\_path = ibdata1:10M:autoextend innodb\_file\_per\_table = 1 innodb\_flush\_log\_at\_trx\_commit = 2 # 0 # 1 innodb\_flush\_method = O\_DIRECT innodb\_log\_file\_size = 512M innodb\_log\_files\_in\_group = 2 innodb\_doublewrite = 0 innodb\_io\_capacity = 600 innodb\_strict\_mode=OFF #skip-grant-tables secure-file-priv = /tmp sql\_mode= #NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES sql\_mode=STRICT\_ALL\_TABLES # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid # bin-log replication options server\_id=11 log\_bin=mysql\_bin.log expire\_logs\_days=2 max\_binlog\_size=100M binlog\_format=ROW max\_binlog\_files = 10 # statistics for PMM server userstat = ON query\_response\_time\_stats = ON innodb\_monitor\_enable=all log\_output=file slow\_query\_log=OFF slow\_query\_log\_file=/var/lib/mysql/slowquery.log long\_query\_time=0 log\_slow\_rate\_limit=100 log\_slow\_rate\_type=query log\_slow\_verbosity=full log\_slow\_admin\_statements=ON log\_slow\_slave\_statements=ON log\_slow\_sp\_statements=ON slow\_query\_log\_always\_write\_time=1 slow\_query\_log\_use\_global\_control=all open\_files\_limit=5000 mysqld.cnf from bad server: [mysql] default\_character\_set=utf8 prompt="\u@\h \d\> " [mysqld\_safe] open\_files\_limit=262144 [mysqld] max\_heap\_table\_size=16M query\_cache\_size=1048576 query\_cache\_type=OFF table\_definition\_cache=1400 table\_open\_cache=2000 tmp\_table\_size=16M open\_files\_limit=5000 user=mysql port=3306 character\_set\_server=utf8 collation\_server=utf8\_general\_ci expand\_fast\_index\_creation=ON innodb\_file\_per\_table=ON innodb\_flush\_log\_at\_trx\_commit=1 innodb\_flush\_method=O\_DIRECT innodb\_lock\_wait\_timeout=120 innodb\_old\_blocks\_time=10000 innodb\_open\_files=16384 innodb\_page\_size=32K innodb\_temp\_data\_file\_path=ibtmp1:12M:autoextend:m ax:1024M innodb\_strict\_mode=OFF sql\_mode=STRICT\_ALL\_TABLES datadir=/var/lib/mysql log\_error=/var/log/mysqld.log log\_timestamps=SYSTEM # MUST BE ADDED TO CERT. DISCUSS WITH JAVIER pid\_file=/var/run/mysqld/mysqld.pid secure\_file\_priv = socket=/var/lib/mysql/mysql.sock symbolic\_links=ON tmpdir=/tmp max\_allowed\_packet=128M max\_connect\_errors=1000000 max\_connections=800 net\_read\_timeout=600 net\_write\_timeout=600 skip\_name\_resolve=ON query\_response\_time\_stats=ON innodb\_monitor\_enable=all performance\_schema=ON userstat=ON ## SLOWQUERYLOG FOR PMMC: ## SECTION MAY BE DISABLED IF QAN USE ## PERFORMANCE\_SCHEMA INSTEAD SLOW QUERY LOG slow\_query\_log=OFF log\_output=file log\_slow\_admin\_statements=ON log\_slow\_rate\_limit=100 log\_slow\_rate\_type=query log\_slow\_slave\_statements=ON log\_slow\_sp\_statements=ON log\_slow\_verbosity=full long\_query\_time=0 slow\_query\_log\_always\_write\_time=1 slow\_query\_log\_file=/var/lib/mysql/slowquery.log slow\_query\_log\_use\_global\_control=all innodb\_buffer\_pool\_size=8G innodb\_io\_capacity=600 innodb\_log\_files\_in\_group=2 innodb\_log\_file\_size=512M ![2017-02-17 12-02-36 2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2b898ab308761b073b94c909f1784bf888a407f8.jpeg) ![2017-02-17 12-08-08 2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/89a50e81c859b4209832aab370a4a98cb8000732.jpeg) ![2017-02-17 12-02-52 2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a74efb9e791e4de6784262539bbb936ac4ac22c1.jpeg) ![2017-02-17 12-05-41 2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/681367cdc3f1730b8a730022763e6e0c1c186b3d.jpeg) ![2017-02-17 12-05-51 2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f2bf1ee8c34d81ec8688e74eb55fb81f3b0d09cd.jpeg) ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 17, 2017, 5:12am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/2 "2017-02-17T05:12:37Z")
How to download images on your forum in right way? I think images from first topic not usable. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 17, 2017, 7:07am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/3 "2017-02-17T07:07:41Z")
can you try now? we fixed some compression options on forum ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 21, 2017, 3:13am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/4 "2017-02-21T03:13:08Z")
Example 1: Good server: Bad server: No value for max connection, InniDB Buffer Pool Size, Buffer Pool Size of Total RAM Example 2: Good Server: Bad Server: No data of performance schema Example 3: Good Server Image was not downloaded because of restriction - 5 images in post. But there is exist data missing on image below Bad Server: No data for process ![1 good.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0cbf3963c75b80d8617e548c1d0b6b7b1239a635.png) ![1 bad.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/39c93de2230dc62436296122c00dff4ef995c1be.png) ![2 good.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/ac9e2ad8699138624b4bf05992e7ba694f0ac5aa.jpeg) ![2 bad.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/d349e3f157098859e7089ef170bc1f0d5543694d.png) ![3 bad.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/469ee224edc63cf71ff900e4963059028dee3c55.png) ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 21, 2017, 3:14am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/5 "2017-02-21T03:14:54Z")
After upgrading to 1.1.1 problem still exist ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 21, 2017, 6:42am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/6 "2017-02-21T06:42:29Z")
can you run the following command for both servers? ```auto curl https://login:password@pmm-client:42002/metrics-hr --insecure | grep mysql_global_status_connections ``` ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 21, 2017, 9:22am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/7 "2017-02-21T09:22:27Z")
curl [https://root:rootpassword@](https://root)mysql-bad-server:42002/metrics-hr --insecure | grep mysql\_global\_status\_connections % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:–:-- --:–:-- --:–:-- 0# HELP mysql\_global\_status\_connections Generic metric from SHOW GLOBAL STATUS. # TYPE mysql\_global\_status\_connections untyped mysql\_global\_status\_connections 8.817595e+06 100 103k 100 103k 0 0 502k 0 --:–:-- --:–:-- --:–:-- 502k curl [https://root:rootpassword@](https://root)mysql-good-server:42002/metrics-hr --insecure | grep mysql\_global\_status\_connections % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:–:-- --:–:-- --:–:-- 0# HELP mysql\_global\_status\_connections Generic metric from SHOW GLOBAL STATUS. # TYPE mysql\_global\_status\_connections untyped mysql\_global\_status\_connections 3.038542e+06 100 103k 100 103k 0 0 324k 0 --:–:-- --:–:-- --:–:-- 325k ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 22, 2017, 1:45am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/8 "2017-02-22T01:45:58Z")
Can you share result table from prometheus? [URL=“[http://PMM-SERVER-IP/prometheus/graph?g0.range\_input=1h&g0.expr=mysql\_global\_status\_connections&g0.tab=1](http://PMM-SERVER-IP/prometheus/graph?g0.range_input=1h&g0.expr=mysql_global_status_connections&g0.tab=1)”][http://PMM-SERVER-IP/prometheus/grap...tions&g0.tab=1[/URL]](http://PMM-SERVER-IP/prometheus/grap...tions&g0.tab=1%5B/URL%5D) result should be similar to ```auto mysql_global_status_connections{instance="good-server",job="mysql"} 12312 mysql_global_status_connections{instance="bad-server",job="mysql"} 45645 ``` most interesting thing in this table - data value in prometheus database. also please open prometheus graph itself [URL=“[http://PMM-SERVER-IP/prometheus/graph?g0.range\_input=1h&g0.expr=mysql\_global\_status\_connections&g0.tab=1](http://PMM-SERVER-IP/prometheus/graph?g0.range_input=1h&g0.expr=mysql_global_status_connections&g0.tab=1)”][http://PMM-SERVER-IP/prometheus/grap...tions&g0.tab=0[/URL]](http://PMM-SERVER-IP/prometheus/grap...tions&g0.tab=0%5B/URL%5D) ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 22, 2017, 2:35am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/9 "2017-02-22T02:35:33Z")
mysql\_global\_status\_connections{instance=“bad-server”,job=“mysql”} 9282063 mysql\_global\_status\_connections{instance=“good-server”,job=“mysql”} 3116737 And graph. Green - bad-server Red - good-server ![4.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/e3391df0259e65670f1490d37da03c8e8dec451e.png) ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 22, 2017, 9:27am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/10 "2017-02-22T09:27:48Z")
As we can see - data is exists is prometheus can you try to fetch the same data via grafana call? http://[U]PMM-SERVER-IP[/U]/graph/api/datasources/proxy/1/api/v1/query\_range?query=rate(mysql\_global\_status\_connections%7Binstance%3D%22PMM-CLIENT%22%7D%5B15m%5D)%20or%20irate(mysql\_global\_status\_connections%7Binstance%3D%22PMM-CLIENT%22%7D%5B5m%5D)&start=1487602415&end=1487775215&step=900 ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 22, 2017, 10:08am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/11 "2017-02-22T10:08:02Z")
[url][http://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query\_range?query=rate(mysql\_global\_status\_connections{instance%3D"bad-server"}[15m])%20or%20irate(mysql\_global\_status\_connections{instance%3D"bad-server"}[5m])&start=1487602415&end=1487775215&step=900[/url]](http://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query_range?query=rate(mysql_global_status_connections%7Binstance%3D%22bad-server%22%7D%5B15m%5D)%20or%20irate(mysql_global_status_connections%7Binstance%3D%22bad-server%22%7D%5B5m%5D)&start=1487602415&end=1487775215&step=900%5B/url%5D) {“status”:“success”,“data”:{“resultType”:“matrix”,“result”:[{“metric”:{“instance”:“bad-server”,“job”:“mysql”},“values”:[[1487602415,“7.431598922801917”],[1487603315,“8.679653703730484”],[1487604215,“7.827586206896551”],[1487605115,“13.115640326005584”],[1487606015,“21.040044493882093”],[1487606915,“20.8587319243604”],[1487607815,“52.10678531701891”],[1487608715,“25.737486095661843”],[1487609615,“27.490575629116385”],[1487610515,“8.874304783092324”],[1487611415,“8.519466073414904”],[1487612315,“8.582869855394883”],[1487613215,“8.838719509142948”],[1487614115,“10.100111234705226”],[1487615015,“8.870967741935482”],[1487615915,“9.618464961067852”],[1487616815,“8.926595024021163”],[1487617715,“8.774193548387096”],[1487618615,“8.711911804128816”],[1487619515,“8.71523915461624”],[1487620415,“9.469420989344817”],[1487621315,“19.89096786321706”],[1487622215,“8.507239718842847”],[1487623115,“20.553948832035594”],[1487624015,“17.98222244963565”],[1487624915,“10.957730812013349”],[1487625815,“8.421579532814237”],[1487626715,“8.479421579532815”],[1487627615,“8.444938820912125”],[1487628515,“8.479431011602905”],[1487629415,“9.76862094702898”],[1487630315,“8.476084538375973”],[1487631215,“8.617362199513014”],[1487632115,“8.626318558653962”],[1487633015,“20.828698553948833”],[1487633915,“13.146961426755107”],[1487634815,“8.479412147483707”],[1487635715,“8.546162402669633”],[1487636615,“8.368186874304783”],[1487637515,“41.71412680756396”],[1487638415,“51.358175750834256”],[1487639315,“8.599555061179087”],[1487640215,“11.082301354503498”],[1487641115,“8.729699666295884”],[1487642015,“27.963292547274747”],[1487642915,“14.82758620689655”],[1487643815,“8.56952169076752”],[1487644715,“8.506117908787541”],[1487645615,“8.606219570389799”],[1487646515,“42.02108785196012”],[1487647415,“99.82080108920903”],[1487648315,“36.98109010011123”],[1487649215,“8.994438264738598”],[1487650115,“9.885428253615126”],[1487651015,“8.71635150166852”],[1487651915,“8.703003337041157”],[1487652815,“8.921013436025099”],[1487653715,“8.64516129032258”],[1487654615,“8.622914349276973”],[1487655515,“8.547284257268362”],[1487656415,“10.353726362625137”],[1487657315,“9.051167964404893”],[1487658215,“8.696338928074448”],[1487659115,“9.092324805339265”],[1487660015,“9.057842046718577”],[1487660915,“8.381535038932146”],[1487661815,“8.447163515016685”],[1487662715,“8.364840528542238”],[1487663615,“8.463858135548538”],[1487664515,“6.559606924450945”],[1487665415,“4.180412332494625”],[1487666315,“1.9165739710789764”],[1487667215,“10.963280352302165”],[1487668115,“5.261407409796896”],[1487669015,“3.04560284137615”],[1487669915,“6.440489432703003”],[1487670815,“11.263626251390432”],[1487671715,“2.9499443826473857”],[1487672615,“2.7541713014460507”],[1487673515,“2.7830892290442395”],[1487674415,“14.717447477811483”],[1487675315,“5.571746384872079”],[1487676215,“2.7430508821478115”],[1487677115,“11.429378675615881”],[1487678015,“15.68520578420467”],[1487678915,“5.904338153503893”],[1487679815,“2.894323810540812”],[1487680715,“2.717463848720801”],[1487681615,“2.75194660734149”],[1487682515,“3.0578386453407727”],[1487683415,“4.052280311457174”],[1487684315,“3.77641404180863”],[1487685215,“2.8019991078986566”],[1487686115,“4.086763070077864”],[1487687015,“2.855391707017011”],[1487687915,“2.6307007786429364”],[1487688815,“5.8220244716351495”],[1487689715,“3.5027808676307006”],[1487690615,“2.764182424916574”],[1487691515,“4.395995550611791”],[1487692415,“8.761938238179669”],[1487693315,“14.272525027808674”],[1487694215,“10.838709677419354”],[1487695115,“6.530589543937707”],[1487696015,“1.9833147942157952”],[1487696915,“15.423804226918797”],[1487697815,“1.9632903634145011”],[1487698715,“13.863181312569521”],[1487699615,“14.737469702480865”],[1487700515,“14.341490545050055”],[1487701415,“8.542834864109972”],[1487702315,“8.61400599109456”],[1487703215,“13.457174638487206”],[1487704115,“15.165722841242667”],[1487705015,“14.20799309455718”],[1487705915,“1.9410348107073934”],[1487706815,“2.152393940371458”],[1487775215,“3.3515016685205783”]]}]}} [url][http://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query\_range?query=rate(mysql\_global\_status\_connections{instance%3D"good-server"}[15m])%20or%20irate(mysql\_global\_status\_connections{instance%3D"good-server"}[5m])&start=1487602415&end=1487775215&step=900[/url]](http://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query_range?query=rate(mysql_global_status_connections%7Binstance%3D%22good-server%22%7D%5B15m%5D)%20or%20irate(mysql_global_status_connections%7Binstance%3D%22good-server%22%7D%5B5m%5D)&start=1487602415&end=1487775215&step=900%5B/url%5D) {“status”:“success”,“data”:{“resultType”:“matrix”,“result”:[{“metric”:{“instance”:“good-server”,“job”:“mysql”},“values”:[[1487602415,“7.843159065628476”],[1487603315,“7.745272525027809”],[1487604215,“8.075729429693324”],[1487605115,“9.013348164627363”],[1487606015,“8.701890989988875”],[1487606915,“8.898776418242491”],[1487607815,“9.080088987764181”],[1487608715,“8.666295884315906”],[1487609615,“8.458286985539488”],[1487610515,“8.783092324805338”],[1487611415,“8.711902113459399”],[1487612315,“8.60734149054505”],[1487613215,“8.581757508342601”],[1487614115,“8.796440489432703”],[1487615015,“8.388209121245827”],[1487615915,“8.558398220244715”],[1487616815,“8.60511679644049”],[1487617715,“9.249165739710788”],[1487618615,“9.338153503893215”],[1487619515,“9.174638487208009”],[1487620415,“9.342602892102336”],[1487621315,“9.268075639599553”],[1487622215,“9.565082942250214”],[1487623115,“9.532814238042269”],[1487624015,“9.478309232480534”],[1487624915,“9.506117908787541”],[1487625815,“9.596271391943226”],[1487626715,“9.612903225806452”],[1487627615,“9.540600667408231”],[1487628515,“9.568409343715238”],[1487629415,“9.462746899607229”],[1487630315,“9.438264738598441”],[1487631215,“9.204671857619577”],[1487632115,“9.401557285873192”],[1487633015,“9.467185761957731”],[1487633915,“9.191323692992214”],[1487634815,“9.479421579532813”],[1487635715,“9.489432703003336”],[1487636615,“9.50166852057842”],[1487637515,“9.442829667548768”],[1487638415,“9.42602892102336”],[1487639315,“9.470522803114571”],[1487640215,“9.345939933259176”],[1487641115,“9.339265850945495”],[1487642015,“9.157953281423802”],[1487642915,“9.349276974416018”],[1487643815,“9.18464961067853”],[1487644715,“9.22246941045606”],[1487645615,“9.43381535038932”],[1487646515,“9.520578420467185”],[1487647415,“9.262513904338153”],[1487648315,“9.476084538375973”],[1487649215,“9.318131256952169”],[1487650115,“9.340378197997776”],[1487651015,“9.421579532814238”],[1487651915,“9.273637374860957”],[1487652815,“9.334816462736372”],[1487653715,“9.404894327030034”],[1487654615,“9.46607341490545”],[1487655515,“9.21134593993326”],[1487656415,“9.39599555061179”],[1487657315,“9.298109010011123”],[1487658215,“9.39710789766407”],[1487659115,“9.452714735578715”],[1487660015,“9.472747497219132”],[1487660915,“9.521690767519464”],[1487661815,“9.332591768631811”],[1487662715,“9.441601779755283”],[1487663615,“9.457174638487206”],[1487664515,“7.217416838995568”],[1487665415,“1.3914951877765434”],[1487666315,“1.282536151279199”],[1487667215,“1.2803114571746383”],[1487668115,“1.2858731924360398”],[1487669015,“1.3081201334816464”],[1487669915,“1.271412680756396”],[1487670815,“1.2847608453837598”],[1487671715,“1.292547274749722”],[1487672615,“1.279199110122358”],[1487673515,“1.2803114571746383”],[1487674415,“1.3047830923248052”],[1487675315,“1.2914349276974415”],[1487676215,“1.6918798665183536”],[1487677115,“1.7808676307007785”],[1487678015,“1.7675194660734148”],[1487678915,“1.7997775305895438”],[1487679815,“1.6952169076751946”],[1487680715,“1.7808676307007785”],[1487681615,“1.6952169076751946”],[1487682515,“1.6596218020022246”],[1487683415,“1.6818687430478307”],[1487684315,“1.618464961067853”],[1487685215,“1.5617352614015572”],[1487686115,“1.5550611790878752”],[1487687015,“1.5728587319243603”],[1487687915,“1.4438264738598443”],[1487688815,“1.2892102335928808”],[1487689715,“1.314794215795328”],[1487690615,“1.3181312569521688”],[1487691515,“1.271412680756396”],[1487692415,“1.2625139043381532”],[1487693315,“1.268075639599555”],[1487694215,“1.2669632925472747”],[1487695115,“1.2614015572858732”],[1487696015,“1.2636262513904337”],[1487696915,“1.2658509454949944”],[1487697815,“1.264738598442714”],[1487698715,“1.260289210233593”],[1487699615,“1.2658509454949944”],[1487700515,“1.2636262513904337”],[1487701415,“1.2669632925472747”],[1487702315,“1.2625139043381532”],[1487703215,“1.2614015572858732”],[1487704115,“1.264738598442714”],[1487705015,“1.2703003337041154”],[1487705915,“1.2614015572858732”],[1487706815,“1.2636262513904337”],[1487775215,“1.268075639599555”]]}]}} ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 22, 2017, 10:09am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/12 "2017-02-22T10:09:12Z")
And i have to delete some strings from responses because of limitation on forum. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 23, 2017, 1:08am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/13 "2017-02-23T01:08:36Z")
As I can see, all data fetchable from exporters, all data exists in prometheus database and grafana backend successfully returns it. so you can try to disable any kind of adblocker and any similar tool, open “Developer Tools” in your browser and try to catch any javascript or network errors. ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 23, 2017, 1:29am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/14 "2017-02-23T01:29:45Z")
Mykola, for example, do you really think than blocking one metric from three on “MySQL Overview” page “MySQL Connections” can be blocked on client level? Good server show 3 metrics: “Max Connections”, “Max Used Connections”, “Connections”, bad server shows two of them, it doesnt show “Max Connections”. Look at the graph higher. Of course, i checked it by the different browsers(opera, firefox, chrome) from 2 computers located in different subnetworks, but result was expected - nothing change 🙂 And other question - we checked that data exist, but we do not check why some of data missing, not all, but part of them. ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 23, 2017, 1:39am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/15 "2017-02-23T01:39:52Z")
And more. Few days ago i install new PMM server with new container, and reconfigure bad server to sending data to new PMM. And problem doesnt resolve. I.e. looks like problem not on PMM Server side, looks like pmm-client do not send all necessary info. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 24, 2017, 2:02am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/16 "2017-02-24T02:02:39Z")
Hi Aleksey, let me describe PMM architecture - [url][Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/architecture.html%5B/url%5D) we have two independent parts in PMM - Query Analytics and Metrics Monitor. Metrics Monitor consists of - [prometheus/mysqld\_exporter](https://github.com/prometheus/mysqld_exporter) - daemon which fetch metrics directly from mysql and provide prometheus compatible API for them - [prometheus/prometheus](https://github.com/prometheus/prometheus) - some kind of time series database + daemon which fetch data from exporters - [grafana/grafana](https://github.com/grafana/grafana) - complicated javascript interface which can visualize graphs + daemon which can fetch data from prometheus and represent it in JSON pmm-client don’t collect and don’t send any data, it is just create start-up file for mysqld\_exporter and run it. in post [#](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47254-pmm-gravana-does-not-show-all-data?p=47330#post47330)7 we have checked that mysqld\_exporter collect needed metric from mysql in post [#9](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47254-pmm-gravana-does-not-show-all-data?p=47342#post47342) we have checked that prometheus successfully fetched and stored this data inside. in post [#11](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47254-pmm-gravana-does-not-show-all-data?p=47354#post47354) we have checked that grafana backend can return metrics values in javascript compatible form. Grafana it is mostly javascript tool, so then you open dashboard, JS fetch dashboard template from backend via the following call [url][https://PMM-SERVER-IP/graph/api/dashboards/db/mysql-overview[/url]](https://PMM-SERVER-IP/graph/api/dashboards/db/mysql-overview%5B/url%5D) you can open “Developer Tools” in browser and open graphs for good and bad hosts and check that “mysql-overview” dashboard template always the same for all hosts (and has mysql\_global\_status\_connections line in description). after template fetching JS parse it and make many “query\_range” calls to backend. [url][https://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query\_range?query=LINE\_FORMULA\_FROM\_TEMPLATE[/url]](https://PMM-SERVER-IP/graph/api/datasources/proxy/1/api/v1/query_range?query=LINE_FORMULA_FROM_TEMPLATE%5B/url%5D) we already checked this call in post [#11](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47254-pmm-gravana-does-not-show-all-data?p=47354#post47354) now we should understand why javascript don’t fetch or don’t show fetchable data. ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 24, 2017, 3:22am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/17 "2017-02-24T03:22:24Z")
Hi, Mykola! Sorry about doubt, you are very systematic 🙂 About “Developer Console” - i had never use id before, so maybe i made some mistakes. I wasn’t able to do everything you asking about, and looks like dashboard template always same. I will spent more time for it to be sure for 100%. But there some errors appears in console when i switch from good server to bad server: File mt.app-1487925994963.log in [dropbox](https://www.dropbox.com/sh/geb4muklvi0v67d/AACA1I1GfRkwDjlBiKF4jVRva?dl=0) It is to large to post directly ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [February 27, 2017, 2:56am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/18 "2017-02-27T02:56:44Z")
News: All servers: good server ![2good.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/1b11e555d4e787a703b1dd81e4f7a3ef983dd8f8.png) ![1all.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/b55cf2706a6860850069cb3f3d66274a478b6b1e.png) ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [March 1, 2017, 4:35am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/19 "2017-03-01T04:35:43Z")
Gaps looks like network issues: prometheus very depends on network delays. if communication between exporter\<-\>prometheus near 1s you can receive such issues. ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [March 1, 2017, 4:49am UTC](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417/20 "2017-03-01T04:49:04Z")
Yep, network. Yesterday reinstall pmm server on new host and newer docker, and gaps has gone. But problem with bad server stayed. Funny, but bad server shows good statistics for some time before reinstalling, but not long, less then hour, all metrics, all values. If you look on last picture, you can see max connection metric not exist, after that exist. Really, i try to use Developer Tool to “open graphs for good and bad hosts and check that “mysql-overview” dashboard template always the same for all hosts (and has mysql\_global\_status\_connections line in description)”. May be i don’t understand something, but i don’t see differences. If you can show some screen shot about how did you do that, it would help me to check that i do it in right way. [Next page](https://forums.percona.com/t/pmm-gravana-does-not-show-all-data/5417.md?page=2)