<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>Our database server
is getting some very high response times and I´m trying to understand if the
disk configuration is responsible for this issue.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>It is a Fedora Core
release 4 (Stentz) box with 4 GB RAM and 2 GenuineIntel XEON CPU 3.20 GHz Cache:
1024 KB. <BR></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>Some typical iostat
-x data:</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
11,96 0,00 7,04
1,31 79,70</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
30,44 0,81 3,43 14,52
270,97 7,26 135,48
67,43 0,19 46,05
7,29 3,08</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
12,26 0,00 7,34
6,63 73,77</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
32,26 0,00 4,41 0,00
293,39 0,00 146,69
66,55 1,51 342,32 25,14
11,08</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
13,67 0,00 6,83
7,74 71,76</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
31,99 0,00 3,82 0,00
286,52 0,00 143,26
74,95 2,93 767,58 55,84
21,35</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
13,27 0,00 6,83
14,37 65,53</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
31,73 0,00 4,02 0,00
285,94 0,00 142,97
71,20 2,73 680,40 49,25
19,78</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
12,86 0,00 6,33
9,45 71,36</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
30,92 0,00 3,41 0,00
274,70 0,00 137,35
80,47 2,33 681,35 57,53
19,64</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>cpu-moy: %user
%nice %sys %iowait
%idle<BR>
12,45 0,00 6,02
1,91 79,62</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Device: rrqm/s
wrqm/s r/s w/s rsec/s
wsec/s rkB/s wkB/s avgrq-sz
avgqu-sz await svctm
%util<BR>sda 0,00
33,00 0,60 4,23 6,44
297,79 3,22 148,89
63,00 0,41 85,29 20,00
9,66<BR></FONT></DIV></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>Is it
normal have the %util column showing a saturation of 20% with only
140wKB/s?</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007>How can I be sure
if there is a hardware or software raid running over the disks? I think it is
hardware because there is no mdadm process running, am I
right?</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=062241814-08022007></SPAN></FONT><FONT
face=Tahoma size=2><SPAN class=062241814-08022007>Some dmesg
data:</SPAN></FONT></DIV>
<DIV><FONT><SPAN class=062241814-08022007><FONT face=Tahoma size=2>SCSI
subsystem initialized<BR>Fusion MPT base driver 3.01.20<BR>Copyright (c)
1999-2004 LSI Logic Corporation<BR>ACPI: PCI Interrupt 0000:02:04.0[A] -> GSI
42 (level, low) -> IRQ 185<BR>mptbase: Initiating ioc0 bringup<BR>ioc0:
53C1030: Capabilities={Initiator,Target}<BR>Fusion MPT SCSI Host driver
3.01.20<BR>scsi0 : ioc0: LSI53C1030, FwRev=01032300h, Ports=1, MaxQ=255,
IRQ=185<BR>input: AT Translated Set 2 keyboard on isa0060/serio0<BR>input: AT
Translated Set 2 keyboard on isa0060/serio0<BR>megaraid cmm: 2.20.2.5 (Release
Date: Fri Jan 21 00:01:03 EST 2005)<BR>megaraid: 2.20.4.5 (Release Date: Thu Feb
03 12:27:22 EST 2005)<BR>megaraid: probe new device 0x1000:0x1960:0x1028:0x0520:
bus 2:slot 5:func 0<BR>ACPI: PCI Interrupt 0000:02:05.0[A] -> GSI 37 (level,
low) -> IRQ 193<BR>megaraid: fw version:[351S] bios version:[1.10]<BR>scsi1 :
LSI Logic MegaRAID driver<BR>scsi[1]: scanning scsi channel 0 [Phy 0] for
non-raid devices<BR> Vendor: SDR
Model: GEM318P Rev:
1<BR> Type:
Processor
ANSI SCSI revision: 02<BR>scsi[1]: scanning scsi channel 1 [virtual] for logical
drives<BR> Vendor: MegaRAID Model: LD 0 RAID1 69G
Rev: 351S<BR> Type:
Direct-Access
ANSI SCSI revision: 02<BR>SCSI device sda: 143114240 512-byte hdwr sectors
(73274 MB)<BR>sda: asking for cache data failed<BR>sda: assuming drive cache:
write through<BR>SCSI device sda: 143114240 512-byte hdwr sectors (73274
MB)<BR>sda: asking for cache data failed<BR>sda: assuming drive cache: write
through<BR> sda: sda1 sda2 sda3 sda4 < sda5 ><BR>Attached scsi disk
sda at scsi1, channel 1, id 0, lun 0<BR>libata version 1.10 loaded.<BR>ata_piix
version 1.03<BR>ACPI: PCI Interrupt 0000:00:1f.2[A] -> GSI 18 (level, low)
-> IRQ 177<BR>PCI: Setting latency timer of device 0000:00:1f.2 to
64<BR>ata1: SATA max UDMA/133 cmd 0xBC98 ctl 0xBC92 bmdma 0xBC60 irq
177<BR>ata2: SATA max UDMA/133 cmd 0xBC80 ctl 0xBC7A bmdma 0xBC68 irq
177<BR>ata1: SATA port has no device.<BR>scsi2 : ata_piix<BR>ata2: SATA port has
no device.<BR>scsi3 : ata_piix<BR>isa bounce pool size: 16 pages<BR>kjournald
starting. Commit interval 5 seconds<BR>EXT3-fs: mounted filesystem with
ordered data mode.<BR>SELinux: Disabled at runtime.<BR>SELinux:
Unregistering netfilter hooks<BR>cfq: depth 4 reached, tagging now
on<BR>Attached scsi generic sg0 at scsi1, channel 0, id 6, lun 0, type
3<BR>Attached scsi generic sg1 at scsi1, channel 1, id 0, lun 0, type
0<BR>Floppy drive(s): fd0 is 1.44M<BR></FONT></DIV>
<DIV><SPAN class=062241814-08022007></SPAN><FONT face=Tahoma size=2>T<SPAN
class=062241814-08022007>hank you in advance!</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=062241814-08022007></SPAN> </DIV></FONT></SPAN></FONT>
<DIV><FONT face=Tahoma size=2>Reimer<BR></FONT></DIV></BODY></HTML>