Out of Memory Quota!

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: Out Of Memory Quota!

| username: wzf0072

Executing SQL error: >1105 - Out Of Memory Quota!
The problem has been resolved, solution:
set @@tidb_allow_mpp=0;
SET GLOBAL tidb_server_memory_limit = “28GB”;
set global tidb_mem_oom_action=‘LOG’;
SET tidb_mem_quota_query = 24 << 30;

| username: CuteRay | Original post link

Could you please describe the problem more clearly? It’s difficult for everyone to handle it when it’s so vague and incomplete.
TiDB OOM Troubleshooting | PingCAP Documentation Center

| username: Billmay表妹 | Original post link

When describing the problem, please follow:
【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Problem Phenomenon and Impact】
【Reproduction Path】What operations were performed that led to the problem
【Resource Configuration】

Describe as much effective background information as possible. Many problems may have different suggestions under different scenarios and business contexts. If you don’t explain clearly, it will make it difficult for everyone to help.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.