dbTalk Databases Forums  

When is read-ahead used?

comp.databases.informix comp.databases.informix


Discuss When is read-ahead used? in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
red_valsen
 
Posts: n/a

Default When is read-ahead used? - 11-28-2011 , 07:33 AM






We're testing IDS 11.70.FC3 on RHEL5.7/2.6.18 for a data warehouse
application, and had to turn read-ahead off due to the instance-
crashing bug related to RA. But now the project is reporting that
their ETL routine has doubled in duration. However, release FC4 fixes
the RA bug. Does Informix use read-ahead for inserts? If so, an
upgrade may fix the reported performance problem, too.

Reply With Quote
  #2  
Old   
LIGHT SCANS
 
Posts: n/a

Default Re: When is read-ahead used? - 12-05-2011 , 04:54 PM






RA (Read Ahead) is primarily for reading ahead if you are doing
scans. You probably have some other issue(s) slowing down your
inserts. Follow the bytes from source to destination: Are the
reading disks slow? The network slow? The writing disks slow? Etc.
Anything different from the way you did it on the old system? Try
running "vmstat" or "sar" during the slow inserts to see if anything
is bad (IO waits, swapping, etc). Lastly, look at ONCONFIG.

-LS

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.