话说容量规划-mysql(收藏)

对于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 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

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

«    2024年11月    »
123
45678910
11121314151617
18192021222324
252627282930
搜索
标签列表
网站分类
最新留言
    文章归档
    友情链接

    Powered By Z-BlogPHP 1.7.3

    Copyright Your WebSite.Some Rights Reserved.闽ICP备11018667号-2