The Mimer SQL database server process supports a number of separate request threads and background threads, running simultaneously under the operating system.
Number of Request Threads
The amount of concurrency that the database server can support is dependent on the number of available request threads. If there are more concurrent requests than threads, the database server will start scheduling requests to improve response times. Increasing the number of request threads in a situation like this may improve performance.
The number of request threads in a database server is defined at system start-up. A change to the number of request threads requires that the system be stopped and re-started.
The maximum number of concurrent request threads is limited by the size of the bufferpool.
Number of Background Threads
The background threads in a Mimer SQL database server perform tasks such as:
- Recording transactions in LOGDB.
- Updating master and shadow databanks.
- Securing data on disk.
- Online backup.
See Background Threads for information relevant to fine-tuning the number of background threads.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40