You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by 周竑翊 <cz...@gmail.com> on 2011/12/07 18:13:23 UTC
the number of connection between olio/rails and mysql database is small
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:czarsterchou@gmail.com
plurk:http://www.plurk.com/czars
Blog:http://czarster.blogspot.com
Re: the number of connection between olio/rails and mysql database is small
Posted by "Shanti Subramanyam (gmail)" <sh...@gmail.com>.
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 周竑翊 <cz...@gmail.com>
> 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
> ....
>
>
>
> 周竑翊 <cz...@gmail.com> 於 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:czarsterchou@gmail.com
> > plurk:http://www.plurk.com/czars
> > Blog:http://czarster.blogspot.com
> >
>
>
>
> --
> Hung-I Chou(周竑翊)
> e-mail:czarsterchou@gmail.com
> plurk:http://www.plurk.com/czars
> Blog:http://czarster.blogspot.com
>
Re: the number of connection between olio/rails and mysql database is small
Posted by "Shanti Subramanyam (gmail)" <sh...@gmail.com>.
No you don't. You simply specify a single host:port in the run form which
refers to your load balancer. I think it should work.
Shanti
2011/12/12 周竑翊 <cz...@gmail.com>
> Is there any way to use PHP-version of olio-workload/faban with
> load-balancer??
>
> the web-site of faban with olio-php workload cannot setup anything for the
> load balancer.
>
> If I want to use the LB, do I have to rewrite the workload to achieve it??
>
> thank you
>
> 周竑翊 <cz...@gmail.com> 於 2011年12月9日上午10:26 寫道：
>
> > thanks!
> >
> > But how can I running the benchmark with load balancer, olio-php
> > application and mysql database
> > each of them on separate machine/virtual machine.
> >
> > I found that php version of faban is unable to set host, variables which
> > for the load balancer
> > or it doesn't need any load balancer??
> >
> >
> >
> > 周竑翊 <cz...@gmail.com> 於 2011年12月8日下午2:58 寫道：
> >
> > hello,
> >> thank you for your answering.
> >> is that only way using rails version to run multiple application
> testing??
> >> can PHP version done the multiple application testing??
> >>
> >> Paul
> >>
> >> --
> >> Hung-I Chou(周竑翊)
> >> e-mail:czarsterchou@gmail.com
> >> plurk:http://www.plurk.com/czars
> >> Blog:http://czarster.blogspot.com
> >>
> >
> >
> >
> > --
> > Hung-I Chou(周竑翊)
> > e-mail:czarsterchou@gmail.com
> > plurk:http://www.plurk.com/czars
> > Blog:http://czarster.blogspot.com
> >
>
Re: the number of connection between olio/rails and mysql database is small
Posted by 周竑翊 <cz...@gmail.com>.
Is there any way to use PHP-version of olio-workload/faban with
load-balancer??
the web-site of faban with olio-php workload cannot setup anything for the
load balancer.
If I want to use the LB, do I have to rewrite the workload to achieve it??
thank you
周竑翊 <cz...@gmail.com> 於 2011年12月9日上午10:26 寫道：
> thanks!
>
> But how can I running the benchmark with load balancer, olio-php
> application and mysql database
> each of them on separate machine/virtual machine.
>
> I found that php version of faban is unable to set host, variables which
> for the load balancer
> or it doesn't need any load balancer??
>
>
>
> 周竑翊 <cz...@gmail.com> 於 2011年12月8日下午2:58 寫道：
>
> hello,
>> thank you for your answering.
>> is that only way using rails version to run multiple application testing??
>> can PHP version done the multiple application testing??
>>
>> Paul
>>
>> --
>> Hung-I Chou(周竑翊)
>> e-mail:czarsterchou@gmail.com
>> plurk:http://www.plurk.com/czars
>> Blog:http://czarster.blogspot.com
>>
>
>
>
> --
> Hung-I Chou(周竑翊)
> e-mail:czarsterchou@gmail.com
> plurk:http://www.plurk.com/czars
> Blog:http://czarster.blogspot.com
>
Re: the number of connection between olio/rails and mysql database is small
Posted by 周竑翊 <cz...@gmail.com>.
thanks!
But how can I running the benchmark with load balancer, olio-php
application and mysql database
each of them on separate machine/virtual machine.
I found that php version of faban is unable to set host, variables which
for the load balancer
or it doesn't need any load balancer??
周竑翊 <cz...@gmail.com> 於 2011年12月8日下午2:58 寫道：
> hello,
> thank you for your answering.
> is that only way using rails version to run multiple application testing??
> can PHP version done the multiple application testing??
>
> Paul
>
> --
> Hung-I Chou(周竑翊)
> e-mail:czarsterchou@gmail.com
> plurk:http://www.plurk.com/czars
> Blog:http://czarster.blogspot.com
>
--
Hung-I Chou(周竑翊)
e-mail:czarsterchou@gmail.com
plurk:http://www.plurk.com/czars
Blog:http://czarster.blogspot.com
Re: the number of connection between olio/rails and mysql database is small
Posted by "Shanti Subramanyam (gmail)" <sh...@gmail.com>.
The PHP version is the most stable. We have run it with 10000 users.
Shanti
On Wed, Dec 7, 2011 at 10:58 PM, 周竑翊 <cz...@gmail.com> wrote:
> hello,
> thank you for your answering.
> is that only way using rails version to run multiple application testing??
> can PHP version done the multiple application testing??
>
> Paul
> --
> Hung-I Chou(周竑翊)
> e-mail:czarsterchou@gmail.com
> plurk:http://www.plurk.com/czars
> Blog:http://czarster.blogspot.com
>
Re: the number of connection between olio/rails and mysql database is small
Posted by 周竑翊 <cz...@gmail.com>.
hello,
thank you for your answering.
is that only way using rails version to run multiple application testing??
can PHP version done the multiple application testing??
Paul
--
Hung-I Chou(周竑翊)
e-mail:czarsterchou@gmail.com
plurk:http://www.plurk.com/czars
Blog:http://czarster.blogspot.com
Re: the number of connection between olio/rails and mysql database is small
Posted by 周竑翊 <cz...@gmail.com>.
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
....
周竑翊 <cz...@gmail.com> 於 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:czarsterchou@gmail.com
> plurk:http://www.plurk.com/czars
> Blog:http://czarster.blogspot.com
>
--
Hung-I Chou(周竑翊)
e-mail:czarsterchou@gmail.com
plurk:http://www.plurk.com/czars
Blog:http://czarster.blogspot.com