One of our database server is suddenly became very slow and i have no clue what to do .Please help. I m sharing the performance inforamtion regarding cpu,harddisk,ram .
---------- Post updated at 04:16 AM ---------- Previous update was at 04:15 AM ----------
I dont have a much information on when this problem occurred but whenever i try to execute any command or take a putty session of the machine it takes too much time to execute it.
I made the run-queue for kernel threads bold. According to that you can see that there is all CPU-time used up for user and system while at same time idle is zero.
The top ten of your CPU-using processes might not help since there could be loads of small processes, that use only a bit of CPU-time but all together a big amount.
You might want to check top for a longer listing when this ps aux is not running and also you might check with a ps piped into awk for example to count how many processes are using how much CPU, as a summary.
You can try something like
Code:
ps -eo pcpu,comm| awk '{_[$2]+=$1} END{for(a in _)print _[a],a| "sort"}'
It is not very exact but it adds the CPU-time in % of the same commands up.
It could be that the box has so much trouble because there is something uneffectively written/configured in the software or if everything is allright, it might need more CPUs. Just a guess so far - you have to monitor and research more.
If it is only 1, then you have to do something for process performance, like increasing the processor, or restricting unwanted process in that machine and make it exclusive for your purposes.
Hi All,
can any one help me on this please.
Replace sting in FILE1.txt with FILE2.txt. FILE1.txt record must have at least one state is repeated once.But need to replace only from second occurrence in record in FILE1.txt
Condition: order of searching the records in FILE2.txt is impartent.... (8 Replies)
IN solaris, for network high-availability we are using IPMP concept, can u tell me in REDHAT LINUX what we are using... also pls share good step to read & understand the that concept...
Also performance issue in linux what are step & cmd can u tell me??? (2 Replies)
I need a shell script to copy files frm a linux machine to a windows machine using SCP. The files keeps changing day-to-day. I have to copy the latest file to the windows machine frm the linux machine.
for example :In Linux, On July 20, the file name will be 20.txt and it should be copied to... (3 Replies)
hi I am having a performance issue with the following requirement
i have to create a permutation and combination on a set of three files
such that each record in each file is picked and the output is redirected in
a specific format but it is taking around 70 odd hours to prepare a
combination... (7 Replies)
We develop software for diagnostic tools for cars. we a use a portable PC(x86) runs Win98 to run our applications.
Hence the working environment in the company is Windows, specifically we use BASIC to develop the GUI, communication functions, DLL, etc. and run them on the Win98 PC.
We suggested... (1 Reply)
I basically want to login into different linux machines( on the same network) from a windows machine. I know i can use ssh <machine name>. But i want to automate this process. I dont want to enter the username and password. Is there any way to do it. Can i make some sort of a batch script for it. (4 Replies)
About 4 years ago I wrote this tool inspired by Rob Urban's collect tool for DEC's Tru64 Unix. What makes this tool as different as collect was in its day is its ability to run at a low overhead and collect tons of stuff. I've expanded the general concept and even include data not available in... (0 Replies)
Hi,
on a linux server I have the following :
vmstat 2 10
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 4 0 675236 39836 206060 1617660 3 3 3 6 8 7 1 1 ... (1 Reply)
We have a AIX v5.3 on a p5 system with a poor performing Ingres database.
We added one CPU to the system to see if this would help. Now there are two CPU's.
with sar and topas -P I see good results: CPU usage around 30%
with topas I only see good results in the process output screen, the... (1 Reply)
Two processes at the same machine communicaton with each other use TCP. The communicaton flow between them is very heavy.
My question is How the impaction of "processes at the same machine communicaton " .If I mv one process to another machine and send the same data, the impact is less than... (1 Reply)
