Troubleshooting MySQL Concurrency Issues with Load Testing Tools

Subscribe to the
Percona Newsletter

Subscribe Now!
Buy Support Now!
  Wednesday, May 23, 2018    Sveta Smirnova

Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23rd, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).

Normally, we use benchmarking tools when we are developing applications. When applications are deployed, benchmarks tests are usually too late to help.

However, I do use benchmarking tools a lot when I troubleshoot. This webinar doesn’t cover actual benchmarks, but it does look at benchmarking tools. They are best choice when you need to repeat a situation caused by concurrent client execution. These types of issues include all kinds of locking and performance issues, along with stalls and crashes.

In this webinar I will cover some of the main tools I use, such as (but not limited to) SysBench and mysqlslap. I will show how to use their standard options while working with specific custom problems, and how to script them to develop test cases that are as close to real life scenarios as possible.


Download Slides  Watch Recorded Webinar 

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.