Loading…
Attending this event?
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!



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.)

Speakers
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

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.

Hosts
avatar for Ann Schlemmer

Ann Schlemmer

General Manager, Percona


Tuesday October 20, 2020 22:00 - 22:30 EDT
Online
  MySQL
Feedback form isn't open yet.