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

CEO, Percona
Ann is a seasoned leader & advocate for open source with over 15 years experience in open source. CEO of Percona, a world-class open source database software firm, she is driven by passion for people & belief in open source's power to create an inclusive tech industry. Her authenticity... Read More →



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