DBPROBE(1) Performance Co-Pilot DBPROBE(1)NAME
dbprobe.pl - database response time and availability information
dbprobe.pl [ delay ]
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
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.
Configure dbprobe.pl(1) - it uses a configuration file from (in this order):
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
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/dbping
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.
probe configuration file for stap(1), run by pmdadbping
installation script for the pmdadbping agent
undo installation script for the pmdadbping agent
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)
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)
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)
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
So, I would like... (6 Replies)
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)
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?
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)
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)
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
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
... (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.
... (1 Reply)
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)