Since there is no MySQL connection pooling from Thin, you will end up with as many mysql connections as #thins. However since there is a think time of 5 secs between requests, you should be able to get away with 1/5 concurrent users for #thins. Try increasing the #users and thins gradually. I have never actually been able to run more than 100 users or so on the rails version.
Shanti 2011/12/7 周竑翊 <[email protected]> > hello, > > if the connection was fixed, how can I increase the performance from 25 > concurrent user to hundreds of concurrent users?? > the operation / second only 13~15. > the run config is below: > > Hosts 192.168.3.10 > Concurrent Users 100 > Tools vmstat 10 > User Commands > > Ramp Up 30 > Steady State 300 > Ramp Down 10 > > Time between starts (ms) 200 > Start simultaneously no > Start agents in parallel no > > Host:Port Pairs 192.168.3.10:3000 > Server type thin > Number of Instances 20 > > Host:Port Pairs 192.168.3.7:80 > Server type Nginx > Get Access Log ? NO > > Host 192.168.3.8 > JDBC driver class name com.mysql.jdbc.Driver > JDBC connection URL jdbc:mysql:// > > 192.168.3.8/olio?user=olio&password=olio&relaxAutoCommit=true&sessionVariables=FOREIGN_KEY_CHECKS=0 > Reload Database YES > Loaded for Concurrent Users 100 > > Host 140.109.22.113(NFS server) > Reload Images YES > .... > > > > 周竑翊 <[email protected]> 於 2011年12月8日上午2:13 寫道： > > > I am using one nginx as loadbalancer > > two thin server as application server > > one mysql server as database > > > > but I found that connections between application and database are small > > and the number is the instances of thin server runs. > > take an example, I set number of instance of thin as 8, and the mysql > > connections is also 8. > > > > how can I increase the number of connection per instance of thin > > application??? > > > > -- > > Hung-I Chou(周竑翊) > > e-mail:[email protected] > > plurk:http://www.plurk.com/czars > > Blog:http://czarster.blogspot.com > > > > > > -- > Hung-I Chou(周竑翊) > e-mail:[email protected] > plurk:http://www.plurk.com/czars > Blog:http://czarster.blogspot.com >
