Database Tuning Tutorial Summary

Some time ago to help the company to optimize the database, with the previous study, step by step to learn knowledge for practice, finally is the speed of rubbing up, a query originally to execute more than 1 minutes now only need 3 seconds.

These two weeks to summarize what they have learned and use, published a series of articles on the database, on the one hand to consolidate knowledge for themselves, on the other hand to the majority of students with a little reference.

This series of articles are now summarized for easy access.

This set of tutorials is a total of 13 speaking.

In this series of tutorials, you will learn

1. How to optimize a database step-by-step

2. How to bring the role of the index to the fullest

3. How to troubleshoot MySQL not using the index in the case of like '%xxx% ' fuzzy queries

4. How to design a high-quality table

5. How to write high-quality SQL statements

6. Other methods of database optimization

The following is an outline of this series of tutorials

Database Tuning Tutorial (i) preface & slow query definition

http://blog.csdn.net/hzy38324/article/details/44903207

Database Tuning Tutorial (ii) Slow query data preparation

http://blog.csdn.net/hzy38324/article/details/44917119

Database Tuning Tutorial (iii) record slow query

http://blog.csdn.net/hzy38324/article/details/44917241

Database Tuning Tutorial (iv) Explain performance analysis commands

http://blog.csdn.net/hzy38324/article/details/44921299

Database Tuning Tutorials (v) The role of indexes and the types of indexes

http://blog.csdn.net/hzy38324/article/details/44922651

Database tuning Tutorial (vi) related operations for indexes

http://blog.csdn.net/hzy38324/article/details/44937625

Database Tuning Tutorial (vii) The cost of indexing

http://blog.csdn.net/hzy38324/article/details/44942891

Database Tuning Tutorials (eight) What happens when you don't use the index

http://blog.csdn.net/hzy38324/article/details/44962055

Database Tuning Tutorial (ix) Several common possibilities for adding an index but not being used

http://blog.csdn.net/hzy38324/article/details/44962407

Database Tuning Tutorial (10) 4 ways to resolve the index not being used when you like '%str '

http://blog.csdn.net/hzy38324/article/details/44975859

Database Tuning Tutorial (11) Design a beautiful table

http://blog.csdn.net/hzy38324/article/details/44992649

Database Tuning Tutorial (12) Optimizing SQL statements

http://blog.csdn.net/hzy38324/article/details/44992759

Database Tuning Tutorial (13) MySQL database other optimization methods

http://blog.csdn.net/hzy38324/article/details/44994177

About the database article published to this, but the pace of learning database will not stop, welcome to the vast number of software development enthusiasts, experts, great God and Javdroider exchange!! Share!! Co-learning!!! Total progress!!!!

Database Tuning Tutorial Summary