# mysql connection,network usage hourly ,select type can't show in pmm version 1.1.5 **URL:** \ **Category:** PMM 1.x\ **Created:** [July 20, 2017, 3:25am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753 "2017-07-20T03:25:40Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [July 20, 2017, 3:25am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/1 "2017-07-20T03:25:40Z")
mysql connection,network usage hourly ,select type can’t show in pmm version 1.1.5,others is normal. ![photoid=49094](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/5/5f6ac9a807e607c30716d1f69d3e7015e7820a44.jpeg) ![photoid=49095](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0cb53c5fffb7b2fcc9ab3f4524f34751944d7ee3.jpeg) ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [July 20, 2017, 9:02pm UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/2 "2017-07-20T21:02:21Z")
can you help me to check ? ---
**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:** [July 21, 2017, 7:57am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/3 "2017-07-21T07:57:16Z")
[kaky2000](https://percona.vanillacommunities.com/profile/x/x/40116) my apologies for the delay on this topic. how many pmm clients do you have? can you check if data for “MySQL Network Usage Hourly” graph exists in prometheus directly? it is needed to open this link [url][http://PMM-SERVER-IP/prometheus/graph?g0.range\_input=1h&g0.expr=mysql\_global\_status\_bytes\_received&g0.tab=0[/url]](http://PMM-SERVER-IP/prometheus/graph?g0.range_input=1h&g0.expr=mysql_global_status_bytes_received&g0.tab=0%5B/url%5D) can you share a screenshot? ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [July 23, 2017, 8:03pm UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/4 "2017-07-23T20:03:53Z")
TOTOL 6 clients,3 for mysql,3 for mongodb. ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [July 23, 2017, 8:11pm UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/5 "2017-07-23T20:11:29Z")
1、can you check if data for “MySQL Network Usage Hourly” graph exists in prometheus directly? could you give me a guideline ? 2、it is needed to open this link [url][http://PMM-SERVER-IP/prometheus/grap...eived&g0.tab=0[/url]](http://PMM-SERVER-IP/prometheus/grap...eived&g0.tab=0%5B/url%5D) ![photoid=49162](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/3cbe5947fa36eee377763b7f66e0dabc76f07cc5.jpeg) ---
**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:** [July 24, 2017, 3:44am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/6 "2017-07-24T03:44:40Z")
it is possible to do it manually: 0. add “prometheus/” to the end of the PMM Server URL (like [url][http://PMM-SERVER-IP/prometheus/[/url]](http://PMM-SERVER-IP/prometheus/%5B/url%5D)) 1. open “Graph” page 2. enter “mysql\_global\_status\_bytes\_received” metric name to “Expression” field 3. click “Execute” button 4. choose “Graph” tab on “Graph” page 5. increase the period to 12h until now. see find the screenshot below. ![graph.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a8331f402ba591cc890201dd27f282f8d7b7ac79.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:** [July 25, 2017, 3:17am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/7 "2017-07-25T03:17:18Z")
can you check the following expressions? ```auto max(max_over_time(mysql_global_status_threads_connected[24h])) ``` and ```auto increase(mysql_global_status_bytes_received[1h]) ``` I need load time details for both expressions. ![load_time.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/8f156042e1cd4993f88658351f8d3cbfe8ced418.png) ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [August 2, 2017, 2:33am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/8 "2017-08-02T02:33:52Z")
could you help me check? ---
**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:** [August 2, 2017, 3:08am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/9 "2017-08-02T03:08:52Z")
[kaky2000](https://percona.vanillacommunities.com/profile/x/x/40116), my apologies for the delay on this topic. how many RAM do you have? can you increase prometheus memory up to 8Gb ? METRICS\_MEMORY=5991800 see [URL=“[Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/faq.html#how-to-control-memory-consumption-for-pmm)”][https://www.percona.com/doc/percona-...mption-for-pmm[/URL]](https://www.percona.com/doc/percona-...mption-for-pmm%5B/URL%5D) ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [August 3, 2017, 12:53am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/10 "2017-08-03T00:53:44Z")
256GB i create and run the command:(set 50GB) docker run -d -p 80:80 --volumes-from pmm-data -e METRICS\_MEMORY=50194304 -e METRICS\_RESOLUTION=5s --name pmm-server --restart always [docker.gf.com.cn/percona/pmm-server:1.1.5](http://docker.gf.com.cn/percona/pmm-server:1.1.5) But it still slow,check the picture. ![photoid=49265](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/8a74e60945f744dabc66ee7a69b58aebee4c19c7.jpeg) ![photoid=49266](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/5/5ce531c72e380a83ca6431142257ac1d37fbc027.jpeg) ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [August 3, 2017, 1:29am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/11 "2017-08-03T01:29:23Z")
It seem that prometheus doesn’t use 50GB memory, could you help me check ? ![photoid=49269](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/13ccae710050f05b295ccd712bee1cdf44dbbe9a.jpeg) ![photoid=49270](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/7af9dc4f78728d6ea0e1185ace325feb73ccda34.jpeg) ---
**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:** [August 3, 2017, 9:13am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/12 "2017-08-03T09:13:03Z")
Hi [kaky2000](https://percona.vanillacommunities.com/profile/x/x/40116) , > [@](#): > > It seem that prometheus doesn’t use 50GB memory it is expectable, prometheus use only needed the amount of RAM How many pmm-clients do you have? can you share ? can you restart prometheus? ```auto docker exec -it pmm-server supervisorctl restart prometheus ``` is it acceptable to lose all historical data for all graphs? ---
**Author:** ![kaky2000](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@kaky2000](https://forums.percona.com/u/kaky2000)\ **Post date:** [August 4, 2017, 4:24am UTC](https://forums.percona.com/t/mysql-connection-network-usage-hourly-select-type-cant-show-in-pmm-version-1-1-5/5753/13 "2017-08-04T04:24:12Z")
I try to stop docker,and recreate the docker (readd the client monitor）,it can work normally now，and now it can use more memory .