Splunk Cloud

Search Manual

Acrobat logo Download manual as PDF

Acrobat logo Download topic as PDF

Memory and stats search performance

A pair of limits.conf settings strike a balance between the performance of the stats family of search commands and the amount of memory they use during the search process, in RAM and on disk. If your stats, sistats, geostats, tstats, or mstats searches are consistently slow to complete, you can adjust these settings to improve their performance, but at the cost of increased search-time memory usage, which can lead to search failures.

When you run a stats search, the search head returns batches of results until the search result set is complete. The max_mem_usage_mb setting in the [default] stanza of limits.conf limits the amount of memory (RAM) that a batch of search results can take up during the stats search process. Its default setting is 200 MB. Lower limits to max_mem_usage_mb can cause a search to be slower to complete, but there should be no loss of results.

The stats command processor spills data from RAM to disk when the amount of RAM that the batch is estimated to use exceeds max_mem_usage_mb. Do not set max_mem_usage_mb=0 as this removes the bounds to the amount of memory a batch can use.

If you run a lot of high cardinality stats searches (searches that must match, filter, and aggregate extremely large numbers of discrete field values), consider reducing max_keymap_rows to improve their performance. This setting in the [stats | sistats] stanza of limits.conf limits the number of result rows that the stats search processor can store in the key map during the mapping phase of the map-reduce operation in a stats search. The stats search processor stores expunged result rows in memory, subject to the max_mem_usage_mb setting.

The eventstats and streamstats commands also use these settings, but in a slightly different way.

For more information, see the topics for eventstats and streamstats in the Search Reference.

Prerequisites

Never change or copy the configuration files in the default directory. The files in the default directory must remain intact and in their original location. Make changes to the files in the local directory.

If you are using Splunk Cloud and want to change either of these limits, file a Support ticket.

Last modified on 23 September, 2020
PREVIOUS
Add sparklines to search results
  NEXT
About advanced statistics

This documentation applies to the following versions of Splunk Cloud: 8.1.2009, 8.1.2011


Was this documentation topic helpful?

You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters