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

Preface

In recent years, open source databases have become more and more popular. Due to the advantages of free use, simple configuration, good stability and excellent performance, open source database occupies a large market share in middle and low-end applications, and MySQL is an outstanding representative of open source database.

MySQL database belongs to MySQL AB company and is headquartered in Sweden. The "AB" in the company name is the acronym for "aktiebolag" or "joint-stock company" in Swedish. MySQL supports almost all operating systems and supports large tables (the maximum table size supported by the MyISAM storage engine is 65536TB). These features make MySQL develop rapidly and have been widely used in various industries.

This is an in-depth MySQL document compiled by a BATJ architect, which is divided into 4 parts and 31 chapters.

The four parts are basic part, development part, optimization part and management and maintenance part.

The details of the 31 chapters are as follows:

Part 1 fundamentals

Chapter 1 installation and configuration of MySQL

Chapter 2 SQL fundamentals

Chapter 3 data types supported by MySQL

Chapter 4 operators in MySQL

Chapter 5 Common functions

Chapter 6 use of graphical tools

Partial knowledge node

Part 2 Development

Chapter 7 selection of Table types (Storage engine)

Chapter 8 selecting the appropriate data type

Chapter 9 character set

Chapter 10 Design and use of Index

Chapter 11 View

Chapter 12 stored procedures and functions

Chapter 13 trigger

Chapter 14 transaction control and locking statements

Chapter 15 Security issues in SQL

Chapter 16 SQL Mode and related issues

Partial knowledge node

Part 3 Optimization

Chapter 17 commonly used SQL techniques and FAQ

Chapter 18 SQL Optimization

Chapter 19 optimizing database objects

Chapter 20 Lock problem

Chapter 21 optimizing MySQL Server

Chapter 22 disk Ihop O problem

Chapter 23 Application Optimization

Partial knowledge node

Part 4 Management and maintenance

Chapter 24 MySQL Advanced installation and upgrade

Chapter 25 Common tools in MySQL

Chapter 26 MySQL Lo

Chapter 27 backup and recovery

Chapter 28 MySQL permissions and Security

Chapter 29 MySQL replication

Chapter 30 MySQL Cluster

Chapter 31 frequently asked questions and Application skills of MySQL

Partial knowledge node

Part of the screenshot

Part of the screenshot

Method of data:

Free study materials and interview materials can be obtained by https://shimo.im/docs/q8vHRWa3nqgfuH4B/.

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.