tag:blogger.com,1999:blog-755542794415995865.post7836508378410149585..comments2023-09-23T07:13:10.004-07:00Comments on DB Optimizer: NFS and IO testing : Bonnie++Kyle Haileyhttp://www.blogger.com/profile/13586511268045480856noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-755542794415995865.post-38202836121488796372010-11-26T08:26:31.788-08:002010-11-26T08:26:31.788-08:00Eric, thanks for the pointer. Look forward to tryi...Eric, thanks for the pointer. Look forward to trying fio out. <br />Best<br />KyleKyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-49878446645062242872010-11-24T04:43:11.794-08:002010-11-24T04:43:11.794-08:00good morning Kyle and all readers,
I have been usi...good morning Kyle and all readers,<br />I have been using the fio (http://freshmeat.net/projects/fio/) tool with pleasure. It enables to have direct IO, async IO, traces of IO time... quite flexible.<br />I have to say that I have used it exclusively on Linux (but the README file mentions AIX so maybe it works as well, I do not have an AIX box to test).<br />cheers,<br />EricEricGrancherhttps://www.blogger.com/profile/15220532424242944256noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-2404666948912637562010-11-23T15:07:32.228-08:002010-11-23T15:07:32.228-08:00Did get ORION working. Looks like Orion, as well a...Did get ORION working. Looks like Orion, as well as Oracle, require an entry in /etc/filesystems. For example I added<br /><br />/kyle:<br /> dev = /kyle<br /> vfs = nfs<br /> mount = true<br /> options = rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600<br /> account = false<br /><br />and now Orion works.<br />Will do some testing ...Kyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-21607936146338939952010-11-23T14:17:30.300-08:002010-11-23T14:17:30.300-08:00ORION is somewhat picky on NFS. I did manage to ru...ORION is somewhat picky on NFS. I did manage to run it on NFS but I remember I had to play with strace for a while to get to the bottom of it. I think it was issue with ASYNC IO settings.<br /><br />Btw, it still didn't work on NFS with ASYNC IO on RHEL 4. Even though IOs were done via async syscall, based on strace I concluded that there was serialization somewhere and ORION couldn't schedule multiple concurrent IOs.Alex Gorbachevhttps://www.blogger.com/profile/03862972144277237798noreply@blogger.com