Your query has been cancelled due to exceeding the allowed memory limit for a single SQL query. Please try narrowing your query scope or increase the tidb_mem_quota_query limit and try again.[conn=3607482257570389131]

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

Original topic: Your query has been cancelled due to exceeding the allowed memory limit for a single SQL query. Please try narrowing your query scope or increase the tidb_mem_quota_query limit and try again.[conn=3607482257570389131]

| username: TiDBer_hUfk8uMB

In Navicat, setting SET GLOBAL tidb_mem_quota_query = 8G is not effective. What other configurations are needed? Please advise.

| username: Kongdom | Original post link

Is it because of the scope? Global does not take effect for the current connection.