Integrating bash with sql. Post: 302444813

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Integrating bash with sql. Post 302444813 by pinga123 on Friday 13th of August 2010 12:30:18 AM

08-13-2010

Registered User

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.

pinga123

View Public Profile for pinga123

Find all posts by pinga123

9 More Discussions You Might Find Interesting

1. Programming

about wave file integrating.

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.

2. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

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.

3. UNIX for Dummies Questions & Answers

bash script & sql query

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...

4. UNIX for Dummies Questions & Answers

Integrating bash script into php (page)

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?:(

5. Shell Programming and Scripting

Convert sql output to csv file via bash tools

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 ...

6. Programming

Integrating Jconsole with Eclipse

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

7. Shell Programming and Scripting

Help with integrating shell script with sendmail

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:...

8. Shell Programming and Scripting

Passing string from SQL to a BASH script

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...

9. Programming

Integrating bash shell

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#.

LEARN ABOUT NETBSD

cpuset_clr

CPUSET(3)						   BSD Library Functions Manual 						 CPUSET(3)

NAME

     cpuset_create, cpuset_destroy, cpuset_zero, cpuset_set, cpuset_clr, cpuset_isset, cpuset_size -- dynamic CPU sets

SYNOPSIS

     #include <sched.h>

     cpuset_t *
     cpuset_create(void);

     void
     cpuset_destroy(cpuset_t *set);

     void
     cpuset_zero(cpuset_t *set);

     int
     cpuset_set(cpuid_t cpu, cpuset_t *set);

     int
     cpuset_clr(cpuid_t cpu, cpuset_t *set);

     int
     cpuset_isset(cpuid_t cpu, const cpuset_t *set);

     size_t
     cpuset_size(const cpuset_t *set);

DESCRIPTION

     This section describes the functions used to create, set, use and destroy the dynamic CPU sets.

     This API can be used with the POSIX threads, see pthread(3) and affinity(3).

     The ID of the primary CPU in the system is 0.

FUNCTIONS

     cpuset_create()
	      Allocates and initializes a clean CPU-set.  Returns the pointer to the CPU-set, or NULL on failure.

     cpuset_destroy(set)
	      Destroy the CPU-set specified by set.

     cpuset_zero(set)
	      Makes the CPU-set specified by set clean, that is, memory is initialized to zero bytes, and none of the CPUs set.

     cpuset_set(cpu, set)
	      Sets the CPU specified by cpu in set.  Returns zero on success, and -1 if cpu is invalid.

     cpuset_clr(cpu, set)
	      Clears the CPU specified by cpu in the CPU-set set.  Returns zero on success, and -1 if cpu is invalid.

     cpuset_isset(cpu, set)
	      Checks if CPU specified by cpu is set in the CPU-set set.  Returns the positive number if set, zero if not set, and -1 if cpu is
	      invalid.

     cpuset_size(set)
	      Returns the size in bytes of CPU-set specified by set.

SEE ALSO

     affinity(3), pset(3), sched(3), schedctl(8), kcpuset(9)

HISTORY

     The dynamic CPU sets appeared in NetBSD 5.0.

BSD
								 November 2, 2011							       BSD