Subscribe to the
Percona Newsletter

Subscribe Now!
  Thursday, March 10, 2016    Sveta Smirnova

MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running queries, stopped replications, poor user connections and many others. It’s often difficult not only to troubleshoot these issues, but to even know which tools to use.

In my experience, 90% of MySQL troubles can be identified and solved with some basic techniques. In this first of two introductory webinars, I will demonstrate some expert tips that will simplify troubleshooting.

We’ll start with an easy-to-follow workflow, then troubleshoot one or two MySQL issues. Together we’ll address the issues using built-in instrumentation and the most important command line tools.

At the end of the webinar you’ll know why a MySQL application is misbehaving, and how to address it! You can use this information as a foundation for more complicated issues that we’ll discuss in future webinars.

Knowledge of how to setup a test environment. For help, watch MySQL Troubleshooting Webinars, part 1: How to create test setup


About the Author

Sveta Smirnova

Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.