Re: Where is my bottleneck?

Scott Marlowe wrote:

> Well, this might get more traction on the perform list, just fyi.  Admin
> is more generally for questions about adding users, setting permissions
> and such.

   I know and I apologize for the cross-posting, I also sent the same
message to the performance list.

>
> That said, it looks like you're likely I/O bound.
>
> Do you have Hyperthreading turned on?

   yes I have, when I do cat /proc/cpuinfo I get 4 CPUs

>
> What do iostat and vmstat have to say?

here I post the result of iostat 10 -x

asme@SD22-SINER5:/$ iostat 10 -x
Linux 2.4.26-1-686-smp (SD22-SINER5)    01/24/06

avg-cpu:  %user   %nice    %sys %iowait   %idle
           16.03    0.00   94.98    0.00  144.54

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
             89.37  14.15 48.15 95.82    1.30   25.54     0.65    12.77
     0.79     0.00    0.05   0.00   0.00
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     4.26     0.00   48.69  48.63   0.00
scsi/host0/bus1/target0/lun0/part2
              0.01   0.25  0.02  0.22    0.22    3.77     0.11     1.89
    17.12     0.00    6.29   1.80   0.04
scsi/host0/bus1/target0/lun0/part5
              0.02   0.02  0.01  0.00    0.21    0.20     0.10     0.10
    33.85     0.00   58.89  38.02   0.05
scsi/host0/bus1/target0/lun0/part6
              0.05   0.35  0.10  0.47    1.18    6.55     0.59     3.27
    13.58     0.00    2.70   1.64   0.09
scsi/host0/bus1/target0/lun0/part7
              0.06   0.60  0.01  0.03    0.53    5.10     0.27     2.55
   137.26     0.00   38.02  22.68   0.09
scsi/host0/bus1/target0/lun0/part8
              0.14   0.57  0.01  0.03    1.18    4.79     0.59     2.40
   155.70     0.00   12.07  14.63   0.06
scsi/host0/bus1/target0/lun0/part9
             89.09  12.35 48.00 95.07  107.78    5.13    53.89     2.56
     0.09     0.00    0.04   0.02   0.05

avg-cpu:  %user   %nice    %sys %iowait   %idle
           27.35    0.00   16.25    0.00   56.40

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
            420.60 2070.00 87.30 152.10 4060.00 17830.40  2030.00
8915.20    91.44    14.06   57.70   4.16  99.60
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part2
              0.00   0.70  0.00  1.40    0.00   16.80     0.00     8.40
    12.00     0.07   52.14   5.00   0.70
scsi/host0/bus1/target0/lun0/part5
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part6
              0.00   0.40  0.00  0.40    0.00    6.40     0.00     3.20
    16.00     0.02   40.00  40.00   1.60
scsi/host0/bus1/target0/lun0/part7
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part8
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part9
            420.60 2068.90 87.30 150.30 4060.00 17807.20  2030.00
8903.60    92.03    13.97   57.77   4.19  99.60

avg-cpu:  %user   %nice    %sys %iowait   %idle
           31.38    0.00   15.55    0.00   53.08

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s
avgrq-sz avgqu-sz   await  svctm  %util
scsi/host0/bus1/target0/lun0/disc
            388.80 2266.70 219.20 182.00 4876.80 19571.20  2438.40
9785.60    60.94    21.54 1059879.18   2.49  99.80
scsi/host0/bus1/target0/lun0/part1
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part2
              0.00   0.30  0.00  0.40    0.00    5.60     0.00     2.80
    14.00     0.01   17.50  17.50   0.70
scsi/host0/bus1/target0/lun0/part5
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part6
              0.00   0.20  0.00  0.40    0.00    4.80     0.00     2.40
    12.00     0.01   22.50  22.50   0.90
scsi/host0/bus1/target0/lun0/part7
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part8
              0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00
     0.00     0.00    0.00   0.00   0.00
scsi/host0/bus1/target0/lun0/part9
            388.80 2266.20 219.20 181.20 4876.80 19560.80  2438.40
9780.40    61.03    21.52   54.32   2.49  99.80


> Does your RAID 5 have the option for batter backed cache?

   I don't know how to do that, I didn't configure this machine.

> Is your load mostly read, or a mix or read and write?

   On this machine there are about 200 DDBB running on it, the activity
on them is a mix of read/write operations some depending on the tables
of each DB. The size of the DB varies a lot, every day we do a pg_dump
with a compressed format. The biggest one takes 746M, 5 are between 46M
and 13M. 40 between 10M - 1M and the rest their dump takes less than 1M.

Cheers!
--
Arnau