# Mitigate Tidb Server Oom

+ SQL optimization to reduce the amount of data return unnecessarily
+ Reduce big transaction and split big ones into smaller transaction
+ Adjust TiDB Server related parameters to limit the use of individual SQL memory
+ Other ways to mitigate TiDB Server OOM
------------------------------------------------------------
Measures to mitigate TiDB Server OOM

- SQL optimization 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 parameters, such as adjusting memory parameters that can be used by a single SQL, etc.
- Other ways to mitigate TiDB Server OOM, such as adjusting the GO memory release mechanism