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