The CPU load of the system is basically caused by the application program (User) and the kernel (Sys/Kernel). Cases created by the kernel are generally when events about system resource usage occur, and other cases are mostly used by application programs. In the case of Altibase, various algorithms are applied to process queries (transactions) created by users, and use of various system resources such as communication and replication with clients connected to DB, and disk I/O by processing data files occurs. CPU usage of both the User area and the Sys/Kernel area occurs.
This document describes what parts to examine when the CPU utilization rate occupied by Altibase increases, whether it is normal/abnormal, and how to solve it in abnormal cases.
It is recommended to refer to the following documents in advance.
- Altibase Development Guide
- Altibase SQL Tuning Guide
- Altibase Monitoring Query Guide
The test environment of this document is as follows.
- Altibase: Altibase version 6 or later
- OS: Linux (2.6.32-504.el6.x86_64)