Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: BUFFERPOOL

Posted By: Mike Walker
Date: Wednesday, 31 January 2018, at 1:05 p.m.

In Response To: BUFFERPOOL (MUKESH TANUKU)

Buffers should be full - think of them as a cache. What is relevant is how
often queries find what they need in the buffers, versus how often they
require more pages to be brought in from disk, and how often the bufferpool
is turned over.

I would suggest doing a google search for "buffer turnover ratio" for a
calculation that is a rough guide as to whether you need to increase the
size of your bufferpool.

Mike Walker

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH
TANUKU
Sent: Wednesday, January 31, 2018 10:52 AM
To: ids@iiug.org
Subject: BUFFERPOOL [40612]

Hello friends,
Please look into my environment. My buffers are full it looks like.

My onconfig parameter for BUFFERPOOL is

BUFFERPOOL default,memory=auto
BUFFERPOOL size=4K,memory=512000
BUFFERPOOL size=8K,memory=auto

and the output for "onstat -P":

IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 9 days
22:10:45 -- 6755072 Kbytes

Buffer pool page size: 4096
partnum total btree data other dirty
0 9915 0 9906 9 36
1048577 3 0 3 0 3
1048578 2 1 1 0 0
1048580 16 6 10 0 0
1048581 12 7 5 0 0
1048582 3 1 2 0 0
1048583 6 3 3 0 0
1048584 1 1 0 0 0
1048585 3 1 2 0 0
1048590 1 1 0 0 0
1048593 1 1 0 0 0
1048599 1 1 0 0 0
1048600 1 1 0 0 0
1048601 1 1 0 0 0
1048603 1 1 0 0 0
1048604 2 1 1 0 0
1048624 4 2 2 0 0
1048625 3 3 0 0 0
1048694 6 3 3 0 0
1048695 3 2 1 0 0
1048696 2 1 1 0 0
1048697 4 2 2 0 0
1048698 1 1 0 0 0
1048704 2 1 1 0 0
1048707 2 1 1 0 0
1048708 2 1 1 0 0
1048711 6 2 4 0 0
1048713 1 1 0 0 0
1048714 1 1 0 0 0
1048715 1 1 0 0 0
1048718 2 1 1 0 0
1048720 1 1 0 0 0
1048724 1 1 0 0 0
1048738 4 3 1 0 0
1048739 3 3 0 0 0
1048759 2 0 1 1 1
1048760 2 2 0 0 1
1048761 3 3 0 0 1
1048762 2 2 0 0 1
1048766 13 0 12 1 3
1048768 1 1 0 0 0
1048769 1 1 0 0 0
1048770 1 1 0 0 1
1048771 13 0 12 1 7
1048772 3 3 0 0 2
1048773 3 3 0 0 2
1048774 4 4 0 0 3
1048860 4 0 3 1 4
1048864 2 0 2 0 0
1048865 3 3 0 0 0
4194305 44 0 44 0 44
4194306 104 40 63 1 0
4194307 123 41 82 0 0
4194308 172 9 163 0 0
4194309 39 16 23 0 0
4194310 1 1 0 0 0
4194316 100 15 85 0 0
4194317 22 12 10 0 0
4194319 54 10 44 0 0
4194320 13 8 5 0 0
4194323 14 6 7 1 4
4194325 1 1 0 0 0
4194326 1 1 0 0 0
4194327 2 1 1 0 0
4194328 10 3 7 0 0
4194329 10 10 0 0 0
4194330 165 29 136 0 0
4194336 1 1 0 0 0
4194350 217 137 80 0 0
4194351 3 3 0 0 0
4194352 6 3 3 0 0
4194388 19 0 19 0 0
4194527 1 0 1 0 0
4194529 3 0 3 0 0
4194546 1 0 1 0 0
4194593 1 0 1 0 0
4194594 1 1 0 0 0
4194603 1 0 1 0 0
4194604 1 1 0 0 0
4194617 1 0 1 0 0
4194621 1 0 1 0 0
4194629 1 0 1 0 0
4194637 1 0 1 0 0
4194645 1 0 1 0 0
4194646 1 1 0 0 0
4194651 1 0 1 0 0
4194665 1 0 1 0 0
4194666 1 1 0 0 0
4194673 2 0 2 0 0
4194674 3 3 0 0 0
4194696 1 0 1 0 0
4194724 2 0 2 0 0
4194725 2 2 0 0 0
4194736 1 0 1 0 0
4194737 1 1 0 0 0
4194740 3 0 3 0 0
4194741 3 3 0 0 0
4194750 6 0 6 0 0
4194751 4 4 0 0 0
4194784 1 0 1 0 0
4194785 1 1 0 0 0
4194794 1 0 1 0 0
4194795 1 1 0 0 0
4194808 1 0 1 0 0
4194809 3 3 0 0 0
4194850 1 0 1 0 0
4194851 1 1 0 0 0
4194860 1 0 1 0 0
4194861 1 1 0 0 0
4194864 1 0 1 0 0
4194865 1 1 0 0 0
4194872 1 0 1 0 0
4194873 1 1 0 0 0
4194881 10 0 10 0 0
4194883 1 0 1 0 0
4194884 1 1 0 0 0
4194895 2 0 2 0 0
4194896 1 1 0 0 0
4194897 1 0 1 0 0
4194898 1 1 0 0 0
4194907 1 0 1 0 0
4194908 1 1 0 0 0
4194919 1 0 1 0 0
4194920 1 1 0 0 0
4194950 1 0 1 0 0
4194951 1 1 0 0 0
4194970 2 0 2 0 0
4194971 1 1 0 0 0
4194974 1 0 1 0 0
4194975 1 1 0 0 0
4194976 1 0 1 0 0
4194977 1 1 0 0 0
4194988 1 0 1 0 0
4194989 1 1 0 0 0
4194992 3 0 2 1 0
4194999 1 0 1 0 0
4195000 2 2 0 0 0
4195012 1 0 1 0 0
4195013 1 1 0 0 0
4195022 32 0 31 1 0
4195031 1 0 1 0 0
4195032 1 1 0 0 0
4195037 1 0 1 0 0
4195038 1 1 0 0 0
4195067 36 0 35 1 10
4195068 6 6 0 0 1
4195069 2 0 2 0 0
4195070 1 1 0 0 0
4195075 5 0 4 1 0
4195079 42 0 42 0 0
4195095 12 0 12 0 0
4195140 1 0 1 0 0
4195160 10 0 10 0 0
4195166 1 0 1 0 0
4195167 1 1 0 0 0
4195246 2 0 2 0 0
4195371 1 0 1 0 0
4195372 1 1 0 0 0
4195373 1 0 1 0 0
4195377 1 0 1 0 0
4195378 1 1 0 0 0
4195381 2 0 2 0 0
4195382 2 2 0 0 0
4195383 1 0 1 0 0
4195384 1 1 0 0 0
4195393 63 0 62 1 0
4195394 8 8 0 0 0
4195419 1 0 1 0 0
4195421 3 0 3 0 1
4195422 4 4 0 0 1
4195423 175 0 175 0 0
4195425 1062 0 1062 0 1
4195426 2 2 0 0 0
4195437 4 0 4 0 0
4195438 3 3 0 0 0
4195445 14227 0 14224 3 17
4195459 1 0 1 0 0
4195467 79 0 79 0 0
4195468 52 52 0 0 0
4195481 2 0 2 0 0
4195507 388 0 387 1 4
4195508 5 5 0 0 1
4195511 2910 0 2910 0 1
4195512 743 743 0 0 0
4195513 3 0 2 1 3
4195514 3 3 0 0 1
4195534 1 0 1 0 0
4195535 2 2 0 0 0
4195545 2667 0 2666 1 8
4195546 7 7 0 0 0
4195559 13 0 13 0 0
4195560 8 8 0 0 0
4195561 8 0 8 0 0
4195562 5 5 0 0 0
4195564 6 0 6 0 0
4195565 6 6 0 0 0
4195569 1 0 1 0 1
4195570 2 2 0 0 0
4195573 1 1 0 0 0
4195574 2 0 1 1 1
4195575 3 3 0 0 0
4195576 2 0 2 0 0
4195588 1 0 1 0 0
4195589 2 2 0 0 0
4195594 4557 0 4556 1 43
4195595 153 153 0 0 0
4195650 2 0 2 0 0
4195704 5282 0 5281 1 4
4195705 4 4 0 0 1
4195706 1 0 1 0 0
4195707 1 1 0 0 0
4195708 4 0 4 0 0
4195709 1 1 0 0 0
4195725 9 0 9 0 0
4195745 11 0 10 1 0
4195753 9 0 9 0 4
4195804 1 0 1 0 1
4195805 1 1 0 0 1
4195818 1 0 1 0 0
4195819 1 1 0 0 0
4195820 3 0 3 0 0
4195821 1 1 0 0 0
4195822 7505 0 7504 1 4
4195823 3 3 0 0 1
4195833 7 0 6 1 7
4195834 1128 0 1127 1 61
4195835 25 25 0 0 1
4195836 21865 0 21864 1 4
4195837 6 6 0 0 1
4195861 20 0 20 0 1
4195881 5 0 4 1 2
4195882 3 3 0 0 1
4195883 21 0 20 1 4
4195884 7 7 0 0 3
4195885 4 0 4 0 0
4195886 6 6 0 0 0
4195887 2 0 1 1 2
4195888 1 1 0 0 1
4195895 3 0 2 1 3
4195896 1 1 0 0 1
4195901 62 0 62 0 4
4195902 8 8 0 0 0
4195947 43 0 43 0 1
4195948 9 9 0 0 0
4195951 52 0 51 1 1
4195952 58 58 0 0 2
4195959 4077 0 4077 0 3
4195960 8 8 0 0 0
4195970 1 0 1 0 0
4195984 3010 0 3010 0 0
4196004 25 0 24 1 4
4196005 24 23 0 1 7
4196012 1 0 1 0 1
4196013 1 1 0 0 1
4196022 8 8 0 0 0
4196023 3 0 2 1 3
4196024 1 1 0 0 1
4196041 1 0 1 0 0
4196042 1 1 0 0 0
4196059 23 0 23 0 0
4196060 4 4 0 0 0
4196067 13220 0 13219 1 84
4196068 326 324 0 2 4
4196069 43 0 42 1 16
4196070 11 10 0 1 7
4196073 49 0 48 1 7
4196074 3 3 0 0 1
4196079 7 0 6 1 0
4196080 1 1 0 0 0
4196081 7 0 6 1 0
4196082 1 1 0 0 0
4196083 12 0 12 0 0
4196091 4 0 3 1 0
4196092 1 1 0 0 0
4196097 18 0 17 1 0
4196098 1 1 0 0 0
4196101 10 0 10 0 0
4196111 4 0 4 0 0
4196112 3 3 0 0 0
4196119 1 0 1 0 0
4196120 1 1 0 0 0
4196127 123 0 122 1 0
4196128 3 3 0 0 0
4196141 70 0 69 1 7
4196142 9 9 0 0 0
4196143 1 0 1 0 0
4196144 1 1 0 0 0
4196161 14 0 14 0 0
4196162 5 5 0 0 0
4196163 2 0 2 0 0
4196164 1 1 0 0 0
4196169 1 0 1 0 0
4196170 1 1 0 0 0
4196171 31 0 31 0 0
4196172 9 9 0 0 0
4196175 1 0 1 0 0
4196176 1 1 0 0 0
4196183 2 0 2 0 0
4196184 1 1 0 0 0
4196187 3 0 2 1 0
4196188 1 1 0 0 0
4196197 2 0 2 0 0
4196205 1 0 1 0 0
4196206 1 1 0 0 0
4196207 1254 0 1254 0 0
4196208 61 61 0 0 0
4196209 80 0 80 0 0
4196210 15 15 0 0 0
4196215 9 0 9 0 0
4196216 3 3 0 0 0
4196217 45 0 45 0 0
4196223 1720 0 1719 1 3
4196224 87 87 0 0 1
4196731 2 2 0 0 1
4196732 16 16 0 0 1
4196735 4 4 0 0 1
4196740 6 5 0 1 5
4196741 5 5 0 0 2
4196742 1 1 0 0 1
4196746 6 6 0 0 3
4196747 14 14 0 0 1
4196748 41 41 0 0 2
4196749 4 4 0 0 1
4196762 1 1 0 0 1
4196763 52 52 0 0 3
4196764 1 1 0 0 1
4196768 13 13 0 0 0
4196774 13 13 0 0 0
4196775 5 5 0 0 2
4196780 2 2 0 0 1
4196783 1 1 0 0 1
4196784 1 1 0 0 1
4196785 4 4 0 0 1
4196805 1 1 0 0 0
4196806 1 1 0 0 0
4196843 10 10 0 0 0
4196863 7 7 0 0 3
4196907 1 1 0 0 0
4196919 6 6 0 0 0
4197035 1 1 0 0 0
4197036 1 1 0 0 0
4197099 1 1 0 0 0
4197102 4 4 0 0 0
4197112 1 1 0 0 0
4197127 1 1 0 0 1
4197128 1 1 0 0 1
4197129 1 1 0 0 1
4197130 1 1 0 0 1
4197131 1 1 0 0 1
4197132 1 1 0 0 1
4197133 1 1 0 0 1
4197134 1 1 0 0 1
4197135 1 1 0 0 1
4197136 1 1 0 0 1
4197137 1 1 0 0 1
4197138 1 1 0 0 1
4197139 1 1 0 0 1
4197140 1 1 0 0 1
4197141 1 1 0 0 1
4197142 1 1 0 0 1
4197143 1 1 0 0 1
4197144 1 1 0 0 1
4197145 17 17 0 0 0
4197173 1 1 0 0 1
4197178 1 1 0 0 0
4197184 1 1 0 0 0
4197216 3 3 0 0 1
4197256 26 26 0 0 7
4197292 5 5 0 0 2
4197293 8 8 0 0 1
4197326 1 1 0 0 1
4197340 1 1 0 0 0
4197362 4 4 0 0 0
4197391 1 1 0 0 1
4197422 1 1 0 0 1
4197473 4 4 0 0 0
4197477 6 6 0 0 3
4197481 8 8 0 0 0
4197485 2 2 0 0 0
4197497 19 19 0 0 0
4197500 2 2 0 0 2
4197509 8 8 0 0 0
4197539 1 1 0 0 0
4197540 4 4 0 0 1
4197541 5 5 0 0 3
4197542 26 25 0 1 7
4197546 11 11 0 0 6
4197547 9 9 0 0 4
4197552 1 1 0 0 0
4197554 1 1 0 0 0
4197568 1 1 0 0 0
4197570 1 1 0 0 0
4197585 4 4 0 0 0
4197589 2 2 0 0 2
4197591 1 1 0 0 0
4197596 1 1 0 0 0
4197601 1 1 0 0 0
4197602 1 1 0 0 0
4197604 1 1 0 0 0
4197606 1 1 0 0 0
4197609 1 1 0 0 0
4197611 1 1 0 0 0
4197612 9 9 0 0 4
4197631 4 4 0 0 0
4197642 1 1 0 0 0
4197644 1 1 0 0 0
4197682 1 1 0 0 0
4197686 3 3 0 0 0
4197689 1 1 0 0 0
4197695 2 2 0 0 1
4197696 5 5 0 0 2
4197697 1 1 0 0 1
4197698 2 2 0 0 1
4197699 1 1 0 0 1
4197700 4 4 0 0 3
4197703 1 1 0 0 0
4197717 1 1 0 0 0
4197729 5 5 0 0 2
4197730 12 12 0 0 10
4197731 4 4 0 0 1
4197732 4 4 0 0 1
4197733 4 4 0 0 1
4197736 2 2 0 0 1
4197737 4 4 0 0 3
4197738 4 4 0 0 0
4197778 2 2 0 0 0
4197784 1 1 0 0 0
4197805 1 1 0 0 0
4197806 1 1 0 0 0
4197820 1 1 0 0 1
4197821 1 1 0 0 1
4197844 1 1 0 0 1
4197845 1 1 0 0 1
4197846 1 1 0 0 1
4197847 1 1 0 0 1
4197848 1 1 0 0 1
4197849 1 1 0 0 1
4197890 1 1 0 0 0
4197956 3 3 0 0 0
4197961 1 1 0 0 0
4197966 1 1 0 0 0
4197977 1 1 0 0 0
4198065 4 4 0 0 1
4198066 4 4 0 0 1
4198067 9 7 0 2 7
4198068 301 301 0 0 18
4198069 4 4 0 0 1
4198070 14 14 0 0 5
4198071 28 28 0 0 13
4198072 25 25 0 0 0
4198075 52 52 0 0 6
4198078 9 9 0 0 1
4198084 3 3 0 0 0
4198085 3 3 0 0 0
4198092 38 38 0 0 0
4198096 23 23 0 0 0
4198146 1 0 1 0 1
4198147 1 1 0 0 1
4198148 2 2 0 0 2
4198149 2 2 0 0 2
4198150 3 3 0 0 3
4198151 2 2 0 0 2
4198152 1 1 0 0 1
4198153 1 1 0 0 1
4198154 1 1 0 0 1
4198155 3 3 0 0 3
4198173 1 1 0 0 1
4198179 4 4 0 0 1
4198182 39 39 0 0 1
4198187 9 9 0 0 4
4198193 1 1 0 0 1
4198199 1 1 0 0 0
4198201 5 5 0 0 0
4198220 3 3 0 0 3
4198249 3 3 0 0 1
4198250 16 16 0 0 3
4198301 2 2 0 0 2
4198303 1 1 0 0 1
4198304 1 1 0 0 1
4198305 1 1 0 0 1
4198306 1 1 0 0 1
4198307 1 1 0 0 1
4198308 1 1 0 0 1
4198309 1 1 0 0 1
4198310 1 1 0 0 1
4198311 1 1 0 0 1
4198312 1 1 0 0 1
4198313 1 1 0 0 1
4198314 1 1 0 0 1
4198330 6 6 0 0 0
4198334 2 2 0 0 0
4198378 1 1 0 0 1
4198379 37 37 0 0 1
4198380 1 1 0 0 1
4198381 68 68 0 0 1
4198382 3 3 0 0 1
4198383 1 1 0 0 1
4198384 1 1 0 0 1
4198385 1 1 0 0 1
4198386 1 1 0 0 1
4198387 1 1 0 0 1
4198388 238 238 0 0 1
4198389 4 4 0 0 1
4198390 3 3 0 0 1
4198393 5 5 0 0 0
4198396 6 6 0 0 0
4198397 7 7 0 0 0
4198398 2 2 0 0 0
4198399 3 3 0 0 1
4198402 4 4 0 0 1
4198426 4 4 0 0 1
4198438 45 43 0 2 32
4198452 8 8 0 0 5
4198486 1 1 0 0 0
4198493 1 1 0 0 0
4198510 1 1 0 0 1
4198511 3 3 0 0 1
4198520 6 6 0 0 4
4198521 3 3 0 0 1
4198522 6 6 0 0 4
4198523 3 3 0 0 1
4198524 27 27 0 0 3
4198525 5 5 0 0 3
4198527 143 143 0 0 92
4198542 2 2 0 0 0
4198544 2 2 0 0 0
4198640 6 6 0 0 0
4198684 2 2 0 0 0
4198715 6 6 0 0 0
4198716 4 4 0 0 0
4198732 5 5 0 0 0
4198746 41 41 0 0 0
4198747 2 2 0 0 2
4198759 47 0 46 1 4
4198760 7 7 0 0 0
4198761 2 2 0 0 0
4198762 23524 0 23523 1 5
4198763 154 154 0 0 1
4198764 1 1 0 0 1
4198765 1 1 0 0 1
4198766 1 1 0 0 1
4198767 1 1 0 0 1
4198768 1 1 0 0 1
4198769 1 1 0 0 1
4198770 1 1 0 0 1
4198771 1 1 0 0 1
4198772 1 1 0 0 1
4198773 1 1 0 0 1
4198774 1 1 0 0 1
4198775 1 1 0 0 1
4198776 1 1 0 0 1
4198777 1 1 0 0 1
4198778 1 1 0 0 1
4198779 1 1 0 0 1
4198780 1 1 0 0 1
4198781 1 1 0 0 1
4198782 1 1 0 0 1
4198783 1 1 0 0 1
4198784 1 1 0 0 1
4198785 1 1 0 0 1
4198786 1 1 0 0 1
4198790 1 1 0 0 0
11534337 1 0 1 0 1
11534341 152 0 152 0 1
11534343 128 0 128 0 0
11534345 131 0 131 0 0
11534347 145 0 145 0 0
11534349 111 0 111 0 4
11534351 133 0 133 0 0
11534353 206 0 205 1 10
11534354 1 0 1 0 1
11534355 113 0 113 0 1

Totals: 126057 4281 121711 65 921

Percentages:
Data 96.55
Btree 3.40
Other 0.05

Buffer pool page size: 8192
partnum total btree data other dirty
0 17 0 11 6 1
7340033 2 0 1 1 0
8388609 2 0 1 1 0
9437185 2 0 1 1 0
10485761 12705 0 56 12649 5
10485856 714 394 319 1 664
10485857 2066 1178 887 1 2066
10485858 1730 971 759 0 1730
10485859 2 1 0 1 2
10485902 2 1 1 0 0
10485953 1 1 0 0 0
10485958 1 1 0 0 0
10485963 3 1 1 1 0
10485964 3 1 1 1 0
10485968 3 1 1 1 0
10485969 4 1 2 1 0
10485970 3 1 1 1 0
10485971 3 1 1 1 0
10485972 3 1 1 1 0
10485973 3 1 1 1 0
10485995 3 1 1 1 0
10485996 3 1 1 1 0
10485997 3 1 1 1 0
10485998 3 1 1 1 0
10486176 1 1 0 0 0
10486178 3 1 1 1 0
10486272 3 1 1 1 0
10486274 3 1 1 1 0
10486275 3 1 1 1 0
10486276 3 1 1 1 0
10486277 3 1 1 1 0
10486278 3 1 1 1 0
10486279 3 1 1 1 0
10486307 3 1 1 1 0
10486497 1 0 1 0 0
10486946 1 1 0 0 0
10487073 3 1 1 1 0
10487074 3 1 1 1 0
10487200 3 1 1 1 0
10487457 64 37 27 0 0
10487488 192 106 86 0 0
10487489 192 105 87 0 0
10487491 283 155 128 0 0
10487492 192 105 87 0 0
10487584 64 35 29 0 0
10487585 64 35 29 0 0
10487819 64 37 27 0 0
10487820 64 37 27 0 0
10487821 128 72 56 0 0
10487822 64 35 29 0 0
10488032 1 1 0 0 0
10488099 1 1 0 0 0
10488163 2 1 1 0 0
10488166 2 0 2 0 0
10488174 1 0 1 0 0
10488233 3 1 2 0 0
10488249 3 1 1 1 0
10488251 3 1 1 1 0
10488252 3 1 1 1 0
10488256 128 72 56 0 0
10488257 192 108 84 0 0
10488320 232 131 101 0 0
10488321 328 184 144 0 0
10488356 3 1 1 1 0
10488358 2 1 1 0 0
10488363 3 1 1 1 0
10488367 10 5 5 0 0
10488368 54 31 23 0 0
10488378 64 37 27 0 0
10488384 320 181 139 0 0
10488385 232 130 102 0 0
10488386 76 41 35 0 0
10488387 128 71 57 0 0
10488388 32 16 16 0 0
10488389 4 2 2 0 0
10488390 40 22 18 0 0
10488391 96 52 44 0 0
10488394 88 50 38 0 0
10488430 1 1 0 0 0
10488452 64 35 29 0 0
10488453 2 1 1 0 0
10488467 64 37 27 0 0
10488469 20 12 8 0 0
10488487 53 31 22 0 0
10488490 3 1 1 1 0
10488491 3 1 1 1 0
10488492 3 1 1 1 0
10488493 3 1 1 1 0
10488494 3 1 1 1 0
10488495 3 1 1 1 0
10488496 3 1 1 1 0
10488497 11 6 5 0 0
10488514 3 1 1 1 0
10488525 3 1 1 1 0
10488528 3 1 1 1 0
10488530 32 18 14 0 0
10488532 64 35 29 0 0
10488534 64 36 28 0 0
10488535 32 18 14 0 0
10488537 12 6 6 0 0
10488542 64 35 29 0 0
10488547 64 36 28 0 0
10488549 64 36 28 0 0
10488550 128 74 54 0 0
10488551 64 35 29 0 0
10488570 1 1 0 0 0
10488582 64 36 28 0 0
10488616 64 37 27 0 0
10488618 64 37 27 0 0
10488623 128 72 56 0 0
10488624 24 13 11 0 0
10488653 64 35 29 0 0
10488656 64 35 29 0 0
10488658 96 54 42 0 0
10488661 64 36 28 0 0
10488666 1 1 0 0 0
10488681 202 111 91 0 0
10488682 64 35 29 0 0
10488683 619 347 272 0 0
10488684 139 79 60 0 0
10488686 128 72 56 0 0
10488687 64 35 29 0 0
10488688 64 35 29 0 0
10488702 64 35 29 0 0
10488704 256 143 113 0 0
10488705 192 106 86 0 0
10488709 144 78 66 0 0
10488710 96 52 44 0 0
10489164 2 1 1 0 0
10489340 42 23 19 0 0
10489392 2 1 1 0 0
10489394 1 1 0 0 0
10489970 108 60 48 0 0
10490115 2 1 1 0 0
10490154 4 2 2 0 0
10490159 4 2 2 0 0
10490304 3 1 2 0 0
10490305 5 2 3 0 0
10490310 24 12 11 1 0
10490311 3 1 1 1 0
10490313 3 1 1 1 0
10490314 3 1 1 1 0
10490315 3 1 1 1 0
10490316 5 2 2 1 0
10490317 4 1 2 1 0
10490318 3 1 1 1 0
10490319 3 1 1 1 0
10490320 8 4 3 1 0
10490321 3 1 1 1 0
10490322 3 1 1 1 0
10490323 192 106 86 0 0
10490324 165 92 73 0 0
10490325 27 15 12 0 0
10490326 6 3 3 0 0
10490327 64 35 29 0 0
10490331 3 2 1 0 0
10490337 91 49 42 0 0
10490371 192 105 87 0 0
10490373 48 26 22 0 0
10490381 8 5 3 0 0
10490389 192 106 86 0 0
10490393 192 105 87 0 0
10490413 3 1 1 1 0
10490425 16 8 8 0 0
10491008 2 1 1 0 0
10491009 3 1 1 1 0
10491010 3 1 1 1 0
10491012 4 1 2 1 0
10491018 2 1 1 0 0
10491019 3 1 1 1 0
10491284 96 52 44 0 0
10491285 96 52 44 0 0
10491286 96 52 44 0 0
10491528 1 0 1 0 0
10491866 84 48 36 0 0
10491867 180 101 79 0 0
10491886 24 14 10 0 0
10492035 152 85 67 0 0
10492780 144 78 66 0 0
10493231 32 18 14 0 0
10495093 1 1 0 0 0
10495142 1 0 1 0 0
10495407 4 2 2 0 0
10495443 3 1 2 0 0
10495450 2 1 1 0 0
10495452 8 4 4 0 0
10495471 5 3 2 0 0
10495478 1 1 0 0 0
10495493 64 37 27 0 0
10495494 64 37 27 0 0
10495530 272 148 124 0 0
10495531 20 12 8 0 0
10495536 64 35 29 0 0
10495541 16 8 8 0 0
10495819 74 41 33 0 0
10495946 1 1 0 0 0
10495954 16 9 7 0 0
10496031 24 14 10 0 0
10496035 8 4 4 0 0
10496036 12 7 5 0 0
10496196 32 18 14 0 0
10496668 32 18 14 0 0
10496773 28 16 12 0 0
10497015 22 12 10 0 0
10497261 18 10 8 0 0
10497455 8 4 4 0 0
10497612 64 36 28 0 0
10497632 56 32 24 0 0
10497802 12 7 5 0 0
10497826 4 2 2 0 0
10497827 28 16 12 0 0
10497828 88 48 40 0 0
10497922 112 64 48 0 0
10497924 112 63 49 0 0
10497925 64 37 27 0 0
10497929 128 73 55 0 0
10497947 64 37 27 0 0
10497948 64 37 27 0 0
10497950 64 36 28 0 0

Totals: 28260 8639 6904 12717 4468

Percentages:
Data 24.43
Btree 30.57
Other 45.00

SO my question is
1. how many buffer i need to increase.?
2. Btree percentage for 4k page is 3.40% of buffers, why the indexes are not
using the buffers 3. Mostly data pages are using 95% of buffers, how to
reduce this utilization.

Please Explain me on this points.

Thanks in advance.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.