The architecture of learning -5-20170523-mysql in mysql-optimization class

The architecture of learning -5-20170523-mysql in mysql-optimization class

MySQL is divided into three-storey structures

The last two are connections that can be used in Windows

Mysql-hlocalhost-uroot =socket Way
Mysql-h127.0.0.1-uroot =TCP/IP Way
Mysql-h192.168.1.1-uroot =TCP/IP Way

The connection is blocked:

Modify the configuration of the number of connections

Command:

SQL Layer:

Ability to open QC in a purely read-only environment to speed up query efficiency

Others do not suggest open QC,QC is different from Innodb_buffer_pool space

5.6 Before the default turn on QC is turned off

Can be closed online, but not effective---QC recommendations do not open

See how the error code is detailed:

Mysqlslap a small tool for pressure measurement

[MySQL]

[Client]

There are multiple sections inside MY.CNF.

Mysqld Startup options

--DEFAULTS-FILE=<FILE_NAME&GT: Use the options file at the specified location.
--defaults-extra-file=<file_name&gt: Use a different option file at the specified location.
--no-defaults: Ignores all options files.

The architecture of learning -5-20170523-mysql in mysql-optimization class