# Mitigating TiDB Server OOM Measures

+ SQL tuning to reduce the amount of data return unnecessarily
+ Reduce big transaction and split big ones into smaller transaction
+ Adjust the TiDB Server relevant parameter to limitation the SQL use of a single memory
+ Other TiDB Server OOM ways to mitigate

-------------------------------------------------------------

 Measures to mitigate TiDB Server OOM
 - SQL tuning to reduce the amount of data return unnecessarily 
    - SQL business logic optimization to confirm whether the amount of data returned from the database to the client is reasonable
    - SQL execution plan optimization to confirm the accuracy of the SQL execution plan, such as whether there is an unnecessary full table scan, and whether the table association is reasonable
  - Reduce big transaction and split big ones into smaller transaction
  - Adjust TiDB Server parameter, such as adjusting memory parameter that can be used by a single SQL, etc.
  - Other ways to mitigate TiDB Server OOM, such as adjusting the GO memory release mechanism