对于MySQL,其实计算方法是类似的,所不同的是要注意存储结构的不同。
可以参考如果文章:
The basics of InnoDB space file layout – Jeremy Cole
The physical structure of InnoDB index pages – Jeremy Cole
The physical structure of records in InnoDB – Jeremy Cole
可以参考如果文章:
The basics of InnoDB space file layout – Jeremy Cole
The physical structure of InnoDB index pages – Jeremy Cole
The physical structure of records in InnoDB – Jeremy Cole
The Universal Scalability Law
The Universal Scalability Law is a mathematical definition
of scalability. It models the system’s capacity
C at a given size N. This paper demonstrates how
to use the Universal Scalability Law to predict a system’s
scalability. The process is to measure several
samples of throughput and concurrency, transform
the data, perform a least-squares regression against
it, and reverse the transformation.
以下内容摘录自《forecasting-mysql-scalability.pdf》
通过spss可以方便的得到一个类似的曲线
一般情况下,很难得到N=1的数据,其实也可以通过曲线回归,类似得到
通过方程式:y=0 + 998.5614660260804 * x + -23.70809368565541 * x*x
当x=1时:
y=975
当x=1时:
y=975