On Fri, 28 Mar 2003, Kelsey Hartigan Go wrote: > Hmmm....why is it? > I know the reason for having it's own partition is that Unix normally > have this read ahead feature on its file system, thereby slowing > down DBMS access, if the database is on the file system. > Nowadays, I think you can disable that read ahead feature. Is this normally > the case?
Yes. Well, what i observed in some other companies. Going for raw partition for database is dying down. For example, Solaris/Oracle is usually paired in big companies. Starting with Solaris 8 MU 3, it has a feature called Concurrent Direct I/O. It is similar to VXFS Direct I/O. It is so good that it approaches 90% speed performance compared to a raw partition. Reducing the no. of inodes, increase cylinders per group, etc. on a partition will help too. So there you go... I don't see why you need raw partitions for database stuff. regards, --- Andre M. Varon, SCSA http://andre.lasaltech.com _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
