Benchmarking MySQL with Sysbench
Introduction
Setup, configure, and run MySQL server
Build and run Sysbench
Enable profile-guided optimization for MySQL
Next Steps

  Log an issue

  Fork and edit

  Discuss on Discord

Explore related resources

Find more information about the topics in this Learning Path:

Give feedback

How would you rate this Learning Path?

Review frequently asked questions

AI-assisted

These FAQs were drafted with an approved AI-assisted workflow and reviewed by Arm contributors before publication. Human technical review remains part of the process so the final page reflects engineering rigor, accuracy, and Arm editorial standards.

Close
?
Can I use a different Linux distribution than Ubuntu 22.04?
Other Linux distributions and Ubuntu versions might also work. If you use a different distribution, expect to adapt package installation commands to match your environment.
Why do I need to build and install MySQL on the Sysbench client?
sysbench needs MySQL client libraries to build and run its MySQL tests. You only build and install MySQL on the client to provide these libraries. You don’t configure or run the MySQL server on the client.
How much disk space do I need on the server and client?
Allocate at least 200 GB of disk space on the MySQL server system. Allocate at least 30 GB on the Sysbench client system.
Which compiler should I use for PGO, and what builds will I create?
Use GCC for PGO. You’ll create two additional MySQL installations: one built with profile generation to collect data and another rebuilt with profile use to apply that data.
How do I confirm that PGO changed performance?
Run the same sysbench workload on the baseline and profile-use builds, then compare their results. Keep the workload and environment consistent so the comparison is meaningful.

Share

Tell others about this Learning Path.

Back
Return to Servers and Cloud Computing