iQIYI Optimizes the Performance of MySQL Database

Intel® Optane™ PMem addressed the increased latency and reduced performance of MySQL for high read I/O scenarios.

At a glance:

  • As an innovative company with both technology and entertainment genes, iQIYI leverages innovative technologies to empower entertainment and reduce entertainment costs.

  • iQIYI partnered with Intel and adopted their large-capacity, low-latency Intel® Optane™ persistent memory and Storage Performance Development Kit, which addressed the increased latency and reduced performance of MySQL for high read I/O scenarios and improved the user experience.

author-image

By

Executive Summary

iQIYI’s database team used to adopt SSDs as the storage device to solve the troubles caused to MySQL by I/O bottlenecks. This, however, did not offer an effective solution to the latency problem. Because the database server implements both sequential and random I/O concurrent, and most of the hotspot data is scattered randomly, which must be buffered in memory to eliminate I/O bottlenecks.

With this in mind, iQIYI worked with Intel to adopt Intel® Optane™ persistent memory as the storage medium for the buffer pool. The optimized database engine solution has two parts. In the one part, the memory carries the index data. In the other part, the persistent memory stores massive data as a cache and provides a place for the read data to interact with the memory. This helps to save I/O overhead, thereby greatly improving the performance of MySQL.

Read “Intel Helps iQIYI Optimize the Performance of MySQL Database Engines to Improve Customer Experience” ›