From owner-freebsd-stable@FreeBSD.ORG Mon Oct 17 11:40:47 2011 Return-Path: Delivered-To: stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D39ED1065677 for ; Mon, 17 Oct 2011 11:40:47 +0000 (UTC) (envelope-from victor@bsdes.net) Received: from equilibrium.bsdes.net (244.Red-217-126-240.staticIP.rima-tde.net [217.126.240.244]) by mx1.freebsd.org (Postfix) with ESMTP id 29A658FC0C for ; Mon, 17 Oct 2011 11:40:46 +0000 (UTC) Received: by equilibrium.bsdes.net (Postfix, from userid 1001) id C436C3983F; Mon, 17 Oct 2011 13:22:44 +0200 (CEST) Date: Mon, 17 Oct 2011 13:22:44 +0200 From: Victor Balada Diaz To: stable@freebsd.org Message-ID: <20111017112244.GA1202@equilibrium.bsdes.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.5.21 (2010-09-15) Cc: Subject: Problems with pagedaemon X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 17 Oct 2011 11:40:48 -0000 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% 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.