Sign inTry Free

MV_BOTTOMLESS_API_EVENTS_SUMMARY

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

On this page

This view contains a grouped and summarized version of MV_BOTTOMLESS_API_EVENTS information schema view.

Schema

Column Name

Description

NODE_ID

ID of the node where the database is located.

EVENT_TYPE

Type of remote API event taking place (List / Delete / Upload / Download / Copy).

FILE_TYPE

Type of file the remote API event is for (Blob / Snapshot / Log Chunk / Milestone / Datetime to Version / Metadata / Backup Blob / Backup Snapshot).

EVENT_STATE

State of the remote API event (In Progress / Succeeded / Failed).

ERROR_CODE

Error code of the remote API event, or NULL if no error.

COUNT

Number of remote API calls made from the engine, grouped by NODE_ID, EVENT_TYPE, FILE_TYPE, EVENT_STATE, and ERROR_CODE.

ERROR_MESSAGE

Any error message of the remote API events.

START_TIME

Timestamp at which the remote API events started.

END_TIME

Timestamp at which the remote API events finished.

MIN_TIME_TAKEN_SECS

Minimum time taken by a remote API event, in seconds.

MEDIAN_TIME_TAKEN_SECS

Median time taken by a remote API event, in seconds.

MAX_TIME_TAKEN_SECS

Maximum time taken by a remote API event, in seconds.

MIN_TIME_TAKEN_BOTTLE_SERVICE_SECS

Minimum time taken by a bottle service API event, in seconds.

MEDIAN_TIME_TAKEN_BOTTLE_SERVICE_SECS

Median time taken by a bottle service API event, in seconds.

MAX_TIME_TAKEN_BOTTLE_SERVICE_SECS

Maximum time taken by a bottle service API event, in seconds

MIN_COMPRESSED_MB

Minimum size of compressed data being processed by a remote API event, in MBs.

MEDIAN_COMPRESSED_MB

Median size of compressed data being processed by a remote API event, in MBs.

MAX_COMPRESSED_MB

Maximum size of compressed data being processed by a remote API event, in MBs.

COUNT_HAS_RETRIES

Total number of remote API requests that were retried.

MAX_NUM_RETRIES

Maximum number of remote API requests that were retried.

For example:

SELECT * FROM information_schema.MV_BOTTOMLESS_API_EVENTS_SUMMARY;
+---------+------------+---------------------+-------------+------------+-------+---------------+----------------------------+----------------------------+---------------------+------------------------+---------------------+------------------------------------+---------------------------------------+------------------------------------+-------------------+----------------------+-------------------+-------------------+-----------------+
| NODE_ID | EVENT_TYPE | FILE_TYPE           | EVENT_STATE | ERROR_CODE | COUNT | ERROR_MESSAGE | START_TIME                 | END_TIME                   | MIN_TIME_TAKEN_SECS | MEDIAN_TIME_TAKEN_SECS | MAX_TIME_TAKEN_SECS | MIN_TIME_TAKEN_BOTTLE_SERVICE_SECS | MEDIAN_TIME_TAKEN_BOTTLE_SERVICE_SECS | MAX_TIME_TAKEN_BOTTLE_SERVICE_SECS | MIN_COMPRESSED_MB | MEDIAN_COMPRESSED_MB | MAX_COMPRESSED_MB | COUNT_HAS_RETRIES | MAX_NUM_RETRIES |
+---------+------------+---------------------+-------------+------------+-------+---------------+----------------------------+----------------------------+---------------------+------------------------+---------------------+------------------------------------+---------------------------------------+------------------------------------+-------------------+----------------------+-------------------+-------------------+-----------------+
|       1 | List       | Metadata            | Succeeded   |       NULL |     3 | NULL          | 2024-11-13 07:45:25.193625 | 2024-11-13 07:46:12.306518 |            0.015709 |               0.021789 |            0.100597 |                                  0 |                                     0 |                                  0 |              NULL |                 NULL |              NULL |                 0 |               0 |
|       1 | List       | Log Chunk           | Succeeded   |       NULL |     9 | NULL          | 2024-11-13 07:45:25.717536 | 2024-11-13 07:45:25.825400 |            0.010697 |               0.012168 |             0.01321 |                                  0 |                                     0 |                                  0 |              NULL |                 NULL |              NULL |                 0 |               0 |
|       1 | List       | Snapshot            | Succeeded   |       NULL |     1 | NULL          | 2024-11-13 07:45:25.766439 | 2024-11-13 07:45:25.766439 |            0.011082 |               0.011082 |            0.011082 |                                  0 |                                     0 |                                  0 |              NULL |                 NULL |              NULL |                 0 |               0 |
|       1 | Upload     | Milestone           | Succeeded   |       NULL |     1 | NULL          | 2024-11-13 07:45:25.586165 | 2024-11-13 07:45:25.586165 |            0.023145 |               0.023145 |            0.023145 |                                  0 |                                     0 |                                  0 |        0.00017929 |       0.000179290771 |        0.00017929 |                 0 |               0 |
|       1 | Upload     | Datetime to Version | Succeeded   |       NULL |    36 | NULL          | 2024-11-13 07:45:53.653097 | 2024-11-13 08:03:23.879170 |             0.01992 |              0.0381725 |            0.123163 |                                  0 |                                     0 |                                  0 |        0.00026608 |       0.010181903839 |        0.01980019 |                 0 |               0 |
|       1 | Copy       | Snapshot            | Succeeded   |       NULL |     1 | NULL          | 2024-11-13 07:45:25.528908 | 2024-11-13 07:45:25.528908 |            0.041636 |               0.041636 |            0.041636 |                                  0 |                                     0 |                                  0 |        0.00334167 |       0.003341674805 |        0.00334167 |                 0 |               0 |
|       1 | Download   | Snapshot            | Succeeded   |       NULL |     4 | NULL          | 2024-11-13 07:45:25.352866 | 2024-11-13 07:45:25.982388 |            0.016085 |               0.020164 |            0.144491 |                                  0 |                                     0 |                                  0 |        0.00333786 |       0.003337860107 |        0.00333786 |                 0 |               0 |
|       1 | Upload     | Log Chunk           | Succeeded   |       NULL |     3 | NULL          | 2024-11-13 07:45:52.348489 | 2024-11-13 07:47:13.682946 |            0.029517 |               0.034524 |            0.078638 |                                  0 |                                     0 |                                  0 |        0.00041866 |       0.004643440246 |        0.00562477 |                 0 |               0 |
|       1 | Download   | Datetime to Version | Succeeded   |       NULL |    35 | NULL          | 2024-11-13 07:46:23.662006 | 2024-11-13 08:03:23.858621 |            0.012279 |                0.01654 |            0.059926 |                                  0 |                                     0 |                                  0 |        0.00026608 |       0.009906768799 |        0.01924419 |                 0 |               0 |
|       1 | Download   | Milestone           | Succeeded   |       NULL |     1 | NULL          | 2024-11-13 07:45:25.043314 | 2024-11-13 07:45:25.043314 |            0.149088 |               0.149088 |            0.149088 |                                  0 |                                     0 |                                  0 |        0.00021744 |       0.000217437744 |        0.00021744 |                 0 |               0 |
+---------+------------+---------------------+-------------+------------+-------+---------------+----------------------------+----------------------------+---------------------+------------------------+---------------------+------------------------------------+---------------------------------------+------------------------------------+-------------------+----------------------+-------------------+-------------------+-----------------+

Last modified: November 21, 2024

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK