Two of the most critical and challenging tasks for MySQL DBA’s are optimizing MySQL performance and troubleshooting MySQL problems. The databases powering your applications need to be able to handle heavy loads while remaining responsive and stable, so that you can deliver an excellent user experience.
DBA’s are expected to have plans in place to solve these issues. In this presentation, we will briefly talk about best practices for troubleshooting and optimization, as well as spending time showing how Percona Monitoring and Management (PMM) approaches typical performance optimization and troubleshooting tasks. We will look into how to spot a bad query which needs an index, inefficient queries which may need to be reworked, as well as spotting when a system (not sized correctly to manage its current load) can become saturated.
Speaker: Peter Zaitsev – Percona