RE: Sleeping scan threads

Posted in 1999

Tallent, Phil — Fri, 28 May 1999 09:06:03 -0400 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BEA907.5108B846 Content-Type: text/plain; charset="iso-8859-1" There is a new patch out from HP you might want to try; I do not recall the number. There is a mean bug in LVM that makes performance drop by about 60%;I received this info from Informix. We do not use KAIO but I believe it applies to both. On large batch jobs there were no bottle necks but the jobs would take forever to complete. Our V seems to be cranking it out now since the patch was applied. We have a V2250: 16 gig of ram; 12 CPU's; 4 gig for Informix; EMC drives. It is tuned for SAP. Thanks Phil Tallent SAP Administration Informix DBA (423)-510-7701 FAX (423) 510-7895 email: phil.tallent@brachs.com <mailto:phil.tallent@brachs.com> -----Original Message----- From: Chuck Renaud [mailto:cjrenaud@sinnfree.org] Sent: Thursday, May 27, 1999 3:11 PM To: informix-list@iiug.org Subject: Sleeping scan threads Hello, Looking for some general reasons on what would cause scan threads to sleep for lengthy amounts of time when there's no bottleneck on disk, memory or CPU. HP V2250, IDS 7.30.FC3, HP-UX 11, 5 CPUs, 8GB RAM (5 allocated to IDS), RAID-5 devices that are allegedly well-tuned for read operations. Engine is tuned for DSS, tables are fragmented by expression (both elimination and parallelism are being achieved), KAIO is enabled, light scans are occurring, processor affinity is enabled for all CPUs, no indexes/all sequential scans. TIA, Chuck ------_=_NextPart_001_01BEA907.5108B846 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Sleeping scan threads</TITLE> </HEAD> <BODY> <UL><UL> There is a new patch out from HP you might want = to try; I do not recall the number. There is a mean bug in LVM that = makes performance drop by about 60%;I received this info from Informix. = We do not use KAIO but I believe it applies to both. On large batch = jobs there were no bottle necks but the jobs would take forever to = complete. Our V seems to be cranking it out now  since the patch = was applied. We have a V2250: 16 gig of ram; 12 CPU's; 4 gig for = Informix; EMC drives. It is tuned for SAP.    = Thanks Phil Tallent SAP = Administration Informix DBA (423)-510-7701 FAX (423) = 510-7895 email: = <A HREF=3D"mailto:phil.tallent@brachs.com">phil.tallent@brachs.com</A> <UL><UL><UL><UL> <A NAME=3D"_MailData">-----Original = Message-----</A> From:   Chuck = Renaud [<A = HREF=3D"mailto:cjrenaud@sinnfree.org">mailto:cjrenaud@sinnfree.org</A>]<= /FONT> Sent:   Thursday, May 27, 1999 3:11 PM To:     informix-list@iiug.org Subject:       = Sleeping scan = threads Hello, Looking for some general reasons on what would = cause scan threads to sleep for lengthy amounts of time = when there's no bottleneck on disk, memory or CPU. HP V2250, IDS 7.30.FC3, HP-UX 11, 5 CPUs, 8GB = RAM (5 allocated to IDS), RAID-5 devices that are = allegedly well-tuned for read operations.  Engine is tuned for = DSS, tables are fragmented by expression (both elimination and = parallelism are being achieved), KAIO is enabled, light scans are = occurring, processor affinity is enabled for all CPUs, no = indexes/all sequential scans. TIA, Chuck </UL></UL></UL></UL></UL></UL> </BODY> </HTML> ------_=_NextPart_001_01BEA907.5108B846--

RE: Sleeping scan threads

Related threads

Your privacy choices