From owner-freebsd-performance@FreeBSD.ORG Tue Dec 30 07:12:29 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 36E66106564A for ; Tue, 30 Dec 2008 07:12:29 +0000 (UTC) (envelope-from pheriko.support@gmail.com) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by mx1.freebsd.org (Postfix) with ESMTP id 0249B8FC0C for ; Tue, 30 Dec 2008 07:12:28 +0000 (UTC) (envelope-from pheriko.support@gmail.com) Received: by wa-out-1112.google.com with SMTP id m34so2880740wag.27 for ; Mon, 29 Dec 2008 23:12:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=3wrJ1EW0S49QfFQGD3ef3rWnOPxSBPMNxLqVD2IELEM=; b=Y9u1fKS+q1nV2s8zMI29EUmR29/Z+swDOoTHK/myMI50OatPlwpxNMqQ0GnWq9TXPx kMcFAl2yATKC2xxyPj19WKlDGwmz8vW6yTiStcHNGtlFK/APbl5NZadQK2fj0AcqDdsO +MT5SPkzGVbKHngRCvZ7/uWqD/HY6efjG9oLs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=aAClfdJ1wDanEZw6T8GQi/K7FkSi2C3wmv4fMvrG/MlestP8ajRoBgLOd0CJHbLgb4 3d8ep3GhLQoP8GeoQuVnHKzbzaS0uyfpDBGf3mgBZWEHOPuEHz4+p42olGRv92+6oVMi 6RDlgIpL7k0TpoYn0L5It77xKosi/MlZGzW+U= Received: by 10.115.22.1 with SMTP id z1mr9523619wai.216.1230621148735; Mon, 29 Dec 2008 23:12:28 -0800 (PST) Received: by 10.114.209.9 with HTTP; Mon, 29 Dec 2008 23:12:28 -0800 (PST) Message-ID: <5b1d935a0812292312r2c1dc418v292cee112ba59068@mail.gmail.com> Date: Mon, 29 Dec 2008 23:12:28 -0800 From: "Periko Support" To: freebsd-performance@freebsd.org In-Reply-To: <5b1d935a0812291808g6e8b7540sdd42a6357aa6835c@mail.gmail.com> MIME-Version: 1.0 References: <5b1d935a0812291750p46b4da74s92f756c646ff4601@mail.gmail.com> <5b1d935a0812291808g6e8b7540sdd42a6357aa6835c@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: bonnie++ result, can someone tech me how to understand this data and help me tunning my system a little more? X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Dec 2008 07:12:29 -0000 Other thing is that we are using myisam in mysql. Just to correct one thing, "I'm not the programmer". Thanks!!! On Mon, Dec 29, 2008 at 6:08 PM, Periko Support wrote: > Hi people. > > I have found a way to show u my results, u can see in the title of the > page what flags I give to bonnie++, I test inside /var because is where > mysql run. > > The page is *Bonnie Result s > > Thanks again for your time!!! > > * > > On Mon, Dec 29, 2008 at 5:50 PM, Periko Support > wrote: > >> Hi people. >> >> I want to learn how to get more from my system, I will run a new >> application with mysql 5.1.30, this app is develop en .NET(I'm the >> programmer) the clients will be all windows xp boxes, with ps/2 scanner to >> add, get, update the data to mysql, querys etc,etc, them reading about >> performance, for a database is important the file system, I start googling >> around and found tha exist a lot of free app to benchmark the hard disk, one >> of the is bonnie++, I have been running several times in my system, now I >> have the results, I would like to know what is the meaning and what >> parameters can I change to see if I can get better results based on your >> point of view. >> >> All my programs are installed from ports. >> >> I have the results in one file called bonnie-res.html, I atach the file >> here, I don't know if exist a place where I can put this file to be public? >> Plus my kernel file called BACULA. >> >> I was thinking in pastebin, but right now I cannot run bonnie and send >> the output to cvs, because my system is running the backup. >> >> Technical details: >> OS: 7.0-RELEASE-p6 i386 (Custom Kernel) >> 512RAM >> >> Motherboard: >> Foxconn KM400 Duron 1.6Ghz >> >> Raid-1 with geom_mirror >> >> disk 1: ad0: setting PIO4 on 8235 chip >> ad0: setting UDMA100 on 8235 chip >> ad0: 286168MB at ata0-master UDMA100 >> ad0: 586072368 sectors [581421C/16H/63S] 16 sectors/interrupt 1 depth >> queue >> >> Disk 2: ad2: setting PIO4 on 8235 chip >> ad2: setting UDMA100 on 8235 chip >> ad2: 305245MB at ata1-master UDMA100 >> ad2: 625142448 sectors [620181C/16H/63S] 16 sectors/interrupt 1 depth >> queue >> >> Both disk on different channels. >> >> This is my make.conf file: >> >> CPUTYPE?=athlon >> CFLAGS= -O2 -fno-strict-aliasing -pipe >> CXXFLAGS+= -fconserve-space >> MAKE_SHELL?=sh >> BDECFLAGS= -W -Wall -ansi -pedantic -Wbad-function-cast -Wcast-align >> \ >> -Wcast-qual -Wchar-subscripts -Winline \ >> -Wmissing-prototypes -Wnested-externs -Wpointer-arith \ >> -Wredundant-decls -Wshadow -Wstrict-prototypes >> -Wwrite-strings >> #COPTFLAGS= -O -pipe >> ENABLE_SUID_SSH= >> PPP_NO_NAT= # do not build with NAT support (see make.conf(5)) >> PPP_NO_NETGRAPH= # do not build with Netgraph support >> PPP_NO_RADIUS= # do not build with RADIUS support >> PPP_NO_SUID= # build with normal permissions >> TRACEROUTE_NO_IPSEC= # do not build traceroute(8) with IPSEC support >> BOOTWAIT=0 >> DOC_LANG= en_US.ISO8859-1 >> FORCE_PKG_REGISTER=yes >> # added by use.perl 2008-12-14 10:36:46 >> PERL_VER=5.8.8 >> PERL_VERSION=5.8.8 >> >> >> My src.conf >> >> WITHOUT_ATM="YES" >> WITHOUT_AUTHPF="YES" >> WITHOUT_BIND="YES" >> WITHOUT_BLUETOOTH="YES" >> WITHOUT_GAMES="YES" >> WITHOUT_I4B="YES" >> WITH_IDEA="NO" >> WITHOUT_HTML="YES" >> WITHOUT_INET6="YES" >> WITHOUT_IPFILTER="YES" >> WITHOUT_IPX="YES" >> WITHOUT_LPR="YES" >> WITHOUT_NCP="YES" >> WITHOUT_PF="YES" >> WITHOUT_RCMDS="YES" >> >> Mount info: >> >> /dev/mirror/gm0s1a on / (ufs, local, soft-updates) >> devfs on /dev (devfs, local) >> /dev/mirror/gm0s1g on /backups (ufs, local, noatime, soft-updates) >> /dev/mirror/gm0s1f on /tmp (ufs, local, noatime, soft-updates) >> /dev/mirror/gm0s1d on /usr (ufs, local, noatime, soft-updates) >> /dev/mirror/gm0s1e on /var (ufs, local, noatime, soft-updates) >> /dev/ad3s1d on /spool (ufs, local, noatime, soft-updates) >> >> I want to first get if is possible a little more from freebsd latter I >> will continue with mysql. >> >> Thanks all for your time, I normally read this maillist, but now I want to >> get a little more from my system. >> >> I will run iozone + sysbench and let u know my results to, if u need more >> info from my system let me know. >> >> Thanks again and happy new year!!! >> >> >