MySQL's architecture model

See Daniel User db architecture Keithlan" Database performance Optimization query optimization ", in the learning process found a lot of good things, save it and share it to everyone, because the author said a very classic words: "If you want To go fast,go alone; If you want to GA far,go together! ", hehe, I hope everyone will share and progress together. Let's talk about the MySQL architecture model, hoping to get more students to understand the process from initiating a request---> Processing a request---> returning a result

The following is a Marco teacher to everyone to draw a MySQL model, Marco is a very strong teacher, his website is http://www.magedu.com/, there are many free and very good video, interested students can go to see

Table Manager: Responsible for creating, reading, or modifying table definition files, maintaining table descriptor caches, managing table locks, table structure definition files

Table modification Modules: Operations such as table creation, deletion, renaming, removal, updating, or inserting; Table maintenance Modules: Inspection, modification, backup, recovery, optimization (defragmentation) and parsing;

Hope that these can give beginners a friend to bring help, if you want to delve into the whole process of request processing, see your own efforts!! ^0^

MySQL's architecture model