08-13-2010
Quote:
Originally Posted by
citaylor
Data such as cpu utilization are transitory, and as such aren't very useful in themselves.
Shell script, and languages such as perl are more than adequate to process simple numbers such as cpu utilization to provide trend data, which can then be stored in a database or indeed flat files for later use. Can you try to explain why you are trying to use SQL in this instance ? Ie, what functionality SQL brings to this task that cannot be accomplished in other ways ?
Thx
For example.
Output of top shows process id and amount of CPU consumed by it.
If i write a script for telling the maximum cpu utilization its pretty simple but how would i get something very complex like getting cpu utilization of particular process id over the period .
Group by command and other functions like select max(cpu_uti),process)_id from toptable group by (process id)
This is just a one example with sql you can have lot of options. I guess sqlite is a tool i should go for.
9 More Discussions You Might Find Interesting
1. Programming
Now I have two wave file(*.wav) at Tru64 Unix machine.
I want to make a new wave file including the two wave file.
how I should finish this programmer.
If you know, can you give me the format of the wave file(*.wav)
and Sun au file(*.au).
Thank you. (1 Reply)
Discussion started by: livic
1 Replies
2. Shell Programming and Scripting
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?
Thank you! :D
J. (0 Replies)
Discussion started by: ph0enix
0 Replies
3. UNIX for Dummies Questions & Answers
Hi Guys,
I would like with this script
"DATA=`ora123 su -c 'echo "SET HEADING OFF;\n SET FEED OFF;\n select USER NAME, ACCOUNT_STATUS from dba_users;\n exit" | sqlplus / as sysdba -s /' `
echo $DATA >> $DAT"
make a sql query, but the statement
"select USER NAME, ACCOUNT_STATUS from... (6 Replies)
Discussion started by: ixibits
6 Replies
4. UNIX for Dummies Questions & Answers
I have written a bash script...now i need to call the script from php page.
Can you give me an example to demonstrate how it is done?:( (1 Reply)
Discussion started by: xerox
1 Replies
5. Shell Programming and Scripting
hi
Can anybody help me with converting such structure into csv file for windows :
BAT_ID ID_num CVS_LINE A_SEG SKILL_TO A_CUSTOMER_TYPE
--------- ---------- --------------------------------- ---------- ------------------ -----------
14-MAY-11 777752 ... (4 Replies)
Discussion started by: kvok
4 Replies
6. Programming
Hi Guys,
I was hoping someone has integrated Eclipse with jconsole to monitor their applications. I have not seen this in action .
Any help is much appreciated http://images.devshed.com/fds/smilies/smile.gif
Thanks (0 Replies)
Discussion started by: aish11
0 Replies
7. Shell Programming and Scripting
Hi friends,
I want to converting a task ,of making few words in my task mail bold and underlined sometimes, automated through sendmail.
I have never used sendmail/mailx before.
What i want is my ouput which looks like below:
+++++++++++++++
DETAILS: sqlid:6mbiosdfsdff parsing_schema_name:... (1 Reply)
Discussion started by: kunwar
1 Replies
8. Shell Programming and Scripting
OS Solaris 10,
DB oracle 10g
Hello,
We currently have a BASH script that runs and moves image files from a remote server to the local db server. A snippet of the code shows that we are picking up all Images that are 'mtime -1'
some code...
for file in `ssh user@10.200.200.10 'find... (3 Replies)
Discussion started by: JonP
3 Replies
9. Programming
Hi folks...
I am working on a project where I need to have online bash bash shell integrated in my web page. I am not clear of how to do it. can any one suggest?? The UI needs to be developed in c#. (11 Replies)
Discussion started by: keerthi koneru
11 Replies
LEARN ABOUT PHP
mysql_db_query
MYSQL_DB_QUERY(3) 1 MYSQL_DB_QUERY(3)
mysql_db_query - Selects a database and executes a query on it
SYNOPSIS
Warning
This function was deprecated in PHP 5.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
omysqli_select_db(3) then the query
o PDO::__construct
resource mysql_db_query (string $database, string $query, [resource $link_identifier = NULL])
DESCRIPTION
mysql_db_query(3) selects a database, and executes a query on it.
o $database
- The name of the database that will be selected.
o $query
- The MySQL query. Data inside the query should be properly escaped.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns a positive MySQL result resource to the query result, or FALSE on error. The function also returns TRUE/ FALSE for INSERT/ UPDATE/
DELETE queries to indicate success/failure.
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | This function now throws an E_DEPRECATED notice. |
| | |
+--------+---------------------------------------------------+
Example #1
mysql_db_query(3) alternative example
<?php
if (!$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
echo 'Could not connect to mysql';
exit;
}
if (!mysql_select_db('mysql_dbname', $link)) {
echo 'Could not select database';
exit;
}
$sql = 'SELECT foo FROM bar WHERE id = 42';
$result = mysql_query($sql, $link);
if (!$result) {
echo "DB Error, could not query the database
";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
echo $row['foo'];
}
mysql_free_result($result);
?>
Note
Be aware that this function does NOT switch back to the database you were connected before. In other words, you can't use this
function to temporarily run a sql query on another database, you would have to manually switch back. Users are strongly encouraged
to use the database.table syntax in their sql queries or mysql_select_db(3) instead of this function.
mysql_query(3), mysql_select_db(3).
PHP Documentation Group MYSQL_DB_QUERY(3)