Some basic points of MySQL (whichever is mysql5.5 later)

Logical Structure of the 1.mysql:

• Tier One: Service layer (for Client services, request connection processing, authorization authentication, security)
• Second tier: Core layer (query parsing, parsing, optimization, caching, providing built-in functions, stored procedures, views)
• Third tier: Storage engine layer (do access data)

2. Concurrency control: Table Lock,page lock,row LOCK/MVCC

3. Business

4.4 Levels of Isolation:

READ UNCOMMITTED (read not submitted)
Read Committed (Submit read)
REPEATABLE READ (REPEATABLE Read)
Serializable (Serializable)

5. Storage Engine

6. Authentication and permissions (grant [Permissions] on [*. * or dbname.*] to ' user ' @ ' IP or hostname ' identified by ' password ' [with grant options]

　　　　　　

　　　　

Some basic points of MySQL (whichever is mysql5.5 later)