This webinar is for every MySQL user! In this talk, I won’t focus on how to analyze core files, read the source code or set breakpoints. Instead, I will focus on techniques that are available to anyone, even a novice.

Many tutorials, including my own, written based on Roel Van de Paar’s video, suggest how to create and analyze core files created at the time of a crash. While this is one of the strongest possible troubleshooting techniques for crashes, it is not the only technique. There are more easy and accessible methods for any level of MySQL user.

You will learn why the MySQL Server crashes, how to identify the source of the crash and what to do to prevent crashes in the future.

“Lost connection to MySQL server” and “Server has gone away” are the messages the application sees when MySQL server crashes.

In this webinar, I will discuss:

What to check first

How to understand error messages

Typical reasons for crashes

How to find the reason for a crash without touching the MySQL source code

How to read backtraces

I will also cover the limitations of these techniques, such as what they don’t reveal about MySQL crashes and what is the most complicated part of each of them.

Sveta Smirnova, Principal Technical Services Engineer

Sveta joined Percona in 2015. Her main professional interests are 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 the author of book “MySQL Troubleshooting” and JSON UDF functions for MySQL.

Related

Author

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