11-27-2008
Thanks manikantants
awk '{ if (NR==FNR) { my_array[$1]=$1; next;} if ( $1 in my_array ) {print $0}}' file1 file2
unbelievable it takes only 10 seconds
10 More Discussions You Might Find Interesting
1. AIX
Helo:
We updated form AIX 4.3.3 to AIX 5.1-7 and after this we spent more than double time in read from external disks. Aparently the ssa cards microcode is at last level and all the ptf and apars are instaled.
Out backups expent more than double time, but curiously in read only, if we write in... (0 Replies)
Discussion started by: Javier Gutierre
0 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have one basic doubt, that using grep command frequently , will it have direct impact on the CPU load, pls clarify
for eg, if i run a non stop script containing while loop to grep some parameters, what will be the load in CPU..
thanks (3 Replies)
Discussion started by: vasikaran
3 Replies
3. UNIX for Dummies Questions & Answers
hi,
i want to know cpu utilizatiion per process per cpu..for single processor also if multicore in linux ..to use these values in shell script to kill processes exceeding cpu utilization.ps (pcpu) command does not give exact values..top does not give persistant values..psstat,vmstat..does njot... (3 Replies)
Discussion started by: pankajd
3 Replies
4. Solaris
Hello Friends,
On one of my Solaris 10 box, CPU usage shows 100% using "sar", "vmstat". However, it has 4 CPUs and prstat and glance are not showing enough processes to justify high CPU utilization.
=========================================================================
$ prstat -a
... (4 Replies)
Discussion started by: mahive
4 Replies
5. Solaris
Hello every body,
Maybe someone could help me.
I have a SUN Server with 6 disks, each of 150 Gb.
I have mounted the first two disk in mirror (RAID1) for the system files.
I have mounted 3 disks in RAID5 for users file systems.
I kept the last one as spare and I have mounted it standalone... (6 Replies)
Discussion started by: aribault
6 Replies
6. UNIX for Advanced & Expert Users
Hello !
I will use my best english possible to explain my objective. I'm french so pardon for the lack of precision...
So, what i would like to do in shell script (but you will possibly answer ''not possible in script'' have to use low level langage or something like that) is described below.... (3 Replies)
Discussion started by: Gnaag
3 Replies
7. UNIX for Dummies Questions & Answers
guys i need suggestion about how to grep cpu usage and then compare it
example :
if cpu usage <= 40% then print normal and how much cpu usage is
or cpu usage between 40%-65% print normal and much cpu usage is
i've tried like this one but got error
DOMAIN=`uname -n`... (9 Replies)
Discussion started by: ashary
9 Replies
8. UNIX and Linux Applications
How can grep hog your entire cpu? I am absolutely shocked by this. (11 Replies)
Discussion started by: cokedude
11 Replies
9. UNIX for Dummies Questions & Answers
We have a single threaded application which is restricted by CPU usage even though there are multiple CPUs on the server, hence leading to significant performance issues. Is it possible to merge / combine multiple CPUs at OS level so it appear as a single CPU for the application? (6 Replies)
Discussion started by: Dissa
6 Replies
10. UNIX for Beginners Questions & Answers
I read that Entitlement CPU should be set to max 75% compare to Virtual CPU. May I know the reason.
I have set the Entitlement CPU = Virtual CPU on AIX . It works fine .
Can you help to understand. (1 Reply)
Discussion started by: gabhanes
1 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1).
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)