Tencent, China’s top public cloud support service provider, achieves up to 85% effectiveness raise on TencentDB for MySQL making use of Intel oneAPI Tools.
SANTA CLARA, Calif.–(Company WIRE)–
What is New: Tencent has noticeably enhanced the performance of its databases web hosting company, TencentDB for MySQL. Centered on the open up source relational database administration method MySQL and developed on Intel® Xeon® processors, TencentDB for MySQL amplified its effectiveness by utilizing the advanced Intel® oneAPI DPC++/C++ Compiler and Intel® VTune™ Profiler (aspect of the Intel® oneAPI Foundation Toolkit).
This press release features multimedia. Perspective the complete launch below: https://www.businesswire.com/information/property/20220901005271/en/
Tencent, China’s top community cloud service company, achieves up to 85% overall performance increase on TencentDB for MySQL making use of Intel oneAPI Resources. (Graphic: Organization Wire)
“Tencent’s final results optimizing MySQL reveal the relevance the two of using up-to-date developer instruments like the Intel oneAPI DPC++/C++ Compiler and the newest optimization techniques making use of the Intel VTune Profiler. The significant improvements in performance produce either speedier time to effects or more effects for organization-important applications.”
– Joe Curley, Intel vice president and typical supervisor of Software program Goods and Ecosystem
Why It Issues: Distributed info storage serves a important purpose across industries and use instances, together with internet, finance and e-commerce. Methods like TencentDB for MySQL provide developers with a company for distributed details storage that supports quick set up, operation and growth of relational databases in the cloud. Having said that, an ongoing increase in storage and info processing prerequisites and requires for greater performance can make it challenging for builders. Optimizing for higher MySQL functionality can assist businesses procedure transactions and details queries quicker, helping to satisfy evolving business and consumer wants.
How It Operates: Intel is major the open up ecosystem by combining its one of a kind strengths in components and application applications with a commitment to developing robust, open up program that accelerates compute and innovation. The Intel oneAPI DPC++/C++ compiler is utilized for parallel programming purposes and delivers productiveness and functionality throughout CPUs and accelerators. Making use of the compiler, the groups drove website link time optimization (LTO) and profile-guided optimization (PGO) techniques that helped Tencent construct a substantial-effectiveness MySQL. With LTO, the compiler applied many varieties of intraprocedural optimization (IPO) to the complete program, letting for further analysis, additional optimization and improved software performance. PGO delivers details to the compiler about locations of an application that are most routinely executed. Alongside one another, these techniques shipped up to an 85% overall performance enhancement for TencentDB programs1.
Intel® VTune™ Profiler was utilized to obtain the functionality of MySQL based on the default configuration and to recognize and analyze warm spots in contact stacks to uncover extra locations to increase functionality.
A lot more Context: Intel and TencentDB for MySQL Circumstance Research
Intel (Nasdaq: INTC) is an industry chief, producing globe-switching technological know-how that allows world-wide progress and enriches lives. Impressed by Moore’s Regulation, we continuously function to progress the design and style and producing of semiconductors to enable address our customers’ best problems. By embedding intelligence in the cloud, network, edge and each and every kind of computing product, we unleash the likely of info to transform business enterprise and modern society for the greater. To discover a lot more about Intel’s improvements, go to newsroom.intel.com and intel.com.
1MySQL performance is affected by a lot of things, a single of which is its configuration. Unique configurations might have a distinctive impression on overall performance. Tencent employed a configuration file, and crafted MySQL, equally with LTO and PGO, and evaluated the effectiveness with Sysbench. The QPS effectiveness of oltp_go through_produce.lua is proven in the higher than figure.
Intel does not management or audit 3rd-party knowledge. You ought to talk to other sources to evaluate precision.
Overall performance varies by use, configuration, and other things. Master extra at www.Intel.com/PerformanceIndex.
Your fees and effects may perhaps fluctuate.
Intel technologies may involve enabled components, application, or support activation.
© Intel Company. Intel, the Intel brand and other Intel marks are emblems of Intel Company or its subsidiaries. Other names and makes may be claimed as the property of other individuals.
Supply: Intel Company
Launched Sep 1, 2022 • 12:00 PM EDT