Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Overview


When technical support related to DBMS is provided, there are cases where information for problem-solving is insufficient only with the performance view provided by Altibase.

This document describes several related commands provided by the operating system to obtain necessary information.

Icon

For errors and improvements related to this document, please contact the technical support portal or technical support center.

 

Common Command


This section describes commands that do not have special restrictions that can be executed by all operating systems.

netstat


  • This command checks whether there is a network configuration or an error packet.

    If a problem occurs between sender and receiver on a packet, the value of R(T)X-ERR/R(T)X-DRP/R(T)X-OVR increases. In this case, there may be some problem on the network, so take measures to have the administrator check.

vmstat


  • This command checks system memory, disk, swap in/out, and CPU status at intervals set by the user.

    The main indicators to be checked are as follows.

     Description
    proc rThe number of threads waiting to occupy the CPU. If the value is large, it can be judged that a CPU bottleneck occurs.
    memory freeFree space on physical memory
    swap si, soAn increase of si/so means that disk I/Os between the swap disk and memory are issued
    CPU us sy id wa stChange trends for each item should be observed

Linux


CPU usage by thread


  • In Linux, the user can also check the CPU for each thread with the top command. If executed with the top -H option, the search is performed for each thread. However, it is possible only if the installed procps version is 3.2.7 or later.
    If not, simply check as follows. (Not well supported in lower version)

    LWP is a unique number for each thread, and the value displayed in the C item is the CPU usage rate.

     Description
    CPUCPU share that the thread is currently using
    LWPIDUnique number of thread

pstack


 

 

 

  • No labels