From owner-freebsd-questions@FreeBSD.ORG Wed Nov 18 22:06:04 2009 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E55341065672 for ; Wed, 18 Nov 2009 22:06:04 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from email1.allantgroup.com (email1.emsphone.com [199.67.51.115]) by mx1.freebsd.org (Postfix) with ESMTP id A9C3C8FC18 for ; Wed, 18 Nov 2009 22:06:04 +0000 (UTC) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by email1.allantgroup.com (8.14.0/8.14.0) with ESMTP id nAIM62uG014959 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 18 Nov 2009 16:06:02 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (smmsp@localhost [127.0.0.1]) by dan.emsphone.com (8.14.3/8.14.3) with ESMTP id nAIM61UJ046869 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 18 Nov 2009 16:06:01 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.3/8.14.3/Submit) id nAIM61Dh046868; Wed, 18 Nov 2009 16:06:01 -0600 (CST) (envelope-from dan) Date: Wed, 18 Nov 2009 16:06:01 -0600 From: Dan Nelson To: Steve Bertrand Message-ID: <20091118220601.GD89004@dan.emsphone.com> References: <560f92640911181259m37d2659w775fa3fafd9499b6@mail.gmail.com> <4B046D14.1070505@ibctech.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4B046D14.1070505@ibctech.ca> X-OS: FreeBSD 7.2-STABLE User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: ClamAV version 0.94.1, clamav-milter version 0.94.1 on email1.allantgroup.com X-Virus-Status: Clean X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (email1.allantgroup.com [199.67.51.78]); Wed, 18 Nov 2009 16:06:02 -0600 (CST) X-Scanned-By: MIMEDefang 2.45 Cc: questions@freebsd.org, Nerius Landys Subject: Re: Measuring disk I/O X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 18 Nov 2009 22:06:05 -0000 In the last episode (Nov 18), Steve Bertrand said: > Nerius Landys wrote: > > A friend and I are working on a small video-game related project as a > > hobby. We're running several scripts 24/7 that make lots of calls to a > > MySQL database. The mysql server process shows an average CPU use of 1% > > (reported by top) and it never goes above about 2% The tables it's > > hitting are myisam tables. I'm a little bit worried that the mysql > > process is using a lot of disk access. I don't know too much about hard > > disks but my feeling is that too much disk use could slow the machine > > down or cause a premature hard disk failure. WD Raptor model. > > > > I don't know if my concerns are well-founded, but I would like to > > measure impact on the hard disk somehow. I don't know how to see disk > > I/O. I do know how to use top. How do I measure disk I/O? Any other > > thoughts? > > Perhaps gstat(8) will help you get started: > > # gstat -a > > dT: 1.001s w: 1.000s > L(q) ops/s r/s kBps ms/r w/s kBps ms/w %busy Name > 4 176 114 10261 14.9 62 607 25.4 96.8| ar0 > 4 177 115 10389 17.8 62 607 26.5 100.0| ar0.eli > 1 34 34 527 30.8 0 0 0.0 99.1| ar0.elie > 2 66 4 16 20.5 62 607 26.6 98.0| ar0.elif > 1 77 77 9845 12.1 0 0 0.0 93.0| ar0.elig iostat -x gives similar output, although only to the device level, not the slice. There's also top's 'io' mode (press m), which will show per-process i/o stats of varying usability (I/O to zfs doesn't seem to show up). > ...or on ZFS: > > # zpool iostat 1 > > capacity operations bandwidth > pool used avail read write read write > ---------- ----- ----- ----- ----- ----- ----- > storage 1.39T 440G 0 771 0 96.4M > storage 1.39T 440G 0 1.05K 4.42K 126M -- Dan Nelson dnelson@allantgroup.com