From owner-freebsd-stable@FreeBSD.ORG Tue Sep 8 10:39:23 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A45291065670 for ; Tue, 8 Sep 2009 10:39:23 +0000 (UTC) (envelope-from tlott@gamesnet.de) Received: from spirit.gamesnet.de (spirit.gamesnet.de [87.230.101.86]) by mx1.freebsd.org (Postfix) with ESMTP id 607538FC20 for ; Tue, 8 Sep 2009 10:39:23 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by spirit.gamesnet.de (Postfix) with ESMTP id EA124290523 for ; Tue, 8 Sep 2009 12:19:50 +0200 (CEST) X-Virus-Scanned: amavisd-new at gamesnet.de Received: from spirit.gamesnet.de ([127.0.0.1]) by localhost (spirit.gamesnet.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jah0-u+THDGO for ; Tue, 8 Sep 2009 12:19:46 +0200 (CEST) Received: from sub.han.vpn.gamesnet.de (sub.han.vpn.gamesnet.de [192.168.1.101]) by spirit.gamesnet.de (Postfix) with ESMTPSA id 8D550290516 for ; Tue, 8 Sep 2009 12:19:46 +0200 (CEST) Date: Tue, 8 Sep 2009 12:19:45 +0200 From: Tobias Lott To: freebsd-stable Message-ID: <20090908121945.43ba3976@sub.han.vpn.gamesnet.de> X-Mailer: Claws Mail 3.7.2 (GTK+ 2.16.6; i386-portbld-freebsd7.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: System crawls after Upgrade 7.0->7.2 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: Tue, 08 Sep 2009 10:39:23 -0000 Hey Everyone, I upgraded a Dual Core Machine to 7.2-Stable (2 Days ago), all OS related Stuff is located on an UFS Slice, Application is on a ZFS Volume. After the Upgrade everything seemed fine, but a User noticed one PHP Script which is basically loading a plain Textfile into Mysql times out. PHP Timeout was set to 60 secs, that was more then enough just one day before the upgrade. System-wise its like Mysql can't get get the data fast enough, process is max at 10% cpu usage most of the time in sbwait state. Haven't changed any sysctl (kern.maxvnodes="200000", vm.kmem_size="512M" vm.kmem_size_max="512M" vfs.zfs.arc_max="100M" but had those before already) or kernel parameter at that time. But according to the Wiki's ZFS Tuning Guide those aren't needed anymore so I tried without but no change there either. I checked the following (and the current used values each): maxproc maxfiles kern.ipc.somaxconn kern.ipc.nmbclusters Getting no error messages dmesg, syslog wise. Tried moving Mysql to the UFS Slice but same thing happens happens there. Some very basic testing like dd-ing: # dd if=/dev/da0 of=/dev/null bs=1024 count=1048576 1048576+0 records in 1048576+0 records out 1073741824 bytes transferred in 157.698602 secs (6808823 bytes/sec) FreeBSD hostname 7.2-STABLE FreeBSD 7.2-STABLE #3 r196954: Tue Sep 8 02:10:22 CEST 2009 root@hostname:/usr/obj/usr/src/sys/SPIRIT amd64 Since I upgraded the Machines zpool to version 13 already I don't really wanna go back to 7.0, but it seems the only way out atm. Hopefully someone can give me a Hint where maybe I forgot to check. Somehow it feels like the last Versions, I'd say starting with 7.x doesn't really feel that Rock-Stable as Versions Prior used to be. Prolly cause I'm using an Experimental Feature like ZFS, so no Offense nor Blame and this is not intended as a Flame or whatsoever! So don't get me wrong, I always liked, used, recommended FreeBSD since 4.0 and will continue to do so! Best Regards -- Tobias Lott