Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Pls. help with vmstat output...


 
Thread Tools Search this Thread
# 1  
Pls. help with vmstat output...

Hi,

Users are reporting performance issue on my Sun Solaris 10 server. I am on the server. I don't see a issue or I might be looking at the wrong thing. Please help.

I don't see anything on sar. it's all zero on that. Not sure why users are reporting high CPU and unresponsive at times. Please advise.

Code:
 
 
bash-3.00# vmstat 5 10
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr s1 s2 s3 s4   in   sy   cs us sy id
 0 0 0 20506808 4478936 14 42 3 0  0  0  0 80  0 -0 25  576 5189 1193  2  2 96
 0 0 0 15647368 547008 2  4  2  0  0  0  0  0  0  0 28  457  926  612  0  1 99
 0 0 0 15647368 547064 0  0  0  0  0  0  0  0  0  0 27  362 1023  588  0  1 99
 0 0 0 15647368 547064 14 55 0  0  0  0  0  0  0  0 43  395 1450  793  0  1 99
 0 0 0 15646288 546128 223 331 6 2 2  0  0  0  0  0 31  375 2598  800  2  2 95
 0 0 0 15647336 547024 0  0  0  0  0  0  0  0  0  0 34  373  921  621  0  1 99
 0 0 0 15647296 546984 0  0  0  0  0  0  0  0  0  0 26  370 1735  615  1  1 98
 0 0 0 15647296 546984 0  0  0  0  0  0  0  0  0  0 29  611 2301  650  1  1 98
 0 0 0 15647168 546856 0  0  0  0  0  0  0  0  0  0 27  595  807  570  0  1 99
 0 0 0 15646896 546584 5 35  0  0  0  0  0  0  0  0 30  615 1287  679  0  1 99

Code:
bash-3.00# swap -s
total: 6042408k bytes allocated + 74784k reserved = 6117192k used, 15714592k available

Code:
bash-3.00# vmstat -s
        0 swap ins
        0 swap outs
        0 pages swapped in
        0 pages swapped out
278719283 total address trans. faults taken
  1550955 page ins
    47604 page outs
  2563835 pages paged in
    83755 pages paged out
 95569406 total reclaims
 95554145 reclaims from free list
        0 micro (hat) faults
278719283 minor (as) faults
  1400663 major faults
366825812 copy-on-write faults
 56843033 zero fill page faults
    61436 pages examined by the clock daemon
        0 revolutions of the clock hand
    68470 pages freed by the clock daemon
  1225565 forks
   266840 vforks
  1265895 execs
7944256901 cpu context switches
3833984919 device interrupts
493857253 traps
34555934259 system calls
3694815074 total name lookups (cache hits 95%)
 56576969 user   cpu
 52216516 system cpu
2555164048 idle   cpu
        0 wait   cpu


# 2  
You are experiencing some paging (see po column and observe swap and free)... the fix (usually) is more memory. When you have low cpu utilization and people are complaining, this is often times the cause.
 

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Reason for abnormal value in vmstat output
anaigini45
Hi, Recently from the vmstat output in the image attached, the first line of the cpu idle column shows a value of 15. Although the subsequent values show higher than 90, is there a reason why the first value is so low? Is this a problem? Thanks.... Solaris
4
Solaris
fr and sr (from vmstat output) values are very high
Beginer0705
Hi AIX Expert, the fr (page freed/page replacement) and sr (pages scanned by page-replacement algorithm) values from the vmstat output (see below please) are very high. I usually see this high value during the oracle database backup. In addition, the page scan/page steal/ page faults values...... AIX
7
AIX
help with vmstat output
jamie_collins
Hi all. I need some assistance with my vmstat output. We have several oracle db's running on our solaris machine: SunOS rcworaprd 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-480R Recently I bumped up our main Oracle database to use 6 GB instead of 4 GB as vmstat output was showing...... Solaris
1
Solaris
vmstat incomprehensible output
Vit0_Corleone
Hello everybody, When i run Nmon the output is really incomprehensible vmstat 5 System configuration: lcpu=16 mem=24576MB ent=4.00 kthr memory page faults cpu ----- ----------- ------------------------ ------------ -----------------------...... AIX
3
AIX
output of vmstat
gfhgfnhhn
i have 2 question about vmstat 1) pin (pagein) output of vmstat is always zero for our system what is the meaning of this? (pout significantly changes depending on the running processes) 2) sometimes react output of vmstat is given in K like 44K sometimes it is given without any unit...... UNIX for Advanced & Expert Users
1
UNIX for Advanced & Expert Users

Featured Tech Videos