Back To Schedule
Tuesday, October 20 • 22:00 - 22:30
How to Protect the SQL Engine From Running Out of Memory

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

Running a SQL usually requires the database to allocate working memory to the process that executes a SQL. However, the uncontrolled size of the input data source or the intermediate data generated by calculation may trigger an Out of Memory (OOM) crash. Thus, the memory management mechanism of the computing layer is necessary.

In this talk, we will introduce how we prevented the database, taking TiDB as an example, from the OOM crash caused by excessive memory consumption during a calculation, such as disk spilling and adaptive adjustment.)

avatar for Huaiyu Xu

Huaiyu Xu

Research and Develop Engineer, PingCAP
Huaiyu Xu is an engineer at PingCAP, responsible for the development of TiDB SQL Engine.
avatar for Song Gao

Song Gao

Infrastructure Engineer, PingCAP
Song Gao is an engineer at PingCAP, responsible for the development of TiDB Scheduling. He is passionate about cloud-native and open-source technologies.

avatar for Ann Schlemmer

Ann Schlemmer

President, Percona
Experienced professional and executive with a demonstrated history of working in the information technology and services industry. Skilled in Management, Operations, Customer Relationship Management (CRM), Open Source Databases, and Professional Services. Strong professional with... Read More →

Tuesday October 20, 2020 22:00 - 22:30 EDT