Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 20 Nov 2002 18:43:10 -0500 (EST)
From:      Duncan Sterling <buffalo@radix.net>
To:        "Justin T. Gibbs" <gibbs@scsiguy.com>
Cc:        aic7xxx@FreeBSD.ORG
Subject:   Re: AIC-7892, RH Linux 7.3 Problems (Update)
Message-ID:  <Pine.GSO.4.43.0211201840090.14868-100000@saltmine.radix.net>
In-Reply-To: <1690020000.1037741230@aslan.btc.adaptec.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, 19 Nov 2002, Justin T. Gibbs wrote:

Justin,

First off, thanks for your reply.

> 1) Can you more fully describe the types of performance differences you
>    see, how you measure these differences, and perhaps a simple benchmark
>    that I could use to recreate what you are seeing?

Actually, the specific case causing us the problem is large SQL (MySQL)
queries from a database, where aproximately 20k records are pulled.

Using identical version of MySQL and identical copies of the database, the
20k queries will run in about 8 minutes and change on an RH 7.1 box with
the older version (5.2.x) of the AIC7xxx driver, but it takes 14 minutes
and change on the RH 7.3 box running 6.2 x version of the driver, all
hardware being equal.

Not sure how easy this would be for you to reproduce, unfortunately.

> 2) Can you provide a dmesg from you system, preferably with
>    aic7xxx=verbose?

SCSI subsystem driver Revision: 1.00
kmod: failed to exec /sbin/modprobe -s -k scsi_hostadapter, errno = 2
scsi0 : Adaptec AIC7XXX EISA/VLB/PCI SCSI HBA DRIVER, Rev 6.2.8
        <Adaptec 29160 Ultra160 SCSI adapter>
        aic7892: Ultra160 Wide Channel A, SCSI Id=7, 32/253 SCBs

blk: queue c251bc18, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 010A
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue c251b818, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 0109
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue c251b618, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 010A
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue dfd31218, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 010A
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue dfd17e18, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 010A
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue dfd17a18, I/O limit 4095Mb (mask 0xffffffff)
  Vendor: SEAGATE   Model: ST318406LW        Rev: 010A
  Type:   Direct-Access                      ANSI SCSI revision: 03
blk: queue dfd17618, I/O limit 4095Mb (mask 0xffffffff)
scsi0:A:0:0: Tagged Queuing enabled.  Depth 253
scsi0:A:1:0: Tagged Queuing enabled.  Depth 253
scsi0:A:8:0: Tagged Queuing enabled.  Depth 253
scsi0:A:9:0: Tagged Queuing enabled.  Depth 253
scsi0:A:10:0: Tagged Queuing enabled.  Depth 253
scsi0:A:11:0: Tagged Queuing enabled.  Depth 253
Attached scsi disk sda at scsi0, channel 0, id 0, lun 0
Attached scsi disk sdb at scsi0, channel 0, id 1, lun 0
Attached scsi disk sdc at scsi0, channel 0, id 8, lun 0
Attached scsi disk sdd at scsi0, channel 0, id 9, lun 0
Attached scsi disk sde at scsi0, channel 0, id 10, lun 0
Attached scsi disk sdf at scsi0, channel 0, id 11, lun 0
(scsi0:A:0): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sda: 35843670 512-byte hdwr sectors (18352 MB)
Partition check:
 sda: sda1 sda2 < sda5 sda6 >
(scsi0:A:1): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sdb: 35843670 512-byte hdwr sectors (18352 MB)
 sdb: sdb1
(scsi0:A:8): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sdc: 35843670 512-byte hdwr sectors (18352 MB)
 sdc: sdc1
(scsi0:A:9): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sdd: 35843670 512-byte hdwr sectors (18352 MB)
 sdd: sdd1
(scsi0:A:10): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sde: 35843670 512-byte hdwr sectors (18352 MB)
 sde: sde1
(scsi0:A:11): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
SCSI device sdf: 35843670 512-byte hdwr sectors (18352 MB)
 sdf: sdf1

> 3) If you aic7xxx_old under 7.3, does the performance change.  If so,
>    in what ways?

Actually, I'm trying that out ASAP (hopefully within the next day) and
will report back with results.

> 4) Are your devices negotiating to the same speeds?  Catting
>    /proc/scsi/aic7xxx/# (<= replace '#' with scsi bus number)
>    should provide this information.

cat /proc/scsi/aic7xxxx/0:

Adaptec AIC7xxx driver version: 6.2.8
aic7892: Ultra160 Wide Channel A, SCSI Id=7, 32/253 SCBs

Serial EEPROM:
0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a
0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a 0xc33a
0x08f4 0x7c59 0x2807 0x0010 0x0300 0xffff 0xffff 0xffff
0xffff 0xffff 0xffff 0xffff 0xffff 0xffff 0x0250 0xe64b

Channel A Target 0 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
        Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 0 Lun 0 Settings
                Commands Queued 949303
                Commands Active 0
                Command Openings 50
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 1 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
        Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 1 Lun 0 Settings
                Commands Queued 3660
                Commands Active 0
                Command Openings 49
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 2 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 3 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 4 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 5 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 6 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 7 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 8 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
 Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 8 Lun 0 Settings
                Commands Queued 97995
                Commands Active 0
                Command Openings 50
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 9 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
        Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 9 Lun 0 Settings
                Commands Queued 68134
                Commands Active 0
                Command Openings 49
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 10 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
        Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 10 Lun 0 Settings
                Commands Queued 94310
                Commands Active 0
                Command Openings 49
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 11 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
        Goal: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Curr: 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit)
        Channel A Target 11 Lun 0 Settings
                Commands Queued 9
                Commands Active 0
                Command Openings 253
                Max Tagged Openings 253
                Device Queue Frozen Count 0
Channel A Target 12 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 13 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 14 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)
Channel A Target 15 Negotiation Settings
        User: 160.000MB/s transfers (80.000MHz DT, offset 255, 16bit)


> 5) Do you see different performance if you upgrade to the latest
>    version of the aic7xxx driver.  A tarfile relative to recent 2.4.X
>    kernels for this driver can be found here:

I've tried 6.2.5 through 6.2.8 so far with no noticeable change...

Many thanks for your help,

--Duncan


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe aic7xxx" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.43.0211201840090.14868-100000>