preface

The job hunting season is approaching, and there are thousands of skills, but hard power is the key. I heard that this year’s pandemic environment is not good, so we should prepare well. MySQL is a Java programmer for advanced skills, many friends often here in the interview failure, hate. Proficient in the knowledge of MySQL, with strong operability in practice, especially in the Internet industry, not only to write good code, achieve functions, but also in the case of high concurrency can operate normally.

So xiaobian today to share with you this “MySQL Notes” document, this document will be from the basis of the article, performance optimization, architecture design, these three parts to explain to you, at the same time, I hope you brother friends have some effect, also hope you will like it! Finally, if you need this handy MySQL Notes document, you can get it for free by clicking “like” and following the official account “Java Doudi”

Let’s look at the MySQL directory:

Since this note is made by hand, there is no cover to share with everyone. It is a pity that such an excellent document does not have a cover.

! [](https://pic4.zhimg.com/80/v2-ad63cbb122c673d3149991d568bc5266_720w.jpeg)

! [](https://pic1.zhimg.com/80/v2-e5de5fe8257ed0a7c0656f46808fd10f_720w.jpeg)

The main content

This “MySQL Notes” is mainly divided into three parts: basic, performance optimization, architecture design; So next, xiaobian on each carefully unfolded in detail for you to explain the knowledge point of this book! Just need to follow + click “like” to follow the public account [Java Doudi] can be free ~

First, the foundation

As one of the most popular open source database software, MySQL database software has been widely known. But for the benefit of readers who are not familiar with MySQL, this chapter will give a brief introduction to MySQL. The main content includes the composition of each function module of MySQL, the working principle of each module, the flow of Query processing, etc.

Chapter 1: Introduction to MySQL

  1. Introduction of MysQLServer
  2. A simple comparison of MySQL to other databases
  3. The main application scenarios of MySQ
  4. summary
! [](https://pic2.zhimg.com/80/v2-930337159bbb7b460e2775a958d392ea_720w.jpeg)

Chapter 2: MySQL architecture composition

  1. MySQL physical file composition
  2. MySQLServer system architecture
  3. This section describes how to use the MySQL built-in tools
  4. summary
! [](https://pic3.zhimg.com/80/v2-109a276b5ef3e612dc46df4bba6770fb_720w.jpeg)

Chapter 3: Introduction to the MySQL storage engine

  1. MySQL Storage Engine Overview
  2. MyISAM Storage Engine Introduction
  3. Introduction to Innodb Storage Engine
  4. Introduction to NDECluster storage engine
  5. This section describes other storage engines
  6. summary
! [](https://pic4.zhimg.com/80/v2-4d463f2831e8272d79c1fe8f1bcae380_720w.jpeg)

Chapter 4: MySQL security Management

  1. Database system security related factors
  2. MySQL Permission system introduction
  3. MySQL access authorization policy
  4. Precautions for security Settings
  5. summary
! [](https://pic1.zhimg.com/80/v2-bb1fdbe9af2b50d0dca8fe7a9e4652b4_720w.jpeg)

Chapter 5: MySQL backup and Restore

  1. Database backup scenarios
  2. Logical backup and restore tests
  3. Physical backup and recovery
  4. Backup policy design roadmap
  5. summary
! [](https://pic4.zhimg.com/80/v2-2cbfafbd02970c82b72f1519773c6101_720w.jpeg)

Second, performance optimization

Chapter 6: Factors that affect MySQLServer performance

  1. Impact of business requirements on performance
  2. Impact of system architecture and implementation on performance
  3. Impact of Queryi statements on system performance
  4. Impact of Schema design on system performance
  5. The impact of the hardware environment on system performance
  6. summary
! [](https://pic4.zhimg.com/80/v2-579c4f4cc2ed6b226bf1411217576ed8_720w.jpeg)

Chapter 7: MySQL database locking mechanism

  1. Introduction to the MySQL locking mechanism
  2. Analysis of various locking mechanisms
  3. Use lock mechanism to optimize MySQL
  4. summary
! [](https://pic2.zhimg.com/80/v2-4a2674f2528a1ed28e7c6c8fc36a1515_720w.jpeg)

Chapter 8: MySQL database Query optimization

  1. Understand MySQL’s QueryOptimizer
  2. Queryi language division optimization of basic ideas and principles
  3. Take advantage of Explain and Profiling
  4. Design and use indexes wisely
  5. The realization principle and optimization idea of Joir
  6. ORDERBY: GROUPBY and DISTIHCT optimization
  7. summary
! [](https://pic4.zhimg.com/80/v2-7ddd153d516ea691b666fbaa74db7741_720w.jpeg)

Chapter 9: Performance optimization of MySQL database Schema design

  1. Efficient model design
  2. Appropriate data type
  3. Canonical object naming
  4. summary
! [](https://pic2.zhimg.com/80/v2-27cca0d9116997b91d3a2d6645f2d0b9_720w.jpeg)

Chapter 10: MySQLServer performance tuning

  1. MySQL Installation optimization
  2. MySQL log Settings optimized
  3. QueryCache optimization
  4. Other common optimizations for MySQLServer
  5. summary
! [](https://pic2.zhimg.com/80/v2-f1a3b9c0a38a2192a446dc5bcd3f6bcc_720w.jpeg)

Chapter 11: Common storage engine optimization

  1. MyISAM storage engine optimization
  2. Innodb storage engine optimization
  3. Innodb cache related optimizations
  4. Transaction optimization
  5. Data Storage Optimization
  6. Innodb other optimizations
  7. Innodb performance monitoring
! [](https://pic3.zhimg.com/80/v2-4c56186037ea99fcb4c04a207bfd73db_720w.jpeg)

Iii. Architecture Design

Chapter 12: Basic principles of MySQL extensible design

  1. What is scalability
  2. The transaction correlation minimization principle
  3. The principle of consistency of instruction
  4. High availability and data security principles
  5. summary
! [](https://pic2.zhimg.com/80/v2-878a4422c57b9dce6c0f964065ebd450_720w.jpeg)

Chapter 13: MySQLReplication for extensible design

  1. What Replication means for scalable design
  2. How Replication works
  3. Replication implementation level
  4. Replication Common architecture
  5. Repli cati on Build implementation
  6. summary
! [](https://pic2.zhimg.com/80/v2-3325acc3e7a4844c194885ccbd92eaa3_720w.jpeg)

Chapter 14: Data sharding for Scalable design

  1. What is data sharding
  2. Vertical segmentation of data
  3. Horizontal segmentation of data
  4. Use of vertical and horizontal joint segmentation
  5. Data segmentation and integration solutions
  6. Possible problems in data segmentation and integration
  7. summary
! [](https://pic2.zhimg.com/80/v2-24d1e7bf761ea4d2908166e7d3cd0526_720w.jpeg)

Chapter 15: Utilization of Cache and Search in scalable design

  1. Extensible design extends beyond the database
  2. Properly utilize third-party Cache solutions
  3. Implement the Cache service by itself
  4. Use Search to realize efficient full-text retrieval
  5. Using distributed parallel computing to realize high performance operation of large data volume
  6. summary
! [](https://pic2.zhimg.com/80/v2-c7b9520e8b9ca97a93f4f7e72d187763_720w.jpeg)

Chapter 16: MySQLCluster

  1. MySQLCluster introduction
  2. The MySQLCluster environment is built
  3. MySQLCluster configuration details (config.ini)
  4. MySQLCluster basic management and maintenance
  5. Basic optimization idea
  6. summary
! [](https://pic3.zhimg.com/80/v2-29159f70c9f5053ffa7769cdeb99649e_720w.jpeg)

Chapter 17: High availability design ideas and solutions

  1. Leverage Replication to implement a highly available architecture
  2. Use MySQLCluster to achieve overall high availability
  3. Using DRED to ensure high safety and reliability of data
  4. Other high availability design solutions
  5. Comparing the pros and cons of various high availability solutions
  6. summary
! [](https://pic4.zhimg.com/80/v2-f2016912a8954f6a05e22ebffd8d56e0_720w.jpeg)

Chapter 18: MySQL monitoring for high availability design

  1. Design of monitoring system
  2. Performance status Monitoring
  3. summary
! [](https://pic3.zhimg.com/80/v2-76c061356e06d4ea00a027ae6c793e1a_720w.jpeg)

access

MySQL notes MySQL Notes MySQL Notes MySQL Notes

Three things to watch ❤️

If you find this article helpful, I’d like to invite you to do three small favors for me:

  1. Like, forward, have your “like and comment”, is the motivation of my creation.
  2. Follow the public account “Java Doudi” to share original knowledge from time to time.
  3. Also look forward to the follow-up article ing🚀