mysql-Data acquisition Process

Extracting data from disk

the parser resolves the SQL statement to the execution plan Execution Plan  1 ,    you must explicitly tell MySQL where the data is stored in which location  2,    We know that the real disk data dealing with the storage engine  3,    It also means that to increase the disk access to the data, you must explicitly tell the storage engine where the data is, how to fetch  4,    where the data is stored, and how to extract the data, which we call the execution plan.
Optimizer
Select the optimal execution plan query cache cache Execution Plan additional features: permissions, syntax, doctrine Check, object existence logging: binlog---record successfully executed statements

MySQL User management

MySQL-- user Management

MySQL Client commands

MySQL- Client Tools

Getting Started with SQL-Library definitions

Getting Started with SQL - library definitions

Getting Started with SQL-table definition

Getting Started with SQL-table definition

SQL Getting Started-dml-dql-character set

Getting Started with SQL-DML data Manipulation language- -insertinto SQL get started -DML Data Manipulation Language --Delete Getting Started with SQL-DQL data Query Language --get started withselectSQL - character Set

mysql-Data acquisition process