1) What is recommended block size needs to be configured in a disk array?
2) How to tune the block size parameter in Informix IDS 11.0?
Pinned topic Recommended Block Size On Disk Array
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-08-08T14:41:55Z at 2009-08-08T14:41:55Z by musthalie
dkremen 120000ET2D7 Posts
Re: Recommended Block Size On Disk Array2008-11-10T17:18:00ZThis is the accepted answer. This is the accepted answer.
- dkremen 120000ET2D
In general, you want to spread your load as evenly as possible.
Use as many disks as you can (you don't mention if these are internal disks, SAN maybe, ...). Preferably in RAID10. Block size should not be too small, otherwise you can generate too much IO request during peak times. Consider that today's disk are supposed to max out around 200 to 300 IO requests per second.
This is a bit vague topic (at least for me). What I've learned thus far (and I might be completely wrong, all corrections welcome) is Informix will read/write either in one page (2K/4K, depending on OS) or in 8 pages (big buffers).
Next, it depends if you're on file system or raw. File system implementation might decide to merge some blocks so you may end up with bigger IO block sizes. On raw it should stay 1pg/8pg.
Also, you have to decide for what you're optimising: everyday or peak time. We do the latter so we set block size to 8 pages on our SAN disk volumes. It's a trade-off: we are (probably) wasting 7 pages out of every 8 during normal load, but during high load we are not generating excessive number of IOs.
Hopefully someone else will also help to demystify this...
musthalie 270001R7J63 Posts
IDS 11.5 Vs Oracle RAC2009-08-08T14:41:55ZThis is the accepted answer. This is the accepted answer.
- dkremen 120000ET2D
In IDS 11.5 "All types of secondary servers can be configured to perform write operations" it looks like not similar to Oracel RAC (comparing with ASM etc.)! Any one who have experience in 11.5 cluster Active/Active configuration?