Re: System tuning
Posted in 1996
On 25 Mar 1996, Saeed Talebbeik wrote:
> The person who replied to your article is right on the money. You CAN
> NOT increase the buffer variable and expect the I/O performance go up.
This depends on wheter we were low on mem or not. System stats showed
that we weren't swapping.
> If the system is running out of memory becuase your database is now
> taking more memory space it will cause paging and process swapping and
> cause the performance to go down.
This I would expect to show quite drastically, if it were the case.
> As far as all the time going to CPU VP's please check the following:
> 1) Are you running exactly the same application as before ?
Same application suite. No changes in code.
> 2) use "vmstat 5 500" command to make sure that your application is not
> causing an infinte loop in the CPU vp's.
Don't have a vmstat in our brand of *NIX. What is it that this utility does?
> For understanding what is some of the parctical uses of onstat utility
> outputs please chack out the following book:
> Informix Online performance tuning
> By Elizabeth Suto
> Prentice hall/Informix press
> ISBN 0-13-124322-5
Thanks. I'll have to have a look at this.
B.
-------------------------------------------------------------------------
|Brian P. Hampson Internet : brian@asl-labs.bc.ca |
|System Administrator, Air(2m/70cm): VE7NNW |
|Analytical Service Labs Fidonet : Brian Hampson 1:153/733|
|Vancouver, BC |
|+604-253-4188 |
| Specialists in Environmental Chemistry |
| |
------------------http://www.asl-labs.bc.ca/-----------------------------