Oninit cdi / Archive
Talk to an expert →

Help - % Cached

Posted in 2011

Topics: Stored Procedures & SPL

Javier Gray Benítez — — source: IIUG Forums & Mailing Lists

Good morning list, I have the next problems, in my IDS instance, when execute onstat -p, my IDS display the next screen, but this situation is only sometimes, the normal is Read %cached over 90%, and Write % Cached same too, please helpme. Thanks for your time. IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- *Up 16 days 00:25:37* -- 2550736 Kbytes Profile dskreads pagreads bufreads *%cached* dskwrits pagwrits bufwrits *%cached* 839890671 915236864 76834991* 0.00 * 33636588 83381642 326714562 *89.70* isamtot open start read write rewrite delete commit rollbk 2564299913 68279833 877861952 3984293401 55198139 1884765 27675614 28019819 336 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 162857.39 9669.60 2723 11606 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 35534254 743 2619746574 32 0 934 17352342 92459570 ixda-RA idx-RA da-RA RA-pgsused lchwaits 41574584 18300460 617318584 676477371 516582 Regards,, Javier Gray Benítez Cell Phone: (595-981) 467505 Asunción, Paraguay --00163646da78abb198049b24e564

↪ replying to Javier Gray Benítez
Art Kagel — — source: IIUG Forums & Mailing Lists

In 9.40 the internal counters for the data in the onstat -p report were 32bit integers, so they can wrap creating odd cache calculations. Just reset the stats with 'onstat -z' periodically. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 2011/1/31 Javier Gray Benítez <jgray@graytechnology.net> > Good morning list, > > I have the next problems, in my IDS instance, when execute onstat -p, my > IDS display the next screen, but this situation is only sometimes, the > normal is Read %cached over 90%, and Write % Cached same too, please > helpme. > Thanks for your time. > > IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- *Up 16 days > 00:25:37* -- 2550736 Kbytes> > Profile > dskreads pagreads bufreads *%cached* dskwrits pagwrits bufwrits *%cached* > 839890671 915236864 76834991* 0.00 * 33636588 83381642 326714562 *89.70* > > isamtot open start read write rewrite delete commit > rollbk > 2564299913 68279833 877861952 3984293401 55198139 1884765 27675614 28019819 > 336 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 162857.39 9669.60 2723 11606 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 35534254 743 2619746574 32 0 934 17352342 92459570 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 41574584 18300460 617318584 676477371 516582 > > Regards,, > > Javier Gray Benítez > Cell Phone: (595-981) 467505 > Asunción, Paraguay > > --00163646da78abb198049b24e564 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30334f25ebafb4049b2553ef

↪ replying to Javier Gray Benítez
Lello, Nick — — source: IIUG Forums & Mailing Lists

My guess would be you have something performing a sequential scan of a large table (ie: not using indexes) --- everything else is being pushed out of the read buffers to make room for the table row pages being read. Have you updated statistics recently ? Do you have any tables without any indexes ? 2011/1/31 Javier Gray Benítez <jgray@graytechnology.net> > Good morning list, > > I have the next problems, in my IDS instance, when execute onstat -p, my > IDS display the next screen, but this situation is only sometimes, the > normal is Read %cached over 90%, and Write % Cached same too, please > helpme. > Thanks for your time. > > IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- *Up 16 days > 00:25:37* -- 2550736 Kbytes> > Profile > dskreads pagreads bufreads *%cached* dskwrits pagwrits bufwrits *%cached* > 839890671 915236864 76834991* 0.00 * 33636588 83381642 326714562 *89.70* > > isamtot open start read write rewrite delete commit > rollbk > 2564299913 68279833 877861952 3984293401 55198139 1884765 27675614 28019819 > 336 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 162857.39 9669.60 2723 11606 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 35534254 743 2619746574 32 0 934 17352342 92459570 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 41574584 18300460 617318584 676477371 516582 > > Regards,, > > Javier Gray Benítez > Cell Phone: (595-981) 467505 > Asunción, Paraguay > > --00163646da78abb198049b24e564 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Nick Lello | Web Architect o +44 (0) 8433309374 | m +44 (0) 7917 138319 Email: nick.lello at rentrak.com RENTRAK | www.rentrak.com | NASDAQ: RENT --00163630f663e3036e049b271130

↪ replying to Lello, Nick
Javier Gray Benítez — — source: IIUG Forums & Mailing Lists

Hi Lello, I verify constantly the secuencial scan statistics, my tables use index, but exist some tables using duplicate index, and exits few big table(2), the update statistics run periodicaly. Regards, Javier Gray Benítez Cell Phone: (595-981) 467505 Asunción, Paraguay 2011/1/31 Lello, Nick <nick.lello@rentrakmail.com> > My guess would be you have something performing a sequential scan of a > large > table (ie: not using indexes) --- everything else is being pushed out of > the > read buffers to make room for the table row pages being read. > > Have you updated statistics recently ? > > Do you have any tables without any indexes ? > > 2011/1/31 Javier Gray Benítez <jgray@graytechnology.net> > > > Good morning list, > > > > I have the next problems, in my IDS instance, when execute onstat -p, my > > IDS display the next screen, but this situation is only sometimes, the > > normal is Read %cached over 90%, and Write % Cached same too, please > > helpme. > > Thanks for your time. > > > > IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- *Up 16 days > > 00:25:37* -- 2550736 Kbytes> > > > Profile > > dskreads pagreads bufreads *%cached* dskwrits pagwrits bufwrits *%cached* > > 839890671 915236864 76834991* 0.00 * 33636588 83381642 326714562 *89.70* > > > > isamtot open start read write rewrite delete commit > > rollbk > > 2564299913 68279833 877861952 3984293401 55198139 1884765 27675614 > 28019819 > > 336 > > > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > > 0 0 0 0 0 0 0 > > > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > > 0 0 0 162857.39 9669.60 2723 11606 > > > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > > 35534254 743 2619746574 32 0 934 17352342 92459570 > > > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > > 41574584 18300460 617318584 676477371 516582 > > > > Regards,, > > > > Javier Gray Benítez > > Cell Phone: (595-981) 467505 > > Asunción, Paraguay > > > > --00163646da78abb198049b24e564 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > > Nick Lello | Web Architect > o +44 (0) 8433309374 | m +44 (0) 7917 138319 > Email: nick.lello at rentrak.com > RENTRAK | www.rentrak.com | NASDAQ: RENT > > --00163630f663e3036e049b271130 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016362835246e51f9049b27b1bb

↪ replying to Art Kagel
Javier Gray Benítez — — source: IIUG Forums & Mailing Lists

Excelente Art; I Run onstat-z, and then try onstat-p, magically restored data of %cached and display the real information. Thanks Art and sorry myt english. Regards, Javier Gray Benítez Cell Phone: (595-981) 467505 Asunción, Paraguay 2011/1/31 Art Kagel <art.kagel@gmail.com> > In 9.40 the internal counters for the data in the onstat -p report were > 32bit integers, so they can wrap creating odd cache calculations. Just > reset the stats with 'onstat -z' periodically. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > 2011/1/31 Javier Gray Benítez <jgray@graytechnology.net> > > > Good morning list, > > > > I have the next problems, in my IDS instance, when execute onstat -p, my > > IDS display the next screen, but this situation is only sometimes, the > > normal is Read %cached over 90%, and Write % Cached same too, please > > helpme. > > Thanks for your time. > > > > IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- *Up 16 days > > 00:25:37* -- 2550736 Kbytes> > > > Profile > > dskreads pagreads bufreads *%cached* dskwrits pagwrits bufwrits *%cached* > > 839890671 915236864 76834991* 0.00 * 33636588 83381642 326714562 *89.70* > > > > isamtot open start read write rewrite delete commit > > rollbk > > 2564299913 68279833 877861952 3984293401 55198139 1884765 27675614 > 28019819 > > 336 > > > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > > 0 0 0 0 0 0 0 > > > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > > 0 0 0 162857.39 9669.60 2723 11606 > > > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > > 35534254 743 2619746574 32 0 934 17352342 92459570 > > > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > > 41574584 18300460 617318584 676477371 516582 > > > > Regards,, > > > > Javier Gray Benítez > > Cell Phone: (595-981) 467505 > > Asunción, Paraguay > > > > --00163646da78abb198049b24e564 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --20cf30334f25ebafb4049b2553ef > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163646da78ac263b049b278e55

Related threads

Glossary