Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Percona Toolkit, A MySQL DBA's Toolkit In Action

Percona Toolkit, A MySQL DBA's Toolkit In Action

 5 October 3:40 PM - 4:05 PM @ Matterhorn 2
Experience level: 
Beginner
Duration: 
25 minutes conference
Tracks:
MySQL
Topics:
MySQL
Data in the Cloud

Description

This presentation will present several Open Source tools which can provide DBA's, sysadmins and developers with additional information on the state and performance of their database while also facilitating the management of their database environment. We will present and discuss several following operational issues: - How to archive data from a large table while keeping an eye on the database performance. - How to verify the consistency of your databases. - How to gather information to troubleshoot performance issues. - Doing online replication aware schema changes. - Identifying queries which could use optimisation to get better response times. This talk will cover several Percona Toolkit scripts and demonstrate how to use them on your infrastructure.

Speakers

Dimitri Vanoverbeke's picture

Dimitri Vanoverbeke

Solution Engineer, Percona

Biography:

At the age of 7, Dimitri received his first computer, since then he has felt addicted to anything with a digital pulse. Dimitri has been active in IT professionally since 2003 in which he took various roles from internal system engineering to consulting. Prior to joining Percona, Dimitri worked as a Open Source consultant for a leading Open Source software consulting firm in Belgium. During his career, Dimitri became familiar with a broad range of open source solutions and with the devops philosophy. Whenever he's not glued to his computer screen, he enjoys travelling, cultural activities, basketball and the great outdoors. Dimitri is living with his girlfriend in the beautiful city of Ghent, Belgium.

Kenny Gryp's picture

Kenny Gryp

MySQL Practice Manager, Percona

Biography:

Kenny is currently MySQL Practice Manager at Percona.

Share this talk


Slides