DBPROBE(1) Performance Co-Pilot DBPROBE(1)NAME
dbprobe.pl - database response time and availability information
SYNOPSIS
dbprobe.pl [ delay ]
DESCRIPTION
The dbprobe.pl utility is used by pmdadbping(1) to measure response time from a database. A given query is executed on the database at the
requested interval (delay, which defaults to 60 seconds). This response time measure can be exported via the Performance Co-Pilot
framework for live and historical monitoring using pmdadbping(1).
SEE ALSO pmcd(1), pmdadbping(1) and DBI(3).
3.8.10 Performance Co-Pilot DBPROBE(1)
Check Out this Related Man Page
PMDADBPING(1) Performance Co-Pilot PMDADBPING(1)NAME
pmdadbping - database response time and availability PMDA
DESCRIPTION
Simple database response time measurement PMDA. dbprobe.pl(1) should be configured to use the type of DBI appropriate for your database,
which includes: RDBMS flavour, user/password, delay between "ping" requests, and the SQL statement to use. pmdadbping runs dbprobe.pl(1),
and exports the performance measurements it makes available as PCP metrics.
INSTALLATION
Configure dbprobe.pl(1) - it uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/dbping/dbprobe.conf
This file can contain overridden values (Perl code) for the settings listed at the start of dbprobe.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
o SQL statement to measure (probe)
o 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
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/dbping
# ./Remove
pmdadbping is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
FILES
$PCP_PMDAS_DIR/dbping/probes.stp
probe configuration file for stap(1), run 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
SEE ALSO pmcd(1), dbprobe.pl(1) and DBI(3).
3.8.10 Performance Co-Pilot PMDADBPING(1)
Hi everyone,
I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX.
Ok onto business, my questions are-:
Was/Is UNIX ever an open source operating system ?
If UNIX was... (21 Replies)
Hello and thanks in advance for any help anyone can offer me
I'm trying to learn the find command and thought I was understanding it... Apparently I was wrong. I was doing compound searches and I started getting weird results with the -size test. I was trying to do a search on a 1G file owned by... (14 Replies)
hi all,
i have installed quota on my centos 7 machine and its what im after (setting size limit on users, so they cant fill the hard drive)
i want to now make this part of my create user script for my sftp server so i want to do a echo and a read command so i capture the limit they enter... (0 Replies)
Hi everybody,
Which Unix base OS have best performance for HOST virtualization?
I tested SmartOS but it needs another OS to connect remotely!
Thanks in advance. (11 Replies)
Hi All,
I need to write a shell script which opens a file and increments the version(text) within the file every time the script runs. For example:
$ cat docker_file.yml
version: '3.1'
services:
ui:
image: repo-srv.dev.io:5000/facebook/ui:0.0.2-QA1
$
So, I would like... (6 Replies)
Dear Team
We use DB2 v10.5 and using DBArtisan tool
Can someone please guide how to convert digits to binary numbers using db2 feature.
Ex> for number 9 , binary should be 1001 ( 8+1)
Any help appreciated. Thanks (2 Replies)
hi folks,
how to using tar with exclude directory and compress it using tar.Z
i only know how to exclude dir only with this command below:
tar -cvf /varios/restore/test.tar -X excludefile.txt /jfma/test1/
how to compress it using 1 command?
Thanx
Please use CODE tags as... (6 Replies)
Quite an obscure question I think.
We have a rebuild process for remote sites that allows us to PXE rebuild a till (actually a PC with a touch screen and various fancy bits) running CentOS. The current CentOS5 tills work just fine with a tar image restore and some personalisation. Sadly,... (4 Replies)
Hello All,
I had recently learnt a bit of Docker(which provides containerization process).
Here are some of my learning points from it.
Let us start first with very basic question:
What is Docker:
Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
What is the point of this? Whenever I close my shell it appends to the history file without adding this. I have never seen it overwrite my history file.
# When the shell exits, append to the history file instead of overwriting it
shopt -s histappend (3 Replies)
Hello... And thanks in advance for any help anyone can offer me
I was trying to work out the differences between displaying modify, access, and change times with the 'ls' command. Everything seems in order when I look at files, but the access time on a directory doesn't seem to change when I... (4 Replies)
Hello everyone,
I am having an issue here with CentOS release 6.6 (Final) that shows all of the space used up, but I can't tell where the space went.
Seemingly I am using up 100%, according to
df -h
Filesystem Size Used Avail Use% Mounted on... (27 Replies)
I'm trying to use a bash script for a psych experiment that involves listening to sound files and responding. If I have something like the code below, how can I make sure that a key press is assigned to RESPONSE only after the second echo statement?
for i in 1 2 3; do
echo "Ready?"
sleep 2
... (10 Replies)
After the success of the jq - tool for parsing and manipulating JSON-Data someone wrote a tool called yq, which aims to be the same for YAML, what jq is for JSON. Seems to work fine. I'll definitely give it a chance in future.
Example YAML-File:
--- !ruby/object:Puppet::Node::Facts
... (1 Reply)
Dear All,
I am very pleased to announce that Dave Munro (gull04) is joining the Moderation Team, after being a very valuable member of UNIX.com for 15+ years.
Dave is an IT Consultant with 30 years of experience this year, has worked in many of the industry vertical market segments and has... (6 Replies)