Re: question about monitoring restore performance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

floyd@fwellers.com - 27 Jun 2007 15:42 GMT

An onstat -g iov shows the inverted pyramid. But aren't these io's per second really low ? Does this indicate a bottleneck somewhere ?

class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 s 38.4 193890 53 193837 0 479123 0.4 0
kio 1 i 50.6 255670 7 255663 0 642746 0.4 0
kio 2 i 5.5 27535 0 27535 0 86517 0.3 0
kio 3 i 2.5 12730 0 12730 0 34760 0.4 0
kio 4 i 0.9 4690 0 4690 0 12548 0.4 0
kio 5 i 2.8 14042 0 14042 0 44586 0.3 0
msc 0 i 0.0 11 0 0 0 10 1.1 0
aio 0 i 0.1 623 34 2 0 624 1.0 0
aio 1 i 0.0 1 0 0 0 1 1.0 0
aio 2 i 0.0 1 0 0 0 1 1.0 0
aio 3 i 0.0 1 0 0 0 1 1.0 0
aio 4 i 0.0 1 0 0 0 1 1.0 0
aio 5 i 0.0 0 0 0 0 1 0.0 0
pio 0 i 0.0 0 0 0 0 1 0.0 0
lio 0 i 0.0 0 0 0 0 1 0.0 0

-----Original Message-----
From: Superboer [mailto:superboer7@t-online.de]
Sent: Wednesday, June 27, 2007 10:26 AM
To: informix-list@iiug.org
Subject: Re: question about monitoring restore performance

onstat -Dr will tell you how much is being written or one of the
onstats -g ioa

Superboer.

On 27 jun, 16:06, f...@fwellers.com wrote:

> Hi,
> Running IDS10.0.FC5 on Aix5.3, P570 server with FastT900 San and Tivoli 5.3.3.
> Backed up terabyte database with onbar.
> Restoring to different server.
>
> Lately, the restore is taking an extraordinary amount of time, in the order of 48 hours. Only takes about 4 hours to back it up.
> Tivoli support has been little help.
> I notice running Sar on the restore box, that the cpu is hardly taxed, and the Io doesn't appear to be bogged either.
>
> Just seeking advice on which onstats to use to help determine if Informix should have more resources assigned to help restore go faster, or at least to help determine if Informix is the bottleneck for this restore.
>
> Thanks,
> Floyd
>
> ========================
> email: f...@fwellers.com
> Home: 703-430-0805
> Cell: 703-477-6045
> ========================
>
> www.one.orgwww.myspace.com/onepriority

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message

Superboer - 28 Jun 2007 20:22 GMT

Hello Floyd,

these numbers do not seems to be much...

onstat -D -r 60 will give you the writes on a chunk.
so you can calculate how much it does and see if your disks are fully
occupied or not.

However:

> kio 1 i 50.6 255670 7 255663 0 642746 0.4 0

Best case:
50*(16 pages ) = 3.2 MB /sec writing.

i have seen disks do much better then that!!!!

> > Lately, the restore is taking an extraordinary amount of time, in the order of 48 hours. Only takes about 4 hours to back it up.

that is really crap.!!!!! have your machine checked, i had a simular
thing a broken controler made the machine
perform worse then a floppy disk unfortunatly the aix folks decided to
upgrade firmware etc
instead of replacing that controler... the problems were gone when
they received a kick in the a.s
and the did replace the controler

Superboer.

BTW aix: have a look at topas it will tell you how busy your disks
are.

On 27 jun, 16:42, f...@fwellers.com wrote:

> An onstat -g iov shows the inverted pyramid. But aren't these io's per second really low ? Does this indicate a bottleneck somewhere ?
>
[quoted text clipped - 52 lines]
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message