stay Web In the application architecture , Data persistence layer （ It's usually a relational database ） It's the key core part , It has a very important impact on the performance of the system .
MySQL Is currently the most used open source database , however MySQL The performance of the default database settings is very poor , It's just a toy database . So use... In the product MySQL The database must be optimized as necessary .
Optimization is a complex task , Include MySQL Related database design and query optimization 、 server_side_optimization_ 、 Storage engine optimization and so on .
Recently, many friends asked me for some mysql Relevant information , So I rummaged through my suitcases , Found this very classic e-book ——《 High performance MySQL》.
《 High performance MySQL》 Content covered MySQL Architecture and history , Benchmarking and performance profiling , Database software and hardware performance optimization , Copy 、 Backup and recovery , High availability and high scalability , And the cloud MySQL and MySQL Relevant tools, etc . Each chapter is a relatively independent theme , Readers can selectively read alone . This book is not only suitable for database administrators to read , It is also suitable for developers to learn by reference . Whether it's a database novice or an expert , I believe we can get something from it .
How to get ？
1. Identify two-dimensional code and pay attention to official account 「Java Back end technology stack 」;
2. Reply key in background of official account 「939」.