Re: 1.6 billion lockreqs
Posted in 2005
Art S. Kagel — — source: Usenet: comp.databases.informix
Geezer From The Freezer wrote: So you're using COOKED files for chunks and all of your chunks live on the same single spindle. And you wonder were the bottleneck is? I think you found it and it's not locks. Art S. Kagel > "Simmons, Keith" wrote: > >>Geezer >> >>I currently have 2.6 billon lock reqs with 0 ovlocks and >>1080 lock waits in 3 1/2 days. Ssytem is running fine with >>250,000 locks in config file. Sugest you lok elsewhere for >>your performance problems. >>Disk layout, type ? >> >>Keith > > > hmmm good point, the disk layout is pretty basic - 1 internal disk only and > using large empty files > for dbspaces. BUT I am doing this on another system (a lot older system) and > that runs much better.