# Workload Profiling

**URL:** https://www.singlestore.com/forum/c/support/workload-profiling/29.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [Queries got queued after disk size/performance increase on k8s (AKS)](https://www.singlestore.com/forum/t/queries-got-queued-after-disk-size-performance-increase-on-k8s-aks/8574)

<div class="topic-metadata">

**Author:** [@roslon.r](https://www.singlestore.com/forum/u/roslon.r)\
**Replies:** 3\
**Last updated:** [June 15, 2026, 9:47pm UTC](https://www.singlestore.com/forum/t/queries-got-queued-after-disk-size-performance-increase-on-k8s-aks/8574 "2026-06-15T21:47:41Z")

</div>

We have increased the disk size for our SingleStoreDB leaves from 4TB to 5TB (azure premium SSD P50 to P60). Cluster is running on AKS with nodepool based on the Standard\_E20s\_v5 VM. After that the queries got queued a…

---

## [Need clarity on how singlestore computes Total CPU percent](https://www.singlestore.com/forum/t/need-clarity-on-how-singlestore-computes-total-cpu-percent/8498)

<div class="topic-metadata">

**Author:** [@shyams](https://www.singlestore.com/forum/u/shyams)\
**Replies:** 0\
**Last updated:** [February 24, 2026, 7:36am UTC](https://www.singlestore.com/forum/t/need-clarity-on-how-singlestore-computes-total-cpu-percent/8498 "2026-02-24T07:36:50Z")

</div>

I recently came across active profiling and I’m trying to understand how does it work. So I read a blog where it mentioned upon initiating manual profiling, Singlestore takes a snapshot of the mv\_activities and after the…

---

## [Unit\_images & compiled\_unit\_sections taking up too much memory](https://www.singlestore.com/forum/t/unit-images-compiled-unit-sections-taking-up-too-much-memory/7848)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 1\
**Last updated:** [August 12, 2024, 10:38am UTC](https://www.singlestore.com/forum/t/unit-images-compiled-unit-sections-taking-up-too-much-memory/7848 "2024-08-12T10:38:35Z")

</div>

Hi Guys, Currently We have S-00 plan, unit\_images & compiled\_unit\_sections is taking up almost 1 GB each. We are not sure why. May be our plan expiration is 12 Hours. What data does this memory holds and what all facto…

---

## [How to properly calculate maximum\_table\_memory maximum\_memory?](https://www.singlestore.com/forum/t/how-to-properly-calculate-maximum-table-memory-maximum-memory/7603)

<div class="topic-metadata">

**Author:** [@rmalenko](https://www.singlestore.com/forum/u/rmalenko)\
**Replies:** 5\
**Last updated:** [April 8, 2024, 10:25am UTC](https://www.singlestore.com/forum/t/how-to-properly-calculate-maximum-table-memory-maximum-memory/7603 "2024-04-08T10:25:11Z")

</div>

Hi, I have a question to properly setup memory using. For example. If I have 100G RAM on server and set: maximum\_memory = 90G maximum\_table\_memory = 80G Does this mean that total memory usage could be 170G or 90G?

---

## [CPU Usage in terms of load average and utilization percentage on nodes](https://www.singlestore.com/forum/t/cpu-usage-in-terms-of-load-average-and-utilization-percentage-on-nodes/6816)

<div class="topic-metadata">

**Author:** [@muhammadosama.hassan](https://www.singlestore.com/forum/u/muhammadosama.hassan)\
**Replies:** 2\
**Last updated:** [November 3, 2023, 5:35pm UTC](https://www.singlestore.com/forum/t/cpu-usage-in-terms-of-load-average-and-utilization-percentage-on-nodes/6816 "2023-11-03T17:35:06Z")

</div>

greetings, i am looking for query to get the load average along with the CPU load Percentage per node for monitoring report that is going to run once on daily basis at the peak hours of business. what query does the das…

---

## [Query to get memory and disk usage, need suggestions if it can be improved as my target is to get the real time values in terms of total and actual usage](https://www.singlestore.com/forum/t/query-to-get-memory-and-disk-usage-need-suggestions-if-it-can-be-improved-as-my-target-is-to-get-the-real-time-values-in-terms-of-total-and-actual-usage/7167)

<div class="topic-metadata">

**Author:** [@muhammadosama.hassan](https://www.singlestore.com/forum/u/muhammadosama.hassan)\
**Replies:** 2\
**Last updated:** [September 21, 2023, 5:32pm UTC](https://www.singlestore.com/forum/t/query-to-get-memory-and-disk-usage-need-suggestions-if-it-can-be-improved-as-my-target-is-to-get-the-real-time-values-in-terms-of-total-and-actual-usage/7167 "2023-09-21T17:32:31Z")

</div>

select memory\_values.NODE\_ID AS NODE\_ID, memory\_values.node\_type AS NODE\_TYPE, memory\_values.host\_name AS HOST\_NAME, memory\_values.tot\_memory AS TOT\_ME…

---

## [Table and query filters in Historical Workload Monitoring](https://www.singlestore.com/forum/t/table-and-query-filters-in-historical-workload-monitoring/7021)

<div class="topic-metadata">

**Author:** [@fgilio](https://www.singlestore.com/forum/u/fgilio)\
**Replies:** 4\
**Last updated:** [August 7, 2023, 10:04am UTC](https://www.singlestore.com/forum/t/table-and-query-filters-in-historical-workload-monitoring/7021 "2023-08-07T10:04:02Z")

</div>

Hi! It would be incredibly useful if we could filter the “Historical Workload Monitoring” by more parameters like: A particular database table. Eg: I want to optimize how the table “users” from our database “awesomeap…

---

## [Diagnosing high disk read rates](https://www.singlestore.com/forum/t/diagnosing-high-disk-read-rates/4757)

<div class="topic-metadata">

**Author:** [@nlello](https://www.singlestore.com/forum/u/nlello)\
**Replies:** 2\
**Last updated:** [July 13, 2022, 3:57am UTC](https://www.singlestore.com/forum/t/diagnosing-high-disk-read-rates/4757 "2022-07-13T03:57:07Z")

</div>

Our cluster is suffering from extremely high disk read rates, resulting in hight disk wait times. We’re investigating how much is due to slow storage… However, this has raised a couple of points of interest how do I…

---

## [Looking for info to find out which table is used the most, or which query is the slowest](https://www.singlestore.com/forum/t/looking-for-info-to-find-out-which-table-is-used-the-most-or-which-query-is-the-slowest/4558)

<div class="topic-metadata">

**Author:** [@stefandevo](https://www.singlestore.com/forum/u/stefandevo)\
**Replies:** 2\
**Last updated:** [May 25, 2022, 4:39pm UTC](https://www.singlestore.com/forum/t/looking-for-info-to-find-out-which-table-is-used-the-most-or-which-query-is-the-slowest/4558 "2022-05-25T16:39:30Z")

</div>

I am using Managed Service and dived through the docs. I found a lot of mentioning of tables in the information\_schema database that holds all kind of information about the cluster, databases, queries etc. But I wish I …

---

## [Columnar Table is consuming Memory](https://www.singlestore.com/forum/t/columnar-table-is-consuming-memory/3619)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 3\
**Last updated:** [December 27, 2021, 11:46am UTC](https://www.singlestore.com/forum/t/columnar-table-is-consuming-memory/3619 "2021-12-27T11:46:03Z")

</div>

I’m seeing that most of the columnar tables are consuming memory, causing oom issues. Do you what could be causing this? TABLE INFO Memory Usage 1.5 GB Disk Usage 1.5 GB Row Count 5.72M rows Table Type Columnsto…

---

## [Write performance as database size increases](https://www.singlestore.com/forum/t/write-performance-as-database-size-increases/198)

<div class="topic-metadata">

**Author:** [@aaron.pfeifer](https://www.singlestore.com/forum/u/aaron.pfeifer)\
**Replies:** 2\
**Last updated:** [December 19, 2018, 2:34am UTC](https://www.singlestore.com/forum/t/write-performance-as-database-size-increases/198 "2018-12-19T02:34:37Z")

</div>

Hi - We have several columnstore tables in our database. I’ve observed some odd behavior in CPU usage when writing to these tables. When there’s no data in our database: Idle CPU usage in the cluster is 6% CPU usage…

---

## [Can single store work with 100 Columns and 20 million rows?](https://www.singlestore.com/forum/t/can-single-store-work-with-100-columns-and-20-million-rows/3405)

<div class="topic-metadata">

**Author:** [@apideveng](https://www.singlestore.com/forum/u/apideveng)\
**Replies:** 2\
**Last updated:** [October 27, 2021, 11:23am UTC](https://www.singlestore.com/forum/t/can-single-store-work-with-100-columns-and-20-million-rows/3405 "2021-10-27T11:23:03Z")

</div>

The challenge I have is this: The dataset I have is a result of Joining of 35+ tables to create 1 SQL view which is then run overnight and dumps result into a table. The resulting table is in MS SQL with 100 columns and …

---

## [Multi Tenancy in SingleStore Cluster](https://www.singlestore.com/forum/t/multi-tenancy-in-singlestore-cluster/3086)

<div class="topic-metadata">

**Author:** [@japillai.c](https://www.singlestore.com/forum/u/japillai.c)\
**Replies:** 5\
**Last updated:** [June 27, 2021, 5:58am UTC](https://www.singlestore.com/forum/t/multi-tenancy-in-singlestore-cluster/3086 "2021-06-27T05:58:11Z")

</div>

I have a single store cluster with two databases running in it Eg DB1 ,DB2 . Using Resource governor I have set the properties of resource allocation at cluster level . Is there a way by which I can increase the size …

---

## [Debugging queries with varbinary content](https://www.singlestore.com/forum/t/debugging-queries-with-varbinary-content/2757)

<div class="topic-metadata">

**Author:** [@h.fries](https://www.singlestore.com/forum/u/h.fries)\
**Replies:** 3\
**Last updated:** [April 12, 2021, 8:00pm UTC](https://www.singlestore.com/forum/t/debugging-queries-with-varbinary-content/2757 "2021-04-12T20:00:00Z")

</div>

I am trying to debug a query that sometimes is running much longer then expecting. So I think it is hitting a corner case, depending on the used data. Part of it contains a varbinary value. If I print it in the active p…

---

## [How to kill the sessions which are in sleep?](https://www.singlestore.com/forum/t/how-to-kill-the-sessions-which-are-in-sleep/1882)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 1\
**Last updated:** [April 28, 2020, 9:22pm UTC](https://www.singlestore.com/forum/t/how-to-kill-the-sessions-which-are-in-sleep/1882 "2020-04-28T21:22:20Z")

</div>

show processlist; command showing so many sessions as below. How to kill the sessions which are in sleep.

---

## [Who will use default\_pool & system\_auto resource pools usually](https://www.singlestore.com/forum/t/who-will-use-default-pool-system-auto-resource-pools-usually/1851)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 1\
**Last updated:** [April 20, 2020, 5:27pm UTC](https://www.singlestore.com/forum/t/who-will-use-default-pool-system-auto-resource-pools-usually/1851 "2020-04-20T17:27:08Z")

</div>

I have created resource pools as below. Please let me know the users who assigned to default\_pool & system\_auto will use how much cpu and memory. Who will use default\_pool & system\_auto resource pools usually?

---

## [Best practicess and optimistic values need to keep in order to avoid memory related errors and unexpected cluster outage](https://www.singlestore.com/forum/t/best-practicess-and-optimistic-values-need-to-keep-in-order-to-avoid-memory-related-errors-and-unexpected-cluster-outage/1790)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 4\
**Last updated:** [April 13, 2020, 3:50pm UTC](https://www.singlestore.com/forum/t/best-practicess-and-optimistic-values-need-to-keep-in-order-to-avoid-memory-related-errors-and-unexpected-cluster-outage/1790 "2020-04-13T15:50:55Z")

</div>

Guid me the best practicess and allocation of memeory percentage for below things out of total cluster memory(eg:-If we have leaf nodes. Each leaf node has 64GB ram and 16 cpus. Total Cluster RAM is 128GB and Total Clu…

---

## [What is using all my memory?](https://www.singlestore.com/forum/t/what-is-using-all-my-memory/1171)

<div class="topic-metadata">

**Author:** [@scott](https://www.singlestore.com/forum/u/scott)\
**Replies:** 5\
**Last updated:** [August 29, 2019, 5:35pm UTC](https://www.singlestore.com/forum/t/what-is-using-all-my-memory/1171 "2019-08-29T17:35:30Z")

</div>

Hi, I’ve having some stability issues with our MemSQL cluster. I think it is running out of RAM. In MemSQL studio, when I look at the nodes, the leaf is using 44GB (out of 69GB). We only have one lead. However, when I l…

---

## [Looking for tables that show the query info I get from Ops \> Explore \> Query](https://www.singlestore.com/forum/t/looking-for-tables-that-show-the-query-info-i-get-from-ops-explore-query/78)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 0\
**Last updated:** [October 2, 2018, 9:42pm UTC](https://www.singlestore.com/forum/t/looking-for-tables-that-show-the-query-info-i-get-from-ops-explore-query/78 "2018-10-02T21:42:38Z")

</div>

(Ported from memsql-public-chat Slack channel) David Johnson \[10:43 AM\] @alec, @seth. Question: when I go to memsqlOps \> Explore \> Query. I’m able to see query performance and active long running queries. What table or…

---

## [Need sql query plan usage stats](https://www.singlestore.com/forum/t/need-sql-query-plan-usage-stats/75)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 0\
**Last updated:** [October 2, 2018, 8:39pm UTC](https://www.singlestore.com/forum/t/need-sql-query-plan-usage-stats/75 "2018-10-02T20:39:19Z")

</div>

(Ported from memsql-public-chat Slack channel) reywang \[4:54 PM\] how to check sql query plan - which show parallelism, active cores (CPU) usages? seth \[8:23 PM\] @reywang EXPLAIN and PROFILE / SHOW PROFILE. Please re…
