When launching your MySQL database, how can you make sure you’re using the right tools and getting the performance needed for your project or service to succeed? In this talk, Frank Ober walks you through benchmarking MySQL with SysBench using different mixes of DRAM and SSD storage.
Specifically, this video covers:
The my.cnf settings
Open source tools for determining I/O bottlenecks
Trading off DRAM for storage
MySQL 5.7 and what to expect from MySQL 8
Frank gives a live cloud-based demo showing the capabilities of different storage devices available to you today. And provides access to servers with Intel® Optane™ SSDs, so bring your laptops to try out what you’ve learned!
This video was taken at the Silicon Valley MySQL Meetup Group.