LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-06-2010, 01:04 AM   #1
pinga123
Member
 
Registered: Sep 2009
Posts: 684
Blog Entries: 2

Rep: Reputation: 36
Linux machine performance issue.


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 information regarding cpu,harddisk,ram .

Code:
########CPU Information########
Machine Uptime Information:
 uptime
 10:25:06 up 16:50,  1 user,  load average: 5.84, 5.65, 5.54
Command Description:
<current time> <Uptime since> <hour:min>
Number of users logged in to machine
load average <for last one minute>,<for last 5 minutes>,<for last 15 minutes>
________________________________________________________________
Terminal Information:
 w
 10:25:07 up 16:50,  1 user,  load average: 5.84, 5.65, 5.54
USER     TTY      FROM              LOGIN@   IDLE   JCPU   PCPU WHAT
root     pts/1    node1           10:18    5.00s  3.61s  0.64s -bash
________________________________________________________________
 cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 10
cpu MHz         : 2660.056
cache size      : 6144 KB
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mtrr mca cmov pat clflush dts mmx fxsr sse sse2 ss syscall lm constant_tsc pni ds_cpl cx16 xtpr lahf_lm
bogomips        : 6660.87
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 10
cpu MHz         : 2660.056
cache size      : 6144 KB
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mtrr mca cmov pat clflush dts mmx fxsr sse sse2 ss syscall lm constant_tsc pni ds_cpl cx16 xtpr lahf_lm
bogomips        : 6660.87
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

________________________________________________________________
Top 10 C.P.U Consumer Processes:
 ps -auxf | sort -nr -k 3 | head -10
root     13857 59.5  0.0  65532   972 pts/1    R+   10:25   0:01              \_ ps -auxf
root     13858 27.5  0.0 109112   664 pts/1    S+   10:25   0:00              \_ sort -nr -k 3
oracle   13842 21.7  0.1 1732792 13488 ?       Rs   10:25   0:02 oracleoracle (LOCAL=NO)
oracle   13860 20.0  0.1  74384 13508 ?        R    10:25   0:00      \_ /u01/app/oracle/111/bin/tnslsnr LISTENER -inherit
oracle   13845 18.4  0.1 1732280 10772 ?       Rs   10:25   0:01 oracleoracle (LOCAL=NO)
oracle   13855 14.6  0.0      0     0 ?        R    10:25   0:00  \_ [tnslsnr]
oracle   13840 13.4  0.1 1732280 12084 ?       Rs   10:25   0:01 oracleoracle (LOCAL=NO)
oracle   10080 10.9  3.4 1740824 279276 ?      Ss   09:29   6:10 oracleoracle (LOCAL=NO)
root     13859 10.5  0.0      0     0 pts/1    R+   10:25   0:00              \_ [bash]
root     13847  8.4  0.0   8680   944 ?        Ss   10:25   0:00      \_ /bin/sh -c /usr/sbin/ntpdate -b 10.180.23.51 >/dev/null 2>&1
________________________________________________________________
########Memory Information########
 cat /proc/meminfo
MemTotal:      8126860 kB
MemFree:       4766148 kB
Buffers:        375952 kB
Cached:        2203984 kB
SwapCached:          0 kB
Active:        1376116 kB
Inactive:      1319760 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:      8126860 kB
LowFree:       4766148 kB
SwapTotal:     2555888 kB
SwapFree:      2555888 kB
Dirty:             480 kB
Writeback:           0 kB
AnonPages:      116040 kB
Mapped:         453748 kB
Slab:           387024 kB
PageTables:      23384 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
CommitLimit:   6619316 kB
Committed_AS:  2439244 kB
VmallocTotal: 34359738367 kB
VmallocUsed:      1516 kB
VmallocChunk: 34359736843 kB
________________________________________________________________
 free -m
             total       used       free     shared    buffers     cached
Mem:          7936       3280       4656          0        367       2152
-/+ buffers/cache:        760       7175
Swap:         2495          0       2495
________________________________________________________________
Top 10 Memory Consumer Processes:
 ps -auxf | sort -nr -k 4 | head -10
oracle   10080 10.9  3.4 1740824 279304 ?      Ss   09:29   6:10 oracleoracle (LOCAL=NO)
oracle   10067  5.8  1.8 1742880 149684 ?      Ss   09:28   3:17 oracleoracle (LOCAL=NO)
oracle    9853  0.2  1.5 1735532 123392 ?      Ss   09:25   0:09 ora_smon_oracle
oracle    9857  0.5  0.9 1738836 79624 ?       Ss   09:26   0:18 ora_mmon_oracle
oracle    9994  4.8  0.8 1741860 66148 ?       Ss   09:27   2:46 oracleoracle (LOCAL=NO)
oracle    9847  0.5  0.5 1737024 42632 ?       Ss   09:25   0:19 ora_dbw0_oracle
oracle    9845  0.1  0.5 1732800 44440 ?       Ss   09:25   0:05 ora_mman_oracle
oracle   10214  0.7  0.5 1734396 41364 ?       Ss   09:31   0:25 ora_cjq0_oracle
oracle   10063  0.1  0.5 1740824 44272 ?       Ss   09:28   0:03 oracleoracle (LOCAL=NO)
oracle   10050  0.1  0.5 1740836 42716 ?       Ss   09:28   0:05 oracleoracle (LOCAL=NO)
________________________________________________________________
########Disk Information########
Disk Utilization
 df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       13G  9.5G  2.4G  80% /
/dev/hda1              99M   20M   75M  21% /boot
tmpfs                 3.9G  1.6M  3.9G   1% /dev/shm
/dev/hdb1             5.0G  414M  4.3G   9% /mnt
/dev/hdd               30G  5.5G   23G  20% /data
10.180.23.194:/dump    29G  1.9G   26G   7% /emdump
________________________________________________________________
Disk Partition Information
 cat /proc/partitions
major minor  #blocks  name

   3     0   15728640 hda
   3     1     104391 hda1
   3     2   15623212 hda2
   3    64    5242880 hdb
   3    65    5237158 hdb1
  22    64   31457280 hdd
 253     0   13565952 dm-0
 253     1    2031616 dm-1
________________________________________________________________

Last edited by pinga123; 08-06-2010 at 01:06 AM.
 
Old 08-06-2010, 01:51 AM   #2
alli_yas
Member
 
Registered: Apr 2010
Location: Johannesburg
Distribution: Fedora 14, RHEL 5.5, CentOS 5.5, Ubuntu 10.04
Posts: 559

Rep: Reputation: 92
Hi pinga123,

Can you post the output of top - your memory/disk usage looks fine.

Also, what do you mean by slow - has your applications become slow in their performance; or is the connection to the machine slow - can you please elaborate?

Thanks,
 
Old 08-06-2010, 05:17 AM   #3
pinga123
Member
 
Registered: Sep 2009
Posts: 684
Blog Entries: 2

Original Poster
Rep: Reputation: 36
Quote:
Originally Posted by alli_yas View Post
Hi pinga123,

Can you post the output of top - your memory/disk usage looks fine.

Also, what do you mean by slow - has your applications become slow in their performance; or is the connection to the machine slow - can you please elaborate?

Thanks,
Code:
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
 3  0      0 5831512  96952 1773232    0    0    35    27   84   43 31 47 21  1  0
 8  1      0 5830232  96956 1773228    0    0     0   200  252  125 35 49 14  1  0
 6  1      0 5829472  96996 1773236    0    0     0   212  366  182 30 68  1  0  0
 5  0      0 5828984  97056 1773176    0    0     0   168  282  164 39 61  0  0  0
 6  0      0 5827488  97056 1773260    0    0     0     0  264   90 35 65  0  0  0
 5  0      0 5826140  97056 1773260    0    0     0    48  263  108 35 65  0  0  0
 4  0      0 5820800  97064 1773252    0    0     0    12  353  139 41 57  2  0  0
 7  0      0 5818164  97064 1773252    0    0     0     0  376  178 41 57  2  0  0
 5  0      0 5820180  97068 1773260    0    0     0   180  325  147 35 63  1  0  0
 1  0      0 5827320  97068 1773260    0    0     0    12  322  146 28 33 39  0  0
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.
 
Old 08-06-2010, 05:23 AM   #4
alli_yas
Member
 
Registered: Apr 2010
Location: Johannesburg
Distribution: Fedora 14, RHEL 5.5, CentOS 5.5, Ubuntu 10.04
Posts: 559

Rep: Reputation: 92
If you say it takes a long "time" to ssh (putty) and/or execute a command; I suggest you check:

1. The network connectivity of your local machine.
2. The network connectivity of the server itself.

A problem with the network (for example broken link/router) could result in you experiencing this delay. A safe way to eliminate the network is to (if possible) go to the physical location of the server and execute commands directly via a KVM or something similar.
 
Old 08-09-2010, 07:28 AM   #5
pinga123
Member
 
Registered: Sep 2009
Posts: 684
Blog Entries: 2

Original Poster
Rep: Reputation: 36
Quote:
Originally Posted by alli_yas View Post
If you say it takes a long "time" to ssh (putty) and/or execute a command; I suggest you check:

1. The network connectivity of your local machine.
2. The network connectivity of the server itself.

A problem with the network (for example broken link/router) could result in you experiencing this delay. A safe way to eliminate the network is to (if possible) go to the physical location of the server and execute commands directly via a KVM or something similar.
This machine is virtualized therefore can't go to physical machine location.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
script for machine performance raqeeb Linux - Software 1 04-14-2010 08:40 AM
libpcap issue in linux 2.6 machine. malli42108 Linux - Newbie 7 02-04-2010 06:20 AM
Issue with 2 Linux OS in my machine peeths003 Linux - Software 14 11-22-2009 07:33 AM
LXer: Linux Kernel Virtual Machine improves build performance LXer Syndicated Linux News 0 07-17-2009 10:21 PM
Network performance on an old machine hansalfredche Linux - Hardware 23 06-15-2007 06:54 AM


All times are GMT -5. The time now is 01:33 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration