BTSCANNER [num=scanner_threads,][priority=low|high,] [threshold=committed_deleted],[rangesize=size]
The number of B-tree scanner threads to start. Must be an integer between 1 and 32, inclusive. The default is 1.
committed_deleted
The minimum number of committed deleted items an index must encounter before adding the index to the hot list as a candidate for cleaning. Must be an integer greater than 0. The default is 500.
After all indexes above the threshold are cleaned, indexes below the threshold are added to the hot list. The default threshold is 500.
The priority=high option sets the priority of the B-tree scanner threads to equal that of normal users. The priority=low option sets the priority of the B-tree scanner threads lower than that of normal users. This command allows the B-tree scanner to consume only spare system resources, ensuring that the threads will not use the CPU cycles of normal users. The default priority is low.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]