Re: Long checkpoint woe

Obnoxio The Clown" <obnoxio@xxxxxxxxxxxxxxx> wrote in message
news:mailman.201.1143584365.18205.informix-list@xxxxxxxxxxx

Neil Truby said:
You are at least a factor of 100 out in performance -and this is a
laptop - call Sun?

That's different though - these are file syste files. On the Sun:

# time dd if=/dev/zero of=/scratch/test bs=2k count=10240
10240+0 records in
10240+0 records out

real 0m0.31s
user 0m0.01s
sys 0m0.24s
# dd if=/scratch/test of=/dev/null bs=2k
10240+0 records in
10240+0 records out

real 0m0.51s
user 0m0.00s
sys 0m0.19s

So you're saying that cooked file access is faster than raw disk access?
And you still think the problem is in Informix?

Actually, deep down, I do. This config restoes an 80g database in about
20-25m - pretty good I think. It's the long checkpoints that are the worry.


.

Relevant Pages

  • Re: Long checkpoint woe
    ... If they are the same then it is a real problem with the disks. ... That's different though - these are file syste files. ... On the Sun: ... sys 0m0.24s ...
    (comp.databases.informix)
  • Re: multicore-multithreading benchmarks
    ... TRYSORTN was the only process reported by top ... machine with four x86_64s cores (AMD Opterons) which in many ... If we divide the Sun Niagara T1000's numbers in ... sys 0m0.096s ...
    (comp.lang.ada)