Reprint--A variety of logical map groups for easy understanding of MySQL Insider

Original address: http://blog.sina.com.cn/s/blog_445e807b0101ggtl.html

1, top-of-the-shelf official MySQL frame composition, understanding MySQL whole organization is essential

2, more intuitive MySQL overall logical organization diagram:

3,INNODB engine architecture diagram for understanding the internal structure of InnoDB

4,mysql SQL execution is a great help in understanding MySQL execution plan

5, when the ' Innodb_flush_log_at_trx_commit = X ' x=0,1,2 Each value of the brush disk

6,mysql memory allocation, which is very useful for understanding memory allocation

7,mysql Master-slave replication

8,mysql5.5 after the new semi-synchronous function, the following is the semi-synchronous process

9,replication Booster

10,sql various connection execution result sets

11,innobackupex Backup principle

12, data type