# How to remove misconfigured node from PMM ? and Value not updated in DB uptime **URL:** \ **Category:** MySQL & MariaDB\ **Tags:** community, pmm, percona\ **Created:** [August 8, 2022, 9:51am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939 "2022-08-08T09:51:43Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 8, 2022, 9:51am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/1 "2022-08-08T09:51:43Z")
Hello Percona Community, We have configured PMM node on separate node. one node is misconfigured and due to this its shows N/A. Actual node name is vm-mysql1-prod-sa and its misconfigured with msyql1-prod-sa. Now how can i remove this msyql1-prod-sa from the pmm. and also on real mysql node why it shows db uptime NA. ? can you please help me on this. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/32ed81ea9e529b98fc34b378ef0106909b169a0b.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 1:17pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/2 "2022-08-09T13:17:36Z")
Hello Percona Team, I have deleted the node entry from setting \> inventory \> Nodes but it still show the graph on dashboard. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/4edfb5e42cd6e0c4ab5c44893560920f120c7bbc.png) but dashboard still show the this node with NA. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/6fd51c34d73a402f82fb957fb677f26b548e73dd.png) can you please help me on this.? ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 2:41pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/3 "2022-08-09T14:41:26Z")
also pmm-admin inventory list nodes shows all monitored node even after removing it. #pmm-admin inventory list nodes Nodes list. Node type Node name Address Node ID GENERIC\_NODE vm-mysql1-prod-sa 10.3.50.11 /node\_id/1167799e-aa05-42b8-a49e-2b895abee08f GENERIC\_NODE vm-mysql3-prod-sa 10.3.50.13 /node\_id/3a7297d4-716c-4d62-bb9b-a7160eef10b4 GENERIC\_NODE vm-mysql-con1-prod-ue2 10.6.50.21 /node\_id/5a8f285b-473f-4423-b89e-65b904b6acc5 GENERIC\_NODE vm-mysql1-prod-ue2 10.6.50.11 /node\_id/6b951f3d-8ebb-4d81-972b-00eace4f348b GENERIC\_NODE vm-mysql2-prod-sa 10.3.50.12 /node\_id/6f5df068-4ada-44b2-bec4-aacc707d17aa GENERIC\_NODE vm-mysql-con2-prod-ue2 10.6.50.22 /node\_id/8f9652f3-4f5f-4c5c-8ba3-ff8041d1977b GENERIC\_NODE vm-mysql-con1-prod-sa 10.3.50.21 /node\_id/b52867bb-cab2-49cf-b9d1-cd18f8313ac7 GENERIC\_NODE vm-mysql-con2-prod-sa 10.3.50.22 /node\_id/c6a56124-254c-4166-a95f-2f104adaf828 GENERIC\_NODE vm-mysql3-prod-ue2 10.6.50.13 /node\_id/e352f62e-576e-4b69-94c1-1cd97f7fd31f GENERIC\_NODE vm-mysql2-prod-ue2 10.6.50.12 /node\_id/f09bdf88-e766-4c61-abe0-30baa13ec04c GENERIC\_NODE pmm-server 127.0.0.1 pmm-server ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 2:48pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/4 "2022-08-09T14:48:05Z")
PMM dashboard shows deleted nodes. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a49e3657cd64e5729c3902d70087c1850bfaf222.jpeg) Also mysql instance overview shows 5 Services while drop down list shows 6 services. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/fe6683fbf0168aa5e9fba016e00f871eb7eaea15.png) Please help me on this configuration. ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 9, 2022, 4:40pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/5 "2022-08-09T16:40:57Z")
Hello! Can you show “Services” in Inventory? Seems, like you delete node, but didn’t delete service. ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 6:39pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/6 "2022-08-09T18:39:49Z")
Hello @Anton_Bystrov , reconfigure the pmm client on vm-mysql1-prod-sa node. **# pmm-admin config --server-insecure-tls --server-url=[https://admin:\*\*\*\*\*\*@pmm-serverip:443](https://admin:******@pmm-serverip:443) mysqlnode\_IP --force** **# pmm-admin add mysql vm-mysql1-prod-sa --username=pmm --password=** \*\* --query-source=perfschema 127.0.0.1:13306\*\* ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/64da5aa4f4fa367506fb701a702ac32979c7e199.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 6:49pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/7 "2022-08-09T18:49:38Z")
PMM home dash board shows this unwanted entry. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/e2349163e242aa197820a703c33294559478ce3d.jpeg) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 7:05pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/8 "2022-08-09T19:05:19Z")
@Anton_Bystrov also while checking innodb details for each node it shows N/A ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0cce366323ab04f2ef7075a635950c2c4d961647.png) ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 9, 2022, 7:05pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/9 "2022-08-09T19:05:47Z")
Please, try to remove this service from UI, with force, like here. ![изображение](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f65cc3f36513de3c2a82217a6cfca1cb618eee55.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 7:08pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/10 "2022-08-09T19:08:14Z")
Hey Anton thanks for reply. But that service not seen in UI as i have already deleted previously and created new one using above command… i have just created new service with vm-mysql1-prod-sa. and unwanted node on dash board shows with mysql1-prod-sa. ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 9, 2022, 7:30pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/11 "2022-08-09T19:30:19Z")
Can you change look behind window to less interval? Not 12 hours. ![изображение](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/09860ab85d296ff403ac7e5f34457f3438ee1012.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 9, 2022, 7:46pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/12 "2022-08-09T19:46:25Z")
Okey. but now we have total added node in PMM is 6 Mysql DB nodes + 1 PMM DB + 4 other server = total 11 node (7 db node + 4 other node). but PMM monitored node shows only 10. also for every node it not shows data for innodb (N/A). ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/e051a60aa313bb45266a4e78b52ab45697379873.png) ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 10, 2022, 6:49am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/13 "2022-08-10T06:49:35Z")
Check, please, metric “mysql\_info\_schema\_table\_version” do you have it? What labels do you have in it? Do you have label “engine=“InnoDB””? Also at the “Monitored nodes” graph line is down, some time ago one node was off. ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 10, 2022, 7:07am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/14 "2022-08-10T07:07:42Z")
> [@Anton\_Bystrov](#): > > mysql\_info\_schema\_table\_version where i can find this mysql\_info\_Schema\_table\_version?? ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 10, 2022, 7:14am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/15 "2022-08-10T07:14:34Z")
At left menu ![изображение](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/aa63a98efb2feb06fa75b4f373999a18188756a6.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 10, 2022, 7:21am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/16 "2022-08-10T07:21:58Z")
> [@Anton\_Bystrov](#): > > mysql\_info\_schema\_table\_version Thanks. i could not find that matric. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f4bb7d817447a8a951ae9f1b1315453861ae4c46.png) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 11, 2022, 11:07am UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/17 "2022-08-11T11:07:00Z")
hello Percona PMM team, I have install pmm-server on new server and add mysql node but facing same issue on new fresh installation also. could not find the mysql\_info\_schema\_table\_version in matric and PMM does not load innodb storage summary and many details. i have reconfigured all. #pmm-admin config --server-insecure-tls --server-url=[https://admin](https://admin):pmmpassword@pmm\_node\_ip:443 mysql\_node\_ip #pmm-admin add mysql vm-mysql3-prod-ue2 --username=pmm --password=pass --query-source=perfschema 127.0.0.1:3306 root@vm-mysql3-prod-ue2:/home/tungsten# pmm-admin add mysql vm-mysql3-prod-ue2 --username=pmm --password=\*\*\*\*\* --query-source=perfschema 127.0.0.1:13306 MySQL Service added. Service ID : /service\_id/09932419-d074-4a3c-87bf-d5e8cbe08a39 Service name: vm-mysql3-prod-ue2 Table statistics collection disabled (the limit is 1000, the actual table count is 1952). ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [August 11, 2022, 1:56pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/18 "2022-08-11T13:56:51Z")
Try to increase limits, please. [Optimize - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/how-to/optimize.html) ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [August 11, 2022, 7:05pm UTC](https://forums.percona.com/t/how-to-remove-misconfigured-node-from-pmm-and-value-not-updated-in-db-uptime/16939/19 "2022-08-11T19:05:41Z")
@Anton_Bystrov Thank you so much for your assistance resolving the issue. At last after 3 days figure out issue. #pmm-admin add mysql vm-msyql3 --username=pmm --password=\*\*\*\*\*\* --query-source=perfschema --disable-tablestats-limit=4000 127.0.0.1:13306 Now data populated for innodb. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/7de3d1d44b0c57ac2971a4b260c019115d6a0a72.png) Thanks Again. Pavankumar. 🙂 ❤