Vinicius Grippa

Monitoring is a fundamental part of a DBA's daily activities. We must understand how the workload uses limited resources such as memory, CPU, and disks. In this talk, we will cover the ProcFS UDF plugin, which is open-source and designed to provide access to the Linux performance counters by running SQL queries against MySQL 8.0.

Using the Proc FS plugin, we can extend the monitoring capabilities of databases that cannot run a local agent. That is particularly useful for those who are using DBaaS as well as for companies that have separate teams responsible for operating system and database operations.

Backup and restore methods are concepts that everyone knows the importance of. Over the years, open-source tools emerged like MyDumper, Xtrabackup, and Mariabackup. Also, with MySQL 8 new shell, new utils for dump and restore were introduced as well.

In this presentation, we are going to compare the newest backup/restore methods with the most used ones. We will see how parallelization can influence the speed of backup and restore process and also how the compression algorithms can influence the performance.

In this talk, we will compare mysqldump, mydumper/myloader, mysqlpump, MySQL Shell utils, and Xtrabackup.

Come to see some real-life examples of how you can do CPU profiling with perf and eBPF/BCC, to create FlameGraphs and ColdGraphs visualizations of the on-CPU/off-CPU time spent by the database. Based on these visualizations and reading the database source code (this is why we love Open Source!) you can quickly gain insight about what's burning CPU (FlameGraphs) and what's causing CPU to wait (ColdGraphs), and with this knowledge you will be several steps closer to answering "what's consuming all that CPU time".