MySQL database optimization experience (common server configuration) page 1/3 _ MySQL-mysql tutorial

MySQL database optimization experience (common server configuration) 13th page bitsCN.com

After installing mysql, the preparation file should be in the/usr/local/mysql/share/mysql Directory. There are several preparation files, including my-huge. cnf my-medium.cnf my-large.cnf my-small.cnf, different traffic of the site and different preparation of the server environment, of course, need to have different preparation files.

Under normal circumstances, the preparation of the my-medium.cnf file can meet most of our needs; General we will copy the configuration file to/etc/my. cnf only needs to modify this configuration file. use mysqladmin variables extended-status