RE: Slowness

Comments embedded. >===== Original Message From Boscia <rwboscia@worldnet.att.net> ===== >Thanks for all the posts. I did make some changes and it seems to have >sped up quite a bit - my developer was out for a few days, so he'll be the >final "judge" - he's the one with the query problems... > > Also one of our tables got error 136 (extents), so I had to "fix" that >problem, so that's why I haven't taken the time to post this additional >information.. But here goes. Now this was taken prior to any changes. > >Thanks again for all the good information. I feel like I've been to a >training class!! > > >Robin > > onstat -F> >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days >17:07:49 -- 491520 Kbytes > > >Fg Writes LRU Writes Chunk Writes >47 5706029 67736088 > >address flusher state data >2504c504 0 I 0 = 0X0 >2504c9f0 1 I 0 = 0X0 >2504cedc 2 I 0 = 0X0 >2504d3c8 3 I 0 = 0X0 > states: Exit Idle Chunk Lru > > >onstat -R> >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days >17:07:59 -- 491520 Kbytes > >4 buffer LRU queue pairs priority levels ># f/m pair total % of length LOW MED_LOW MED_HIGH HIGH > 0 F 49896 94.9% 47359 0 40878 5302 1179 > 1 m 5.1% 2537 0 2536 1 0 > 2 f 49986 95.1% 47517 0 44106 2261 1150 > 3 m 4.9% 2469 0 2467 2 0 > 4 f 49985 95.0% 47484 0 44156 2849 479 > 5 m 5.0% 2501 0 2499 2 0 > 6 f 49962 95.1% 47501 0 41716 4610 1175 > 7 m 4.9% 2461 0 2460 1 0 >9968 dirty, 199829 queued, 200000 total, 262144 hash buckets, 2048 buffer >size >start clean at 60% (of pair total) dirty, or 30000 buffs dirty, stop at 50% >0 priority downgrades, 0 priority upgrades You really, really, really need to up your LRU's to 127 and put your CLEANERS at about the same, it will make a big difference.(this requires you to bounce the system for these changes to take effect You should also probably lower you LRU_MIN_DIRTY and LRU_MAX_DIRTY as has been suggested by other people. Otherwise your checkpoints could be horrendously long. Hope this helps, Will ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------