Problems with pagedaemon

[Victor Balada Diaz]

Hello,

I have a MySQL server that even without any query executing is eating a lot of CPU.
After taking a look at what's happening, seems the problem is that pagedaemon is eating
a lot of CPU. System is not swapping.

Any ideas on what can i look to know why is pagedaemon eating so much CPU?

I attached the info that i think could be useful, but if you need something more,
just ask.

Regards.

FreeBSD version: 8.1-RELEASE
MySQL Version: mysql-server-5.1.56
File system: UFS2, no ZFS installed
Storage: Adaptec 5405 with 4 SCSI SAS disks on RAID 10
real memory  = 25769803776 (24576 MB)
avail memory = 24837259264 (23686 MB)
CPU: Intel(R) Core(TM) i7 CPU       X 980  @ 3.33GHz (3355.00-MHz K8-class CPU)


top -HS output:

last pid:  9640;  load averages:  5.04,  4.29,  3.89                                                                                                             up 165+19:02:39 13:14:32
180 processes: 17 running, 137 sleeping, 26 waiting
CPU:  0.0% user,  0.0% nice, 21.7% system,  0.1% interrupt, 78.2% idle
Mem: 18G Active, 1984M Inact, 2974M Wired, 157M Cache, 2465M Buf, 448M Free
Swap: 4096M Total, 4096M Free

  PID USERNAME PRI NICE   SIZE    RES STATE   C   TIME   WCPU COMMAND
   11 root     171 ki31     0K   192K CPU11  11 3973.3 100.00% {idle: cpu11}
    8 root      76    -     0K    16K CPU7    7 133:16 100.00% pagedaemon
   11 root     171 ki31     0K   192K CPU9    9 3976.1 86.38% {idle: cpu9}
   11 root     171 ki31     0K   192K CPU1    1 3956.5 80.27% {idle: cpu1}
   11 root     171 ki31     0K   192K CPU6    6 3968.8 74.17% {idle: cpu6}
   11 root     171 ki31     0K   192K CPU5    5 3969.2 72.75% {idle: cpu5}
   11 root     171 ki31     0K   192K CPU3    3 3967.2 72.66% {idle: cpu3}
   11 root     171 ki31     0K   192K CPU8    8 3974.3 62.50% {idle: cpu8}
   11 root     171 ki31     0K   192K RUN    10 3972.4 57.76% {idle: cpu10}
   11 root     171 ki31     0K   192K CPU4    4 3963.7 55.08% {idle: cpu4}
   11 root     171 ki31     0K   192K CPU2    2 3940.5 52.10% {idle: cpu2}
80533 mysql     76    0 20908M 19355M biord   0 106:33 48.00% {mysqld}
80533 mysql     76    0 20908M 19355M ucond   2  12:13 47.27% {mysqld}
   11 root     171 ki31     0K   192K CPU0    0 3941.9 46.78% {idle: cpu0}
80533 mysql    104    0 20908M 19355M CPU1    1 607:21 38.38% {mysqld}
    3 root      -8    -     0K    16K -       5 143:13 37.16% g_up
 9640 root     101    0  9336K  2100K CPU10  10   0:03 25.29% top
80533 mysql     54    0 20908M 19355M sbwait  4   7:53 22.27% {mysqld}
   11 root     171 ki31     0K   192K RUN     7 3970.5 10.06% {idle: cpu7}
13503 victor    49    0  9336K  2448K CPU8    8   3:07  7.47% top
 7682 victor    50    0  9336K  3084K select  0   2:25  5.76% top
 8002 root      53    0 10296K     0K pause   9   0:19  4.49% <csh>
    9 root      46    -     0K    16K psleep  8   1:01  3.76% vmdaemon


sysctl vm.stats.vm output:

vm.stats.vm.v_kthreadpages: 0
vm.stats.vm.v_rforkpages: 0
vm.stats.vm.v_vforkpages: 1770817093
vm.stats.vm.v_forkpages: 2012248610
vm.stats.vm.v_kthreads: 21
vm.stats.vm.v_rforks: 0
vm.stats.vm.v_vforks: 6822338
vm.stats.vm.v_forks: 7667817
vm.stats.vm.v_interrupt_free_min: 2
vm.stats.vm.v_pageout_free_min: 34
vm.stats.vm.v_cache_max: 323542
vm.stats.vm.v_cache_min: 161771
vm.stats.vm.v_cache_count: 42352
vm.stats.vm.v_inactive_count: 507855
vm.stats.vm.v_inactive_target: 242656
vm.stats.vm.v_active_count: 4668821
vm.stats.vm.v_wire_count: 761236
vm.stats.vm.v_free_count: 112751
vm.stats.vm.v_free_min: 38447
vm.stats.vm.v_free_target: 161771
vm.stats.vm.v_free_reserved: 7983
vm.stats.vm.v_page_count: 6093208
vm.stats.vm.v_page_size: 4096
vm.stats.vm.v_tfree: 1587184388
vm.stats.vm.v_pfree: 2052461115
vm.stats.vm.v_dfree: 0
vm.stats.vm.v_tcached: 200409554
vm.stats.vm.v_pdpages: 206312407
vm.stats.vm.v_pdwakeups: 100136 
vm.stats.vm.v_reactivated: 50080723
vm.stats.vm.v_intrans: 346784
vm.stats.vm.v_vnodepgsout: 0
vm.stats.vm.v_vnodepgsin: 89871
vm.stats.vm.v_vnodeout: 0
vm.stats.vm.v_vnodein: 27358
vm.stats.vm.v_swappgsout: 0
vm.stats.vm.v_swappgsin: 0
vm.stats.vm.v_swapout: 0
vm.stats.vm.v_swapin: 0
vm.stats.vm.v_ozfod: 473155
vm.stats.vm.v_zfod: 2011670267
vm.stats.vm.v_cow_optim: 363755
vm.stats.vm.v_cow_faults: 1097383176
vm.stats.vm.v_vm_faults: 15143069


-- 
La prueba más fehaciente de que existe vida inteligente en otros
planetas, es que no han intentado contactar con nosotros.