The open-source MySQL has supported performance_schema (hereinafter referred to as PFS) since 5.5. After continuous improvement and optimization in subsequent versions, PFS has become very powerful for performance diagnosis and optimization, so that SQL problems and lock waiting events can be displayed clearly. However, it incurs certain performance costs to enable PFS. This article compares PFS and other tools and the performance differences between scenarios where PFS is enabled and disabled.
First of all, PFS provides more features as a built-in problem diagnosis and analysis tool. DAS is an external tool. If you want to analyze it in detail, you can open the audit log and enable DAS as needed.
After the CPU reaches the bottleneck, take the average value of the performance with the concurrency level of 32. The performance differences under other concurrency levels are shown in the following table.
After PFS is enabled, the memory applied by PFS will not be released. The memory usage increases by 5%. It is estimated that memory usage will increase more in complex scenarios.
Alibaba Cloud ApsaraDB RDS for MySQL has developed Performance Insight, a tool for instance load monitoring, association analysis, and performance tuning. For more information, please see the documentation below: https://www.alibabacloud.com/help/en/doc-detail/132200.html
Alibaba Clouder - February 13, 2019
Alibaba Clouder - July 1, 2019
Alibaba Clouder - September 10, 2018
Apache Flink Community China - September 16, 2020
Alibaba Developer - June 19, 2020
Alibaba Cloud New Products - June 1, 2020
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An on-demand database hosting service for MySQL, SQL Server and PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
Fully managed and less trouble database servicesLearn More
More Posts by ApsaraDB