Question

如何估算一台数据库服务器能够承受的并发量

Answer 1

There're two general methods. Let me call them internal and external, for lack of better terms. The internal method calculates the max concurrency based on CPU speed compared to the CPU time used by one buffer get. You have to estimate how many buffer gets your application will require at the peak time. This of course assumes the application is fairly well tuned and disk I/O's are not a big part of the overall problem. The external method is test without, or without much, thinking. Many tools can do this. Swingbench is one commonly used.