Informix disk performance problems with archives
Hello,
We recently started running some databases on a Red Hat 6.1 system
running IDS 9.21 and I have noticed some performance problems.
When performing backups (using ontape) or initializing dbspaces, the
system slows to a crawl -- literally. It is impossible to login, list
directories or do much of anything with the server until the archive or
initialization is complete. Has anyone else out there noticed this
phenomenon?
The system is a Dell Poweredge 1300 with a (pain-in-the-rear) PERC2
raid controller. The databases are cooked files on a pair of hardware-
mirrored disks.
Does anyone out there have any thoughts about this???
Brian Duffy
Database Administrator
ReserveAmerica
bduffy@reserveamerica.com
Sent via Deja.com http://www.deja.com/
Before you buy.
> When performing backups (using ontape) or initializing dbspaces, the
> system slows to a crawl -- literally.
Well, not literally.
Sorry, I don't have much insight to your actual query, except to point out
the obvious, that archives and dbspace init are both highly i/o intensive
activities that don't use any cacheing whatever.
In article <910upp$gb7$1@taliesin2.netcom.net.uk>,
"Neil Truby" <ntruby@netcomuk.co.uk> wrote:
> > When performing backups (using ontape) or initializing dbspaces, the
> > system slows to a crawl -- literally.
> Well, not literally.
>
> Sorry, I don't have much insight to your actual query, except to
point out
> the obvious, that archives and dbspace init are both highly i/o
intensive
> activities that don't use any cacheing whatever.
>
>
I realize the archives and dbspace inits are very intensive activities.
But this machine slows down to the point that it takes 2-3 minutes to
authenticate a password when log in! ls takes like 30 seconds to list a
directory! I've run test databases on 150 mhz ultra 1's without
anything like this happening.
Sent via Deja.com http://www.deja.com/
Before you buy.