Buy Percona SupportEmergency? Get 24/7 Help Now!

Forecasting MySQL Scalability with the Universal Scalability Law

November, 2010

Forecasting a system's scalability limitations can help answer questions such as “will my server handle ten times the existing load?” and “at what point will I need to upgrade my hardware?” Timely answers to these questions have more business value than exact predictions. Mathematical models can help reduce guesswork while avoiding the expense and time required for real load testing. Dr. Neil J. Gunther's Universal Scalability Law is such a model. It predicts a system's deviation from ideal scalability, based on simple measurements that are relatively easy to collect. In this paper we show how to model a MySQL database server's scalability, in terms of throughput, for two different servers and workloads.


Baron Schwartz

Vice President of Consulting

Ewen Fortune

Director of Recruiting

Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

General Inquiries

For general inquiries, please send us your question and someone will contact you.