PMDADBPING(1)

💖 PMDADBPING 💖

okay bestie, welcome to pmdadbping(1) from the General Commands Manual section — yes she's a section 1 girlie and she's here to tell you how your database is feeling 🩺✨

---

✨ NAME ✨

pmdadbping — the database response time and availability PMDA 🦋

---

🌸 DESCRIPTION 🌸

So like, pmdadbping is a database response time measurement PMDA. That's her whole thing. That's the vibe. 💅

What she does is run dbprobe(1) and then export all the performance measurements that dbprobe(1) makes available as PCP metrics. literally just taking those numbers and putting them on the PCP shelf for you 🔥

And here's the important part — dbprobe(1) should be configured to use the type of DBI appropriate for the local database, which includes all of this:

• RDBMS flavour 🍓
• user/password 🔐
• delay between "ping" requests ⏱️
• the SQL statement to use 📝

no cap, you gotta set those. she's not gonna guess your database for you.

---

🎀 INSTALLATION 🎀

First things first: configure dbprobe(1) — she uses a configuration file from (in this order):

• /etc/pcpdbi.conf
• $PCP_PMDAS_DIR/dbping/dbprobe.conf

This file can contain overridden values (Perl code, bestie, yes it's Perl) for the settings listed at the start of dbprobe.pl, namely:

• database name (see DBI(3) for details)
• database user name
• database pass word
• SQL statement to measure (probe)
• delay between probes

Once this is setup, you can access the names and values for the dbping performance metrics by doing the following as root:

# cd $PCP_PMDAS_DIR/dbping
# ./Install

To uninstall, the following must be done as root:

# cd $PCP_PMDAS_DIR/dbping
# ./Remove

⚠️ real talk: pmdadbping is launched by pmcd(1) and should never be executed directly. do not run her by hand, she has main character energy but she is not a solo act. 🙈

The Install and Remove scripts notify pmcd(1) when the agent is installed or removed. so it's all handled, you don't gotta text pmcd yourself 📲

---

🦋 FILES 🦋

• $PCP_PMDAS_DIR/dbping/dbprobe.conf — probe configuration file for dbprobe(1), used indirectly by pmdadbping
• $PCP_PMDAS_DIR/dbping/Install — installation script for the pmdadbping agent
• $PCP_PMDAS_DIR/dbping/Remove — undo installation script for the pmdadbping agent
• $PCP_LOG_DIR/pmcd/dbping.log — default log file for error messages from pmdadbping

---

🌈 PCP ENVIRONMENT 🌈

Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. 🧚 On each installation, the file /etc/pcp.conf contains the local values for these variables. The $PCP_CONF variable may be used to specify an alternative configuration file, as described in pcp.conf(5).

so yeah — PCP_ prefix, /etc/pcp.conf for the local values, $PCP_CONF if you wanna point somewhere else. iykyk 💜

---

👑 SEE ALSO 👑

PCPIntro(1), pmcd(1), dbprobe(1) and DBI(3). go read those next, bestie, they're iconic ⭐

---

okay that's the whole page!! this was brought to you by Performance Co-Pilot 💖 — PCP era, PMDADBPING(1) edition. mwah, go ping your database responsibly 🫶✨