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.