MySQL Learning notes-outline

Software program performance testing in the previous "taste performance of the Road" series has been extensively mentioned, explained a lot of testing methods, testing concepts, testing ideas and so on. Get ready to dive into MySQL to learn and summarize recently. Check out MySQL performance tuning and architecture design, MySQL high performance book, MySQL Insider InnoDB, and the official MySQL Manual, focusing on structural principles and various performance tuning techniques. The approximate plan is the architecture, transaction and transaction isolation mechanism, lock mechanism and deadlock, paradigm and inverse paradigm, performance tuning. MySQL Architecture

Background thread

Memory structure

File structure

Storage Engine

Introduction to Basic user Tools

Mysql

Mysqladmin

Mysqldump

Show

MySQL Benchmark Test

Test definition:

Test Purpose:

Test strategy:

Test method:

Test tools:

1 ,

2 ,

3 ,

4 ,

Performance Status Monitoring

Transactions&Lock

Transaction characteristics

Isolation level

transaction Logs and Cache Write

Performance Optimization

Introduction to Performance optimization

Schema design optimization with data type

Installation optimization

Server Settings optimization

Log Settings optimization

Index optimization

Query cache

Query optimization

Storage Engine Optimization

Architecture Design principles and optimization

From for notes (Wiz)

MySQL Learning notes-outline