Shulou(Shulou.com)05/31 Report--

This article will explain in detail the impact on the performance of session. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

During session processing, it is not easy to detect the performance impact. -- the undercurrent surging in the background, falling into flush dirty.

When there is a large amount of business data and frequent changes, and the free list in the db buffer can no longer meet the page requirements of the session, the session will perform single page flush.

So we should try our best to ensure adequate free list, and batch cleaning should be more efficient.

1. Control the amount of business data. When it is too large, it should be split to reduce the data amount of a single instance.

two。 Increase the throughput of each brush and increase the innodb_io_capacity_max.

3. Increase the depth of scanning LRU and enlarge innodb_lru_scan_depth to prevent user threads from doing single page flush

4. System version upgrade, 5.6 independent flush thread, 5.7 also increased the concurrency of flush.

This is the end of this article on "what is the impact of session performance?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.