SingleStore Studio Workload Monitoring

Important

Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers at this time.

The Studio Workload Monitoring page is a feature of Studio that allows customers to record and visually analyze workload profiles at either the query or node level.

The Workload Monitoring page is built on top of the native Workload Profiling capabilities of MemSQL. As such, you should read the entire Workload Profiling topic before using Workload Monitoring in Studio.

Creating a Recording

To begin, you must create a recording of your cluster activities by clicking the Begin Profiling button in the UI. When you start recording a profile in Studio, a snapshot of INFORMATION_SCHEMA.MV_ACTIVITIES_EXTENDED_CUMULATIVE is captured. When you stop recording, another snapshot of the same table is captured and Studio calculates the difference between the two snapshots.

Analyzing a Recording

Studio allows you to analyze the resource usage of all the queries that were running in the cluster while the recording was taking place. For each query, you can inspect various metrics such as disk usage, network usage, and time spent on various things (waiting for disk I/O, waiting for CPU, etc.).

Moreover, Studio also allows you to analyze the resource usage per SingleStore node (instead of per query). This is useful to see whether a specific SingleStore node is the bottleneck of a query’s performance.

Exporting and importing workload profiles

If you want to share a recording with other Studio users, you can export a recording as a JSON file using the button in the upper-right corner of the page. Other users can then import these files through the Workload Monitoring page.

How does the Time Spent column work?

The Time Spent column on the Workload Monitoring page shows where a given query spent its time, as an average percentage of wall-clock execution time across all executions during the recording period. If advanced counters are not turned on, then this column will not yield the most precise results.

Last modified: January 10, 2023

Was this article helpful?