Viewing Data Operation Status

How To

The data operation status page displays data operation statistics from the SYSINFO table. Data operation status items and their corresponding SYSINFO.INFO values are summarized in Table .

Data Operation Status Item

Description

Number of SELECT Operations

The total number of SELECT operations performed since the database was started. (NUM_SQL_SELECT)

Number of INSERT (including INSERT INTO) Operations

The total number of SELECT operations performed since the database was started. (NUM_SQL_ INSERT)

Number of UPDATE Operations

The total number of UPDATE operations performed since the database was started. (NUM_SQL_UPDATE)

Number of DELETE Operations

The total number of DELETE operations performed since the database was started. (NUM_SQL_DELETE)

Number of SQLPrepare() calls to server

The total number of SQLPrepare() calls to the database since the database was started. (NUM_SQL_PREPARE)

Number of SQLExecute() calls to server

The total number of SQLExecute()calls to the database since the database was started. (NUM_SQL_EXECUTE)

Number of SQLExecDirect() calls to server

The total number of SQLExecDirect()calls to the database since the database was started. (NUM_SQL_EXEDIRECT)

Number of passing fetched data across the network

The total number of fetch operations performed by clients since the database was started. (NUM_SQL_FETCH)

Table: Data Operations Status items


Related topic:

Monitoring Database Status
Statistical Information