Dec 13

Read ahead can cause performance hit on busy database

Linux No comments »
Linux Disk read-ahead can cause some performance hit on OLTP and busy database servers. So I found article on IBM DeveloperWorks about tuning hardware and kernel to turn off read-ahead to gain more transaction per seconds of the database server.

If your database disks have read-ahead enable, It good to turn off especially database that require very very high random-read on busy servers.

Posted by SF-Alpha

Defined tags for this entry:

0 Trackbacks

Trackback specific URI for this entry
  1. No Trackbacks

0 Comments

Display comments as(Linear | Threaded)
  1. No comments

Add Comment


Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA