Databases
IBM Informix
Tunning
Tunning
Preview
Content
6
Media
11
Back to parent
Informix tunning
Sizing buffers
Sizing LRU's
Monitor Disk Writes
Setting CLEANNERS
Monitor CPU processor usage
Monitor KIO/AIO processor usage
Monitoring checkpoint
Monitoring open cursors
Huge pages
PDQ
PDQ configuration parameters
Database operations that use PDQ
Performance Advisory
Server contention
Application Design
Undocumented ONCONFIG Parameters
Sizing VLDB
TPCH sample
Database storage
Database limits
Database storage
Table sizing
Index sizing
Tunning onconfig
Table of results
Disk considerations
Memory considerations
Speed up big index creation
Considerations
Calculate index size
Index fill factor
Verify temporary space
Prevent long transaction
Paralellization
Replication impact
Memory considerations
Fragmentation
Concurrency
Sample case
Monitor activity
Test results
Recomendations
Table and index partitioning
Fragments and extents
Advantages of fragmentation
Types of distribution schemes
Round robin fragmentation
Expression-based fragmentation
Rowids in a fragmented table
Maintaining table and index partitioning
Rolling Window Tables
Image
Name
Size (kB)
blobpage.gif
159.60
blobpage_chunk.gif
159.60
chunk.gif
159.60
extent.gif
159.60
extent_allocation.gif
159.60
page.gif
159.60
Table_and_index_partitioning_balnaced_io.PNG
159.60
Table_and_index_partitioning_expression_based.PNG
159.60
Table_and_index_partitioning_Fragments_and_extents.PNG
159.60
Table_and_index_partitioning_Parallel_scans.PNG
159.60
Table_and_index_partitioning_round_robin.PNG
159.60
blobpage.gif
blobpage_chunk.gif
chunk.gif
extent.gif
extent_allocation.gif
page.gif
Table_and_index_partitioning_balnaced_io.PNG
Table_and_index_partitioning_expression_based.PNG
Table_and_index_partitioning_Fragments_and_extents.PNG
Table_and_index_partitioning_Parallel_scans.PNG
Table_and_index_partitioning_round_robin.PNG
×