MySQL Plan Cache Optimization

Application scenario: MySQL read-only OLTP

Technical principle: Optimized SQL statements with the same syntax reuse an execution plan in a session to reduce the optimizer overhead and improve the system query performance.

Performance metric: The performance can be improved by 10% in sysbench read-only test scenarios.

Figure 1 Performance comparison