Abstract
It is very important to verify the impact of changes before you apply them to your production systems. This applies to both small changes like modifying a query and large changes such as refactoring the application and schema as well as MySQL upgrades. You may think that the optimal performance test is based on your production schema and data using the same queries that the application executes. However, it is not always as simple as it sounds to recreate the right workload, so sometimes it is necessary to use standard benchmark suites.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Jesper Wisborg Krogh
About this chapter
Cite this chapter
Krogh, J.W. (2020). Benchmarking with Sysbench. In: MySQL 8 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5584-1_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5584-1_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5583-4
Online ISBN: 978-1-4842-5584-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books