Webinar series – A step-by-step process to optimize MySQL database performance

Hope you have been following our recent webinars on MySQL, Galera Cluster, AWS monitoring and more.

We are coming up with a webinar series in association with Eric Vanier, a leading MySQL expert consultant. The series will provide a step-by-step process to optimize MySQL database performance.

This webinar series is for everyone who is looking for ways to monitor their MySQL databases, simplify the process to manually analyze queries and achieve faster issue resolution time.

Eric Vanier will focus on key problem areas that are faced by DBAs and Shree will provide a solution-driven demonstration to overcome issues while monitoring the database performance. To make it simple, the series will comprise of three parts:

Part – 1: MySQL Performance Tuning
26 June; 10:00 am Eastern time

Troubleshooting a MySQL server performance problem is often a tedious activity as it’s difficult to figure out where to start and how to cope up with it. In the case of an increase in the volume of data and load on the server, the queries tend to run slower and deadlocks become a frequent occurrence.

In this webinar, you will learn the following:

– 3 different ways to identify slow queries.
– Spot query performance pattern over a particular period.
– Proactive monitoring by setting up server/ tag specific alert.
– Fetching deadlock information.
– Monitor MySQL log files on a remote machine.
– Product comparison between Monyog and MySQL Enterprise Monitor.

Register here

Part – 2: Real-time monitoring and RDS file-based log monitoring
03 July; 10:00 am Eastern time

Many of our customers use Monyog to help monitor data in real-time and find the problematic queries. Moreover, Monyog is the only tool that provides file-based log monitoring for Amazon RDS for MySQL & Aurora on RDS.

In the 2nd part of our webinar series, you will learn the following:

– Analyze queries without slow query file.
– Monitoring queries in real-time.
– Monitor log files for RDS instances.
– Performance overhead caused by Monyog.
– Hardware requirement for Monyog.
– Monyog architecture.

Register here

Part – 3: Achieve faster issue resolution time
10 July; 10:00 am Eastern time

In this final part of the webinar series, we will focus on effective practices of monitoring MySQL databases using Monyog. This will provide as in-depth learning session for making the best of the monitoring tool.

Learn the following in this webinar:

– Using explain plan in Monyog.
– Quickly monitoring database and tables size.
– Create Monyog users with restricted access and privileges.
– Minimize the data generated by Monyog.
– Create aggregated report of the data collected in Monyog.

Register here

If you are not able to attend the webinar live, register anyway and we’ll send you a link to the recording once the webinar session has ended.


Add yours
  1. 1
    Erik Scanlan

    I am tasked with gathering all the research into MySQL Monitoring. We have 2-3 other critical areas outside MySQL to monitor that we are also setting up so the process of this decision cycle is going to last into the final webinar video. That is good timing as I have to compare this with Nagios XI and available plug-ins from third party contributors to Nagios XI.

    We have already purchased Nagios XI but I feel it is good for general network monitoring for servers, routers, switches, etc. Another words, physical hardware is the strong point. I do not see how it will be able to compare to this solution but I have to gather the data to make sure, while doing it in an unbiased way since I am leaning towards MonYog.

    So I look forward to joining those webinars and learning as much as I can over the next month so I can finalize a report for my partner. Talk to you guys later and thank you for the resources you work hard to provide.

    • 2

      Great to hear, Erik! We look forward to providing you with information through webinars & blogs that will help in your decision process.

      Meanwhile, if you have any queries relating to Monyog, you can email us at support@webyog.com.

      Ravikiran Iyengar

+ Leave a Comment