MySQL Day – Sessions review #6

Let’s continue the review of the pre-FOSDEM MySQL Day‘s schedule. Today’s session is the one of Sveta Smirnova: What you wanted to know about your MySQL Server instance, but could not find using internal instrumentation only

Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book “MySQL Troubleshooting” and author of JSON UDF functions for MySQL. In years 2006 – 2015 she worked in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. In years 2012-2015 she worked on MySQL Labs project “JSON UDFs for MySQL”. She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques.

As Sveta says, MySQL versions 5.6, 5.7 and 8.0 made life of DBA and MySQL Support engineers much easier. If even in version 5.5 we had to use operating system tools, debuggers and inject debugging code into our stored routines, with 5.7 this is not necessary. 8.0 did not provide us new instruments, but revolutionary new data dictionary implied huge improvements in existent instrumentation, so it became safe to use even in large production environments.

In this session Sveta will not discuss existent instrumentation, already well presented, but she will cover areas which are still not properly instrumented. She will mention what can and cannot do MySQL DBA to troubleshoot issues, falling in these areas.

I’m curious to see what Sveta will show us and certainly provide us valuable feedback where we could improve MySQL instrumentation even more.

This session will start at 15.50.

Don’t forget to register for this main MySQL event and for the MySQL Community Dinner that will happen on Saturday, February 4th just after the FOSDEM’s MySQL & Friends Devroom.


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.