Mysql Learning Notes (1-installation introduction)

How to install mysql:

(1) through the default version provided by the system (rpm package, stable version, which meets the requirements for use, it is recommended to use os vendor)

(2) officially provided by mysql

Official general rpm installation package

General binary format package (download the file directly, extract it to the specified directory, and start it)

Source package compilation and installation

Use cmake installation method after mysql5.6 version

Process: cmake. (generate configuration file using cmake)-- > make-- > make install

Data files for MySQL: files and logs

Files: data files and index files

Logs: transaction log, binary log, query log, slow query log, error log, relay log

Server variable for MySQL:

SHOW {GLOBAL | SESSION} VARIABLES [LIKE CLAUSE]

Status variable of MySQL:

SHOW {GLOBAL | SESSION} STATUS [LIKE CLAUSE]