Disk Layout recommendation
Posted in 2003
We have a small ~4GB database and are switching machines and I thought this would be a good time to reorganize the disk layout I inherited. If anyone would like to give me recommendations, I'd appreciate it. Our current informix dbspace looks like the following. These are symlinks to the actual dev files. 77218 1 1 0 204800 103697 PO- /opt/informix/dev/root.1 772f8 1 1 0 204800 0 MO- /opt/informix/dev/root.1-m 77cd8 2 2 0 655360 732 PO- /opt/informix/dev/dbs0.1 78598 2 2 0 655360 0 MO- /opt/informix/dev/dbs0.1-m 77db8 3 3 0 153600 152823 PO- /opt/informix/dev/temp1.1 77e98 4 4 0 153600 152639 PO- /opt/informix/dev/temp2.1 77f78 5 5 0 524288 8235 PO- /opt/informix/dev/logs.1 78678 5 5 0 524288 0 MO- /opt/informix/dev/logs.1-m 78058 6 2 0 655360 743 PO- /opt/informix/dev/dbs0.2 78758 6 2 0 655360 0 MO- /opt/informix/dev/dbs0.2-m 78138 7 2 0 655360 18671 PO- /opt/informix/dev/dbs0.3 78838 7 2 0 655360 0 MO- /opt/informix/dev/dbs0.3-m 78218 8 2 0 655360 513972 PO- /opt/informix/dev/dbs0.4 78918 8 2 0 655360 0 MO- /opt/informix/dev/dbs0.4-m root.1 is on one disk, temp1.1 and logs.1 on a second, and the dbs0.x spaces are striped across those same pair. The xxx-m (informix mirror spaces) and temp2.1 have the same layout on a second pair of disks. (4 disks total) The new machine has 6 4GB disks that can be used for dbspaces. One thing I thought I'd do is use 2GB dbspaces for the dbs0.x instead of 1.25GB and allocate a total of 6GB. I'm open to any suggestions. Thanks.