# Database Monitoring and Management

**URL:** https://forums.percona.com/c/percona-monitoring-and-management-pmm/database-monitoring-and-management/34.md?page=1

[Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md)

**Page:** 2

---

## [Monitor deadlocks in PMM](https://forums.percona.com/t/monitor-deadlocks-in-pmm/18677)

<div class="topic-metadata">

**Author:** [@Tanuj\_Bolisetty](https://forums.percona.com/u/Tanuj_Bolisetty)\
**Replies:** 1\
**Last updated:** [November 20, 2022, 9:24pm UTC](https://forums.percona.com/t/monitor-deadlocks-in-pmm/18677 "2022-11-20T21:24:45Z")

</div>

We are using PMM2.32 and unable to see a metric for monitoring deadlocks in mysql. we monitor enterprise mysql and google cloudsql from PMM.

---

## [Export monitoring data to GoogleCloud Monitoring](https://forums.percona.com/t/export-monitoring-data-to-googlecloud-monitoring/18657)

<div class="topic-metadata">

**Author:** [@SCHrodrigo](https://forums.percona.com/u/SCHrodrigo)\
**Replies:** 0\
**Last updated:** [November 18, 2022, 1:30pm UTC](https://forums.percona.com/t/export-monitoring-data-to-googlecloud-monitoring/18657 "2022-11-18T13:30:15Z")

</div>

Hi, We have set up a PMM Server and some Percona XtraDB Cluster with PMM Clients in order to monitor them on our Google Kuberenetes Engine cluster. Since most of our Kubernetes’ monitoring is done thorugh dashboards se…

---

## [Dashboard briefly connects and then EC2 server becomes inaccessible](https://forums.percona.com/t/dashboard-briefly-connects-and-then-ec2-server-becomes-inaccessible/18332)

<div class="topic-metadata">

**Author:** [@Mark\_Rehberger](https://forums.percona.com/u/Mark_Rehberger)\
**Replies:** 7\
**Last updated:** [November 3, 2022, 6:58pm UTC](https://forums.percona.com/t/dashboard-briefly-connects-and-then-ec2-server-becomes-inaccessible/18332 "2022-11-03T18:58:06Z")

</div>

Hi, I followed this documentation exactly with Instance type: m5.large. My EBS volumes provide 8GB for the boot volume and 100GB for the configuration. AWS Marketplace - Percona Monitoring and Management I can briefly …

---

## [Active Connections and Processes with PMM](https://forums.percona.com/t/active-connections-and-processes-with-pmm/17126)

<div class="topic-metadata">

**Author:** [@devdewboy](https://forums.percona.com/u/devdewboy)\
**Replies:** 1\
**Last updated:** [August 24, 2022, 3:12am UTC](https://forums.percona.com/t/active-connections-and-processes-with-pmm/17126 "2022-08-24T03:12:47Z")

</div>

I have a MySQL DB 5.7.30. I would like to be able to get into all active connections to the DB and see what is being run, against what scheme and by what user. Percona’s AuditLog is suppose to do this but am reluctant to…

---

## [Integrated alerting - PostgreSQL connections in use](https://forums.percona.com/t/integrated-alerting-postgresql-connections-in-use/16000)

<div class="topic-metadata">

**Author:** [@jhon.gomez](https://forums.percona.com/u/jhon.gomez)\
**Replies:** 2\
**Last updated:** [July 7, 2022, 4:23am UTC](https://forums.percona.com/t/integrated-alerting-postgresql-connections-in-use/16000 "2022-07-07T04:23:36Z")

</div>

Best regards: I have been testing the integrated alert module and I was validating the use of the PostgreSQL connections in use alert, which when selected by default fills me with the data of: • Threshold= 80 • Durati…

---

## [Database growth dashboard](https://forums.percona.com/t/database-growth-dashboard/14973)

<div class="topic-metadata">

**Author:** [@skiz79](https://forums.percona.com/u/skiz79)\
**Replies:** 3\
**Last updated:** [March 30, 2022, 5:46am UTC](https://forums.percona.com/t/database-growth-dashboard/14973 "2022-03-30T05:46:35Z")

</div>

Hello, I am trying to create a simple dashboard to show database growth trend. I am using the below table to graph but not able to. Any suggestions? datname | datsize | dbgrowth | dbgrowthpercent | tdate …

---

## [PostgresSQL Database/Table size monitoring](https://forums.percona.com/t/postgressql-database-table-size-monitoring/12403)

<div class="topic-metadata">

**Author:** [@winnetou](https://forums.percona.com/u/winnetou)\
**Replies:** 4\
**Last updated:** [October 31, 2021, 6:17pm UTC](https://forums.percona.com/t/postgressql-database-table-size-monitoring/12403 "2021-10-31T18:17:50Z")

</div>

Hello All! I’m trying to monitor PostgreSQL tables/database sizes. I run \>\>\>this\<\<\< tutorial from Percona. It looks like it’s working but PMM Agent is spamming errors in syslog. Here’s my setup: PMM Server: OS/kerne…

---

## [How to integrate google clode sql in PMM along with AWS RDS and normal mysql instances](https://forums.percona.com/t/how-to-integrate-google-clode-sql-in-pmm-along-with-aws-rds-and-normal-mysql-instances/12459)

<div class="topic-metadata">

**Author:** [@Prashant](https://forums.percona.com/u/Prashant)\
**Replies:** 1\
**Last updated:** [October 7, 2021, 12:13pm UTC](https://forums.percona.com/t/how-to-integrate-google-clode-sql-in-pmm-along-with-aws-rds-and-normal-mysql-instances/12459 "2021-10-07T12:13:49Z")

</div>

Hi All, We trying to add instances from multiple cloud provider AWS, GCP. Most of instances are managed instances AWS RDS and GCP SQL instances. We are able to add AWS RDS as that feature is there in PMM and getting OS …

---

## [How to configure mysql percona operator to grafana dashboard](https://forums.percona.com/t/how-to-configure-mysql-percona-operator-to-grafana-dashboard/11677)

<div class="topic-metadata">

**Author:** [@pratheep\_k](https://forums.percona.com/u/pratheep_k)\
**Replies:** 6\
**Last updated:** [August 31, 2021, 5:51am UTC](https://forums.percona.com/t/how-to-configure-mysql-percona-operator-to-grafana-dashboard/11677 "2021-08-31T05:51:10Z")

</div>

What kind of users and pass restriction to be given and database name will show all the metrics in grafana?

---

## [How many number of connection a pmm user make?](https://forums.percona.com/t/how-many-number-of-connection-a-pmm-user-make/11763)

<div class="topic-metadata">

**Author:** [@Sagar\_Kalsaria](https://forums.percona.com/u/Sagar_Kalsaria)\
**Replies:** 4\
**Last updated:** [August 13, 2021, 10:03am UTC](https://forums.percona.com/t/how-many-number-of-connection-a-pmm-user-make/11763 "2021-08-13T10:03:07Z")

</div>

Hi, Anyone aware about how many connection does a mysql ‘pmm’ user (‘pmm’ is the user in mysql in client) makes with the server? Is it depended on the load on client?

---

## [PMM2 Vs Solarwinds DPA](https://forums.percona.com/t/pmm2-vs-solarwinds-dpa/11252)

<div class="topic-metadata">

**Author:** [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Replies:** 5\
**Last updated:** [July 8, 2021, 1:53pm UTC](https://forums.percona.com/t/pmm2-vs-solarwinds-dpa/11252 "2021-07-08T13:53:41Z")

</div>

Can anyone, please provide me the comparision details of PMM2 Vs Solarwinds DPA for managing & monitoring Percona MySQL instances? Thanks in advance.

---

## [Integerate PMM with LDAP/AD](https://forums.percona.com/t/integerate-pmm-with-ldap-ad/10507)

<div class="topic-metadata">

**Author:** [@velumal](https://forums.percona.com/u/velumal)\
**Replies:** 2\
**Last updated:** [May 19, 2021, 3:58pm UTC](https://forums.percona.com/t/integerate-pmm-with-ldap-ad/10507 "2021-05-19T15:58:30Z")

</div>

We are doing a POC in PMM and would like to integerate the server with LDAP/AD for single sign on. how do we do that ? Can somebody share the instructions to achieve this ? Regards, Vinoth

---

## [Prometheus and PMM](https://forums.percona.com/t/prometheus-and-pmm/10173)

<div class="topic-metadata">

**Author:** [@Nehemia](https://forums.percona.com/u/Nehemia)\
**Replies:** 9\
**Last updated:** [April 22, 2021, 4:42am UTC](https://forums.percona.com/t/prometheus-and-pmm/10173 "2021-04-22T04:42:38Z")

</div>

I have a hard time understanding the role of the PMM service In my K8S cluster, I have Prometheus as a monitoring tool which I use to monitor virtually everything Now, using Percona for MySQL I understand that in order…

---

## [Percona monitoring management tool question](https://forums.percona.com/t/percona-monitoring-management-tool-question/10145)

<div class="topic-metadata">

**Author:** [@soumyaukil](https://forums.percona.com/u/soumyaukil)\
**Replies:** 3\
**Last updated:** [April 19, 2021, 7:28pm UTC](https://forums.percona.com/t/percona-monitoring-management-tool-question/10145 "2021-04-19T19:28:10Z")

</div>

Hi Team, I am looking at the percona monitoring management documentation, wherein it has talked about IO analysis for queries. MySQL Query Performance Troubleshooting: Resource-Based Approach - Percona Database Performa…

---

## [Backup pmm server data](https://forums.percona.com/t/backup-pmm-server-data/10085)

<div class="topic-metadata">

**Author:** [@C80SGEEK](https://forums.percona.com/u/C80SGEEK)\
**Replies:** 5\
**Last updated:** [April 16, 2021, 8:12am UTC](https://forums.percona.com/t/backup-pmm-server-data/10085 "2021-04-16T08:12:11Z")

</div>

Hello, I’m using Pmm server from the appliance OVA, on Vmware. My question is, what is the best practice regarding backups ? I want to backup my metrics data. I Goolge a lot arround but did not find any hint. any hel…

---

## [CPU Core details on Prometheus Dashboard](https://forums.percona.com/t/cpu-core-details-on-prometheus-dashboard/9785)

<div class="topic-metadata">

**Author:** [@vamshi7781](https://forums.percona.com/u/vamshi7781)\
**Replies:** 7\
**Last updated:** [March 25, 2021, 10:12am UTC](https://forums.percona.com/t/cpu-core-details-on-prometheus-dashboard/9785 "2021-03-25T10:12:00Z")

</div>

Hi Team, I am trying to add the CPU Core details on the prometheus dashboard, i have got the sample json file from the link " CPU Utilization Details (Cores) | Grafana Labs " In that it is asking for $host – which valu…

---

## [PMM2 collecting and adding memcached metrics, and nginx metrics and logs](https://forums.percona.com/t/pmm2-collecting-and-adding-memcached-metrics-and-nginx-metrics-and-logs/9102)

<div class="topic-metadata">

**Author:** [@dtourrel](https://forums.percona.com/u/dtourrel)\
**Replies:** 2\
**Last updated:** [March 10, 2021, 8:33am UTC](https://forums.percona.com/t/pmm2-collecting-and-adding-memcached-metrics-and-nginx-metrics-and-logs/9102 "2021-03-10T08:33:03Z")

</div>

Hi All, We are using PMM2 on Amazon to monitor a Percona Cluster. We have as well web servers holding ProxySQL that I could register and follow on the PMM dashboard. Now, After spending quite a lot of time reading the…

---

## [about PMM standalone installation](https://forums.percona.com/t/about-pmm-standalone-installation/7871)

<div class="topic-metadata">

**Author:** [@DBA100](https://forums.percona.com/u/DBA100)\
**Replies:** 3\
**Last updated:** [August 28, 2020, 1:42am UTC](https://forums.percona.com/t/about-pmm-standalone-installation/7871 "2020-08-28T01:42:16Z")

</div>

hi as we found out the PMM installation is a pre installed PMM VM and our department do not allow us to install it in our environment, any standalone PMM installation for CentOS 8?

---

## [How to expert MySQL user account, with password and right permission to another MySQL server](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873)

<div class="topic-metadata">

**Author:** [@DBA100](https://forums.percona.com/u/DBA100)\
**Replies:** 12\
**Last updated:** [August 27, 2020, 10:59pm UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873 "2020-08-27T22:59:19Z")

</div>

Hi, As we are going to migrate from percona xtradB cluster 5.7x to 8.0.19, may I know how toexpert MySQL user account, with password and right permission to another MySQL server? I planned to use; mysqldump –host=\<DB ho…

---

## [Create Dashboard in Grafana with Prometheus as Datasource and Linux,Windows as client machine](https://forums.percona.com/t/create-dashboard-in-grafana-with-prometheus-as-datasource-and-linux-windows-as-client-machine/7633)

<div class="topic-metadata">

**Author:** [@Fiddu1221](https://forums.percona.com/u/Fiddu1221)\
**Replies:** 1\
**Last updated:** [May 26, 2020, 12:31am UTC](https://forums.percona.com/t/create-dashboard-in-grafana-with-prometheus-as-datasource-and-linux-windows-as-client-machine/7633 "2020-05-26T00:31:21Z")

</div>

Use Case: § CPU utilization Warning at 89%, Alarm at 90% § Memory utilization Warning at 90%, Alarm at 95% § File System utilization …

[Previous page](https://forums.percona.com/c/percona-monitoring-and-management-pmm/database-monitoring-and-management/34.md)