Thanks! NFS server and MySQL Server are running on the same computer. Got this line from "top" program during a benchmark: *Cpu(s): 32.2%us, 7.2%sy, 0.0%ni, 28.6%id, 30.1%wa, 0.6%hi, 1.3%si, 0.0%st*
does processes in wait "mode" are waiting for NIC, disk i/o or both? When fenxi tries to use iostat data (from the mentioned server) it presents an error: * Overall System Activity (per second)* *org.apache.derby.impl.jdbc.EmbedSQLException: Column 'RPS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'RPS' is not a column in the target table. org.apache.derby.impl.jdbc.Util:-1:in `generateCsSQLException' org.apache.derby.impl.jdbc.TransactionResourceImpl:-1:in `wrapInSQLException' org.apache.derby.impl.jdbc.TransactionResourceImpl:-1:in `handleException' org.apache.derby.impl.jdbc.EmbedConnection:-1:in `handleException' org.apache.derby.impl.jdbc.ConnectionChild:-1:in `handleException' org.apache.derby.impl.jdbc.EmbedStatement:-1:in `execute' * Here is a piece of raw data: *Linux 2.6.32-3-686 (trivor) 06/11/2010 _i686_ (2 CPU) Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util 08:21:59 sda 0.11 157.20 1.48 161.78 31.55 2551.84 15.82 0.29 1.76 0.60 9.82 Filesystem: rBlk_nor/s wBlk_nor/s rBlk_dir/s wBlk_dir/s rBlk_svr/s wBlk_svr/s ops/s rops/s wops/s Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util 08:22:09 sda 0.00 17.60 2.80 5.30 80.00 183.20 32.49 0.03 3.70 2.81 2.28 Filesystem: rBlk_nor/s wBlk_nor/s rBlk_dir/s wBlk_dir/s rBlk_svr/s wBlk_svr/s ops/s rops/s wops/s Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util 08:22:19 sda 0.00 140.60 1.30 74.70 20.80 1722.40 22.94 0.11 1.40 0.34 2.60 Filesystem: rBlk_nor/s wBlk_nor/s rBlk_dir/s wBlk_dir/s rBlk_svr/s wBlk_svr/s ops/s rops/s wops/s* -- Bruno Guimarães Sousa www.ifba.edu.br PONTONET - DGTI - IFBA Ciência da Computação UFBA Registered Linux user #465914 On Fri, Jun 11, 2010 at 9:44 PM, Mingfan Lu <[email protected]> wrote: > using iostat -x in linux > > 2010/6/12 Bruno Guimarães Sousa <[email protected]> > > Hi, >> How can I measure disk usage? Cpu, memory, NIC usage are not at 100% and >> no matter how much concurrent users is increased, the ops/sec stays the >> same. >> >> regards, >> -- >> Bruno Guimarães Sousa >> www.ifba.edu.br >> PONTONET - DGTI - IFBA >> Ciência da Computação UFBA >> Registered Linux user #465914 >> > >
