> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning.md).

# Performance Tuning

Tuning GridGain 9 for throughput and latency: JVM, OS, persistence, data streaming, SQL, and memory.

Practical guidance for getting the most out of a GridGain 9 cluster. Work through the areas relevant to your workload — most deployments benefit from JVM and OS tuning first, then storage and query tuning as specific bottlenecks appear.

{% columns %}
{% column %}
{% content-ref url="/pages/7h3ibT0Ll4hbO1HmEJZT" %}
[General Performance Tips](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/general-performance-tips.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
General performance considerations for GridGain 9, including deployment practices, colocation, heap and metadata placement, partitioning, and efficient data access.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/J1yu8Q5794bZZmxOBiDl" %}
[JVM Tuning](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/jvm-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Recommended JVM options for GridGain 9, including heap sizing guidance, garbage collector tuning, thread pools, and NUMA-aware memory allocation.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/azBliWPo7ykN9mweL7tK" %}
[OS Tuning](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/os-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Operating system tuning for GridGain 9, including CPU power management, user limits, virtual memory, swappiness, RAM sharing, and advanced memory and I/O settings.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/aM7VHzK951jAXXjN7Dfi" %}
[Persistence Tuning](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/persistence-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Persistence tuning for GridGain 9, covering log and data separation, checkpointing and write throttling, SSD selection and over-provisioning, and MVCC considerations.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/nRdKRsva9mnS8KwRi97N" %}
[Data Streaming Tuning](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/data-streaming-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Tuning the GridGain 9 Data Streamer for stability and throughput under heavy load, including batching, timeout configuration, and streamer options.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/2U5nsTaOdrvViEyxaWi8" %}
[SQL Memory Management](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-memory-management.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to manage SQL query memory in GridGain 9 using node and query memory quotas and memory offloading to run large queries safely.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/T5gRNgxYuZP1g4xP2Arq" %}
[General Configuration Tips](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/general-configuration-tips.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Practical tips for configuring GridGain 9 cluster storage, local paths, heap usage, and server logging.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/i9xT8YdZB0Rn2sdL7pGB" %}
[SQL Tuning](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Techniques for analyzing and improving GridGain 9 SQL query performance, starting with the EXPLAIN command.
{% endcolumn %}
{% endcolumns %}