01-01-2015
Quote:
Originally Posted by
scriptor
Hi Don
does it means it means that server is not working properly ??
i executed the above cmd on server.
higher value is good or lower value of %idle is good .
---------- Post updated at 12:09 PM ---------- Previous update was at 12:07 PM ----------
i was checking server overload through sar command.
i am not sure if higher value is good or lower .
If you want to have hardware configured to get the job done at minimum costs, you would expect low %idle. If you want a system that is always available and will respond immediately to requests, you would expect high %idle. Is 10am on New Year's day a good time to determine the load on your servers? Did you have a representative load on your servers at that time?
Since I have no idea how you are trying to configure your server, no idea whether these four seconds represent "normal" use of your server, and (as Scrutinizer said) no idea why your numbers don't add up; I have absolutely no idea whether low %idle is good or high %idle is good.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a command called
cd $HDRROOT/release/tools/cfg
My query is what it means?
tHat is.... $HDRROOT part is not clear.
If I put this command it says path not found....
I doubt that $HDRROOT is trying to mean smething I am not clear of.
PL help......... (4 Replies)
Discussion started by: rraajjiibb
4 Replies
2. HP-UX
Dear All,
Our HPUX 8 GB 8CPU database server is behaving abnormally for the last 4+ weeks. I have generated a sar output and it is here-
11:46:52 %usr %sys %wio %idle
11:46:53 1 1 6 92
11:46:54 0 1 0 99
11:46:55 0 1 0... (3 Replies)
Discussion started by: Ashrunil
3 Replies
3. UNIX for Dummies Questions & Answers
Can you please tell me what this means?
use grep to find from the file myfile.txt all lines containing the sequence tt but not more 2 ts?
I have no idea. (2 Replies)
Discussion started by: rushhour
2 Replies
4. UNIX for Advanced & Expert Users
:) Hi,
In some script i got these regular expression
like ,
n=$#
and
for i in $*
can anybody let me know, what does it means (5 Replies)
Discussion started by: deb.simply
5 Replies
5. UNIX for Dummies Questions & Answers
I can not find out what the %U means in the following command:
ooffice -calc %U (2 Replies)
Discussion started by: borobudur
2 Replies
6. Shell Programming and Scripting
Hi,
I have seen in some ksh script, that we are executing shell scripts inside other shell script as
. variable.sh
What is . here? Their is space between . and variabloe. And why we are not executing it like ./variable.sh? I know that . signifies current directory , but what its... (2 Replies)
Discussion started by: jatanig
2 Replies
7. Shell Programming and Scripting
what exactly $? and $# means ? (1 Reply)
Discussion started by: mail2sant
1 Replies
8. Programming
#define abc '\xE8' (7 Replies)
Discussion started by: kamlesh33
7 Replies
9. UNIX for Beginners Questions & Answers
HI
what does the $(NF) means.
here i want to understand the working.
what i know is that in awk NF argument will tell number of column in a file
i have below file
alpha
a
beta
b
if i use command cat kv | paste - - | awk '{print $1," "$2 "------>"$(NF)}'
i get the o/p as
alpha ... (3 Replies)
Discussion started by: scriptor
3 Replies
LEARN ABOUT PHP
pg_transaction_status
PG_TRANSACTION_STATUS(3) PG_TRANSACTION_STATUS(3)
pg_transaction_status - Returns the current in-transaction status of the server.
SYNOPSIS
int pg_transaction_status (resource $connection)
DESCRIPTION
Returns the current in-transaction status of the server.
Caution
pg_transaction_status(3) will give incorrect results when using a PostgreSQL 7.3 server that has the parameter autocommit set to
off. The server-side autocommit feature has been deprecated and does not exist in later server versions.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
RETURN VALUES
The status can be PGSQL_TRANSACTION_IDLE (currently idle), PGSQL_TRANSACTION_ACTIVE (a command is in progress), PGSQL_TRANSACTION_INTRANS
(idle, in a valid transaction block), or PGSQL_TRANSACTION_INERROR (idle, in a failed transaction block). PGSQL_TRANSACTION_UNKNOWN is
reported if the connection is bad. PGSQL_TRANSACTION_ACTIVE is reported only when a query has been sent to the server and not yet com-
pleted.
EXAMPLES
Example #1
pg_transaction_status(3) example
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$stat = pg_transaction_status($dbconn);
if ($stat === PGSQL_TRANSACTION_UNKNOWN) {
echo 'Connection is bad';
} else if ($stat === PGSQL_TRANSACTION_IDLE) {
echo 'Connection is currently idle';
} else {
echo 'Connection is in a transaction state';
}
?>
PHP Documentation Group PG_TRANSACTION_STATUS(3)