Topic

TDSQL—C for MySQL HTAP Capability Evolution

Introduction：MySQL is currently the most popular database , although in the TP aspect of the user experience is good , but in the community version of the complex query support is still relatively lack of . Businesses often face slow queries and system jitter, some because of missing indexes, some because of the large amount of data processing, and some because of the complex query structure. This session introduces a series of measures taken by Tencent Cloud in physical optimization, query optimization, and hardware optimization, and how the business can robustly use these new capabilities to improve the experience. Finally, it explores how to maintain a mutually beneficial relationship between cloud vendors and the open source community, and how the business side can participate and generate contributions to jointly promote a healthy community. Outline: 1 Participation Roles and Basic Framework for Performance Management of Databases in the Cloud Era 2 Tencent Cloud MySQL HTAP Technical Route 3 HTAP technology in detail. Introducing the true and false AP problems in business systems, index management, AP capability checking model, and hardcore acceleration techniques such as regular optimization, parallel query, vectorization, columnar index, etc. 4 Business to Cloud Practice. Discusses how to understand the business-to-cloud process, and improve the smoothness of going to the cloud. 5 Future and Outlook. Introduces the symbiotic relationship between cloud vendors and the open source community, as well as opportunities for the business side to drive database iteration and ways to participate in contributing.