Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi, I'm facing a problem and i don't understand how is it possible ... I'm
loading (dbimport) a big table (> 3 Million records) and my buffer pool
becomes quickly full (700000 buffers with LRU min = 0.50 and max 1.00).
Checkpoint is not trigger until CKPINTVL (180) and you can image how long is
the checkpoint process (see onstat -h ckp below ...)
Can someone explain me that because on 9.30 i've never seen that ?
Thanks
Benjamin.
177 09:16:12 CKPTINTVL 2:0xa4d3018 320.8 320.7 0.0 1 0.0 0.2 0.2 172117 536
139 0 1352 3
178 09:36:01 CKPTINTVL 2:0xa4e0018 1158.6 1158.5 0.0 1 0.0 0.4 0.4 635589 548
5749 16 18 0
179 09:44:25 *User 2:0xa4e7018 504.3 503.6 0.0 2 0.0 504.2 504.3 699470 1388
6167 5 7 0
180 09:46:11 CKPTINTVL 2:0xa4e9018 77.4 77.2 0.0 1 0.0 0.2 0.2 41105 532 490 0
3 0
181 09:56:23 CKPTINTVL 2:0xa4ed018 492.4 492.3 0.0 1 0.0 0.3 0.3 261851 531
3164 16 6 0
Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked
pages/sec pages/sec Time pages/sec pages/sec Time
200 266 1158 556 313 0
... after reading this forum my problem seems the same as this one ... :
Disabling LRU flush (views: 22)
Cesar Inacio Martins -- Saturday, 29 September 2012, at 9:25 a.m.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.