To make things easier for administrators.
-
Minimal memory, relatively infrequent MySQL usage: my-small.cnf
-
Minimal memory combined with reliance on MySQL, or larger memory for a multipurpose system: my-medium.cnf
-
Large memory server dedicated primarily to MySQL: my-large.cnf
-
Very large memory server completely dedicated to MySQL: my-huge.cnf
It's worth your time to review these files, if for no other
reason than to gain some ideas on the optimal ratios between the various server
settings.
-
Connectivity
-
Memory management
-
Application control
-
User resource control