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

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

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.

Hosts
avatar for Ann Schlemmer

Ann Schlemmer

President, Percona
Ann joined Percona in 2013 and has held various leadership positions in the Services Organization. Prior to Percona, Ann was part of the MySQL Professional Services team at Sun Microsystems and later Oracle. Before entering the world of Open Source Databases, Ann had a career in retail... Read More →



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