Res: Res: long checkpoints on informix

Another link, very useful : Checkpoint tuning: how to find the bottlenecks in the checkpoint duration time http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSHPYE&q1=checkpoint+tuNing&uid=swg21250841&loc=en_US&cs=utf-8〈=en ----- Mensagem original ---- De: Nicolas Garimaldi <Sakura.ggxx@gmail.com> Para: informix-list@iiug.org Enviadas: Sexta-feira, 20 de Julho de 2007 17:24:15 Assunto: Re: Res: long checkpoints on informix well i use your script and this is the result, is little hard to understand 20/07/2007 17:07 125ba15c8 108 L 183 = 0Xb7 LRU-183 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125ba15c8 108 L 183 = 0Xb7 LRU-183 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007