High Performance MySQL Chapter 6th

6th, optimize the configuration https://www.cnblogs.com/musings/p/5913157.html

1: The server reads the configuration file, which can be queried using the following command

Admin@iZwz92c0zpe8t65qe996ckZ:~$ which mysqld/usr/sbin/ Mysqld

Using the MYSQLD query configuration

 root @iZwz92c0zpe8t65qe996ckZ : / Home/ admin# / usr / sbin/ mysqld -- verbose--help | grep-a 1 ' Default options '  default  options are read  from  the following files in  the given order  :  / etc/ my.cnf / etc/ MySQL / my.cnf ~/. My.cnf 

Then in the/etc/mysql/my.cnf MySQL configuration, will not read the MySQL server
2: Configuration settings are lowercase, can be used-or _ is the same, for example, the following is the same

Root@iZwz92c0zpe8t65qe996ckZ:/Home//usr/sbin/-- auto-increment-offset=1root@iZwz92c0zpe8t65qe996ckZ:/Home// usr/sbin/--auto_increment_offset=1

3: Configuration

Table_cache_size  -  the (how much) size of the cache table to be valid until the next thread opens the table

MySQL optimized configuration

Https://www.cnblogs.com/thrillerz/p/3907421.html https://www.cnblogs.com/musings/p/5913157.html

High Performance MySQL Chapter 6th