The bufferpool tag has no wiki summary.
3
votes
1answer
79 views
Buffer usage for index with no reads
Using SQL Server 2008 R2, the main transactional table in a vendor database is massive compared to all others and has about 14 indexes. Some of these indexes don't get used in our environment, but we ...
2
votes
1answer
152 views
How to create Buffer Pool in Database dedicated only for ONE BIG table?
I have table TICKET with 400K records in database (DB2).
I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it?
...
2
votes
0answers
116 views
tempdb objects creator wanted, bufferpool issue caused by tempdb objects
I have a number of tables in tempdb named like
#A0030B77
#A01D908C
#A06D1FCB
#A0F72FB0
#A1614404
#A1EB53E9
#A205D8FE
#A255683D
How (if) can I get spid of the process which created them?
These ...
1
vote
1answer
96 views
Should indexes automatically be placed into their own bufferpool?
We work with DB2 LUW (specifically we are currently on 9.7 FP4) running on AIX.
Per best practices from IBM, they recommend that when you build a table, you place the data, the indexes, and LOBs/LONG ...
1
vote
2answers
58 views
Why would increase in innodb_buffer_pool_size slow down MySQL?
5.1.68-cll - MySQL Community Server on CentOS
The system has 32GB of RAM.
I increased innodb_buffer_pool_size from 10240M to 15360M (10GB -> 15GB).
Time taken for a series of identical operations ...
