Troubleshooting MySQL Concurrency Issues with Load Testing Tools
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.