Intel oneAPI tools facilitate significant performance improvement of TencentDB for MySQL
September 1, 2022 — Intel today announced that Tencent’s database hosting service, TencentDB for MySQL, provides performance increases of up to 85% using Intel oneAPI tools.
Tencent has significantly improved the performance of its database hosting service, TencentDB for MySQL. Based on the MySQL open-source relational database management system and built on Intel Xeon processors, TencentDB for MySQL has increased its performance by using the advanced Intel oneAPI DPC++/C++ compiler and Intel VTune profiler (part of the Intel oneAPI Base toolkit).
“Tencent’s results optimizing MySQL demonstrate the importance of using both up-to-date development tools like the Intel oneAPI DPC++/C++ compiler and the latest optimization techniques using the Intel VTune profiler,” said Joe Curley, Vice President of Intel and General Manager of Software. Products and ecosystem. “The significant performance improvements either deliver faster results or more results for business-critical applications.”
Distributed data storage plays a critical role in every industry and every use case, including the internet, finance, and e-commerce. Solutions like TencentDB for MySQL provide developers with a distributed data storage service that makes it easy to set up, operate, and expand relational databases in the cloud. However, a continuous increase in data storage and processing requirements and higher performance demands make it difficult for developers. Optimizing for higher MySQL performance can help organizations process data transactions and queries faster, helping to meet changing business and customer needs.
Intel is leading the open ecosystem by combining its unique strengths in hardware and software tools with a commitment to building robust, open software that accelerates computing and innovation. The Intel oneAPI DPC++/C++ compiler is used for parallel programming applications and delivers productivity and performance on processors and accelerators. Using the compiler, the teams piloted Binding Time Optimization (LTO) and Profile-Guided Optimization (PGO) methods that helped Tencent build high-performance MySQL. With LTO, the compiler applied various forms of intra-procedural optimization (IPO) to the entire program, allowing for deeper analysis, more optimization, and better program performance. PGO provides information to the compiler about which areas of an application are most frequently executed. Together, these techniques have improved the performance of TencentDB applications by up to 85%.
For more information, click here.