Buy Percona ServicesBuy Now!
  November, 2010
   Baron Schwartz, Ewen Fortune

Forecasting MySQL Scalability with the Universal Scalability Law

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
CEO - VividCortex

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

Visit Percona Store

General Inquiries

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