[MySQL] related to system parameter settings

Summary]

Describes how to adjust parameters of database servers and precautions

 

[Glossary]

1. parameter scope (VaR Scope

): Local, session, global reference Link

The global parameter is valid for all sessions.

After the session parameter is modified, it only takes effect for the currently created session.

Subsequent sessions are invalid.

 

2. Dynamic Parameters (Dynamic): a list of parameters that can be modified at runtime.

After modification, the modification takes effect without restarting.

 

[How to set]

1. runtime: You can directly use the following command to modify parameters that can be dynamically modified:

Example:

Set sort_buffer_size = 10000; <br/> set @ local. sort_buffer_size = 10000; <br/> set global sort_buffer_size = 1000000, session sort_buffer_size = 1000000; <br/> set @ sort_buffer_size = 1000000; <br/> set @ Global. sort_buffer_size = 1000000, @ local. sort_buffer_size = 1000000;

Reference

 

2. Permanent Configuration:

Add the my. CNF configuration file.