Shulou(Shulou.com)06/01 Report--

This article mainly introduces the mysql source code example analysis, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql's memory management is large and advanced, as described in the comments at the beginning of the mem0pool.c file, which can be roughly divided into four parts, including nine large blocks:

Nine pieces:

Buffer pool,parsed andoptimized SQL statements,data dictionarycache,log buffer,locks for eachtransaction,hash table forthe adaptive index,state andbuffers foreach SQL query currently being executed,session foreach user, andstack for eachOS thread.

9 chunks are managed by 4 parts

A solution tothe memory management:1. The bufferpool size is set separately;2. Log buffersize is set separately;3. The commonpool size for all the other entries, except 8, is set separately.

That is, buffer pool, redo log buffer, regular pool and 8 (user session information, which can be seen as part of it)

The redo log buffer is managed separately by the redo part, and the bufferpool, that is, the buffer pool, is a complex part with a lot of content, as mentioned above, except for 8, and 1, and 2. He's in charge of the rest.

MySQL is developed with C++.

Source code download is available on MySQL's official website http://www.mysql.com/, which belongs to C++.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the analysis of mysql source code examples. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.