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

This article mainly explains the "MySQL database high performance optimization", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "MySQL database high performance optimization" bar!

Check common tools for problems:

Tools that are not commonly used but easy to use:

General ideas for emergency tuning:

In view of the sudden business to deal with stutter, can not carry out normal business processing! The scene that needs to be solved immediately!

1. Show processlist # # get the current connection session status 2, explain select id,name from stu where name='clsn'; # ALL id name age sexselect id,name from stu where id=2-1 function result set > 30 show index from table;3, judge by the execution plan, the index problem (whether it is reasonable or not) or the statement itself problem 4. Show status like'% lock%'; # query lock status kill SESSION_ID; # kill the problematic session

Conventional tuning ideas:

1. Check the slowlog, analyze the slowlog, and analyze the statements that are slow to query. 2. Check all slow sentences one by one according to a certain priority. 3. Analyze top sql, debug explain, and check the execution time of the statement. 4. Adjust the index or the statement itself.

For business cyclical Catton, for example, business is particularly slow at 10-11:00 every day, but it can still be used, and it will be fine after this period of time.

Thank you for reading, the above is the content of "High performance Optimization of MySQL Database". After the study of this article, I believe you have a deeper understanding of the problem of high performance optimization of MySQL database, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.