The basic theory of MySQL series two-relational database

SQL query statement:

Sequel-->sql

SQL-86

SQl-89

SQL-92

SQL-99

SQL-03

SQL-08

Part of the SQL language:

Ddl

Dml

Integrity Definition Language: Part of the DDL feature

View definition

Things control:

Embedded SQL and dynamic sql:

Authorization: DCL

How to interact with RDBMS using the programming language:

Embedded SQL: Similar to dynamic SQL, but its statements must be fully determined at the time of program compilation.

Odbc

Dynamic SQL: Programming language uses functions to connect and interact with a database server

Jdbc

MySQL plug-in storage engine (default)

5.5.8:mylsam does not support things

After 5.5.8: InnoDB support Things

Table Manager: Responsible for creating, reading, or modifying a table definition file: Maintaining table Descriptor cache: Managing Table Locks

Table structure definition file

Table Modification Modules: Table creation, delete, rename, remove, update or insert operations

Table Maintenance Module: Check, modify, backup, restore, optimize (defragment) and parse:

Line: fixed length, variable length

Record organization in file:

Heap file organization: A record can be placed anywhere in the file:

Sequential file organization: stored according to the "Search Code" value order:

Hash file organization:

Table structure definition file: Table data file

Tablespace: Table Space

Data dictionary: Date dictonary

Metadata for relationships

The name of the relationship

Field name

Type and length of the field

View

Constraints

User password, authorization, password

Buffer Manager

Cache substitution Policy

The block being pegged

This article from "Operation and maintenance Growth Road" blog, declined reprint!

The basic theory of MySQL series two-relational database