vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > > > > Currently I'm restoring a Informix database. The data is spread across > > multiple disks (SSA), and under normal load 3 disks would be active with > > tm_acct > 90 and iowait between 50 -75%. > > Hm, restoring a database is a very untypical workload. There is often a bottleneck in the redo-logs, if your logvolume is on the same physical disk as your redo logs. Try raising the buffers for redologs. Take a look at the logfiles of the database. When a database switches from one redo log to the next, all open transactions must be written to disk. During import this can occur every few seconds, under usual workload few times a day. (sorry I'm not familar with the correct terms of Informix). --- Uli |