oneAPI tools improve performance of TencentDB for MySQL
Tencent, the leading public cloud service provider in China, improves the performance of TencentDB for MySQL by up to 85% using Intel oneAPI tools.
SANTA CLARA, California, September 01, 2022–(BUSINESS WIRE)–What’s new: 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 core Intel® oneAPI Toolkit).
This press release is multimedia. See the full version here: https://www.businesswire.com/news/home/20220901005271/en/
Tencent, the leading public cloud service provider in China, improves the performance of TencentDB for MySQL by up to 85% using Intel oneAPI tools. (Graphic: Business Wire)
“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. The significant performance improvements give either faster results or more results for critical applications.”
– Joe Curley, Intel Vice President and General Manager of Software Products and Ecosystem
Why is this important: 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.
How it works: 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 provides 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%.1.
Intel® VTune™ Profiler was used to collect MySQL performance based on the default configuration and to identify and analyze hot spots in call stacks to find additional areas to optimize performance.
More context: Intel and TencentDB for MySQL Case Study
Intel (Nasdaq: INTC) is an industry leader, creating breakthrough technology that enables global progress and enriches lives. Inspired by Moore’s Law, we continuously work to advance semiconductor design and manufacturing to help solve our customers’ greatest challenges. By embedding intelligence across the cloud, network, edge, and all types of computing devices, we unlock the potential of data to transform business and society for the better. To learn more about Intel’s innovations, visit newsroom.intel.com and intel.com.
1MySQL’s performance is affected by many factors, one of which is its configuration. Different configurations may have a different impact on performance. Tencent used a configuration file and built MySQL, both with LTO and PGO, and benchmarked performance with Sysbench. The QPS performance of oltp_read_write.lua is shown in the figure above.
Intel does not control or audit third party data. You should consult other sources to assess accuracy.
Performance varies with use, configuration and other factors. Learn more about www.Intel.com/PerformanceIndex.
Your costs and results may vary.
Intel technologies may require enabled hardware, software, or service activation.
©Intel Corporation. Intel, the Intel logo, and other Intel marks are trademarks of Intel Corporation or its subsidiaries. Other names and marks may be claimed as the property of others.
See the source version on businesswire.com: https://www.businesswire.com/news/home/20220901005271/en/