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.