Re: Slow reviewboard?

2014-02-06 Thread Christian Hammond
Hi,

That's definitely not normal. You shouldn't be experiencing that level of
slowness.

Do you have an HTTP proxy configured on your browser? If so, make sure the
domain is in the exception list.

What happens if you repeat the same test on the server itself? That'll help
rule out a networking issue.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Thu, Feb 6, 2014 at 11:14 AM, Gytis gy...@fmu1.net wrote:

 Hi, just installed reviewboard on brand new server. And it is very very
 slow.

 It takes  3 seconds to load the dashboard, and there almost none reviews,
 three users, and three github private organization repositories. Example of
 wget from local machine:

 wget http://review.mydomain.xx/dashboard/
 --2014-02-06 20:06:00--  http://review.mydomain.xx/dashboard/
 Resolving review.mydomain.xx (review.mydomain.xx)... 10.69.69.1
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80...
 connected.
 HTTP request sent, awaiting response... 302 FOUND
 Location: 
 http://review.mydomain.xx/account/login/?next_page=/dashboard/[following]
 --2014-02-06 20:06:03--
 http://review.mydomain.xx/account/login/?next_page=/dashboard/
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80...
 connected.
 HTTP request sent, awaiting response... 200 OK

 Same goes with mos other pagesWhere should i start looking?

 Setup:
 Server Intel  i7-4770, 32GB Ram, SSD disk
 Reviewboard 1.7.21
 Ubuntu 12.04.4 64bit
 Apache/2.2.22 (Ubuntu), Worker
 Reviewboard is mapped via WSGI (default config)
 Using memcache
 Postgresql database


  --
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 ---
 You received this message because you are subscribed to the Google Groups
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to reviewboard+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: Slow reviewboard?

2014-02-06 Thread Gytis
Hi,

there is no proxy, and wget i've shown was executed on the same machine, so 
this should not be a network issue. I also have jenkins running on the same 
machine, and it's fast, so once again - i guess not a network issue

On Thursday, February 6, 2014 9:36:10 PM UTC+2, Christian Hammond wrote:

 Hi,

 That's definitely not normal. You shouldn't be experiencing that level of 
 slowness.

 Do you have an HTTP proxy configured on your browser? If so, make sure the 
 domain is in the exception list.

 What happens if you repeat the same test on the server itself? That'll 
 help rule out a networking issue.

 Christian

 -- 
 Christian Hammond - chi...@chipx86.com javascript:
 Review Board - http://www.reviewboard.org
 Beanbag, Inc. - http://www.beanbaginc.com


 On Thu, Feb 6, 2014 at 11:14 AM, Gytis gy...@fmu1.net javascript:wrote:

 Hi, just installed reviewboard on brand new server. And it is very very 
 slow.

 It takes  3 seconds to load the dashboard, and there almost none 
 reviews, three users, and three github private organization repositories. 
 Example of wget from local machine:

 wget http://review.mydomain.xx/dashboard/
 --2014-02-06 20:06:00--  http://review.mydomain.xx/dashboard/
 Resolving review.mydomain.xx (review.mydomain.xx)... 10.69.69.1
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80... 
 connected.
 HTTP request sent, awaiting response... 302 FOUND
 Location: 
 http://review.mydomain.xx/account/login/?next_page=/dashboard/[following]
 --2014-02-06 20:06:03--  
 http://review.mydomain.xx/account/login/?next_page=/dashboard/
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80... 
 connected.
 HTTP request sent, awaiting response... 200 OK

 Same goes with mos other pagesWhere should i start looking?

 Setup:
 Server Intel  i7-4770, 32GB Ram, SSD disk
 Reviewboard 1.7.21
 Ubuntu 12.04.4 64bit
 Apache/2.2.22 (Ubuntu), Worker
 Reviewboard is mapped via WSGI (default config)
 Using memcache
 Postgresql database


  -- 
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 --- 
 You received this message because you are subscribed to the Google Groups 
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to reviewboard...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: Slow reviewboard?

2014-02-06 Thread Christian Hammond
If you repeat that wget test, say, 10 times, does that delay stay
consistent?

When using mod_wsgi in embedded mode (which is what the standard
configuration files make use of), Apache needs to load in all the modules
and go through our initialization each time it sets up a new process (or
worker thread, in your case). That's a first-time penalty, and depending on
your main Apache setup, can be noticeable. However, after those
processes/workers are primed, it should load fast.

We recommend using Apache with prefork instead of workers, though. You'll
have fewer issues with that setup using Django and Review Board.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Thu, Feb 6, 2014 at 9:19 PM, Gytis gy...@fmu1.net wrote:

 Hi,

 there is no proxy, and wget i've shown was executed on the same machine,
 so this should not be a network issue. I also have jenkins running on the
 same machine, and it's fast, so once again - i guess not a network issue


 On Thursday, February 6, 2014 9:36:10 PM UTC+2, Christian Hammond wrote:

 Hi,

 That's definitely not normal. You shouldn't be experiencing that level of
 slowness.

 Do you have an HTTP proxy configured on your browser? If so, make sure
 the domain is in the exception list.

 What happens if you repeat the same test on the server itself? That'll
 help rule out a networking issue.

 Christian

 --
 Christian Hammond - chi...@chipx86.com

 Review Board - http://www.reviewboard.org
 Beanbag, Inc. - http://www.beanbaginc.com


 On Thu, Feb 6, 2014 at 11:14 AM, Gytis gy...@fmu1.net wrote:

  Hi, just installed reviewboard on brand new server. And it is very
 very slow.

 It takes  3 seconds to load the dashboard, and there almost none
 reviews, three users, and three github private organization repositories.
 Example of wget from local machine:

 wget http://review.mydomain.xx/dashboard/
 --2014-02-06 20:06:00--  http://review.mydomain.xx/dashboard/
 Resolving review.mydomain.xx (review.mydomain.xx)... 10.69.69.1
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80...
 connected.
 HTTP request sent, awaiting response... 302 FOUND
 Location: 
 http://review.mydomain.xx/account/login/?next_page=/dashboard/[following]
 --2014-02-06 20:06:03--  http://review.mydomain.xx/
 account/login/?next_page=/dashboard/
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80...
 connected.
 HTTP request sent, awaiting response... 200 OK

 Same goes with mos other pagesWhere should i start looking?

 Setup:
 Server Intel  i7-4770, 32GB Ram, SSD disk
 Reviewboard 1.7.21
 Ubuntu 12.04.4 64bit
 Apache/2.2.22 (Ubuntu), Worker
 Reviewboard is mapped via WSGI (default config)
 Using memcache
 Postgresql database


  --
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 ---
 You received this message because you are subscribed to the Google
 Groups reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to reviewboard...@googlegroups.com.

 For more options, visit https://groups.google.com/groups/opt_out.


  --
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 ---
 You received this message because you are subscribed to the Google Groups
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to reviewboard+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: Slow reviewboard?

2014-02-06 Thread Gytis

On Friday, February 7, 2014 7:40:10 AM UTC+2, Christian Hammond wrote:

 If you repeat that wget test, say, 10 times, does that delay stay 
 consistent?


Yes
 

 When using mod_wsgi in embedded mode (which is what the standard 
 configuration files make use of), Apache needs to load in all the modules 
 and go through our initialization each time it sets up a new process (or 
 worker thread, in your case). That's a first-time penalty, and depending on 
 your main Apache setup, can be noticeable. However, after those 
 processes/workers are primed, it should load fast.

 We recommend using Apache with prefork instead of workers, though. You'll 
 have fewer issues with that setup using Django and Review Board.


Switched to prefork. Almost the same. Now if i run wget for 10 times, 
sometimes only the first request takes long, but its like 10% max.

What bothers me is the consistent 3 seconds minimum request time (not 4 not 
5 and not 2). Could this be some sort of timeout?

Any more ideas?
 

 Christian

 -- 
 Christian Hammond - chi...@chipx86.com javascript:
 Review Board - http://www.reviewboard.org
 Beanbag, Inc. - http://www.beanbaginc.com


 On Thu, Feb 6, 2014 at 9:19 PM, Gytis gy...@fmu1.net javascript:wrote:

 Hi,

 there is no proxy, and wget i've shown was executed on the same machine, 
 so this should not be a network issue. I also have jenkins running on the 
 same machine, and it's fast, so once again - i guess not a network issue


 On Thursday, February 6, 2014 9:36:10 PM UTC+2, Christian Hammond wrote:

 Hi,

 That's definitely not normal. You shouldn't be experiencing that level 
 of slowness.

 Do you have an HTTP proxy configured on your browser? If so, make sure 
 the domain is in the exception list.

 What happens if you repeat the same test on the server itself? That'll 
 help rule out a networking issue.

 Christian

 -- 
 Christian Hammond - chi...@chipx86.com

 Review Board - http://www.reviewboard.org
 Beanbag, Inc. - http://www.beanbaginc.com


 On Thu, Feb 6, 2014 at 11:14 AM, Gytis gy...@fmu1.net wrote:

  Hi, just installed reviewboard on brand new server. And it is very 
 very slow.

 It takes  3 seconds to load the dashboard, and there almost none 
 reviews, three users, and three github private organization repositories. 
 Example of wget from local machine:

 wget http://review.mydomain.xx/dashboard/
 --2014-02-06 20:06:00--  http://review.mydomain.xx/dashboard/
 Resolving review.mydomain.xx (review.mydomain.xx)... 10.69.69.1
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80... 
 connected.
 HTTP request sent, awaiting response... 302 FOUND
 Location: http://review.mydomain.xx/account/login/?next_page=/
 dashboard/ [following]
 --2014-02-06 20:06:03--  http://review.mydomain.xx/
 account/login/?next_page=/dashboard/
 Connecting to review.mydomain.xx (review.mydomain.xx)|10.69.69.1|:80... 
 connected.
 HTTP request sent, awaiting response... 200 OK

 Same goes with mos other pagesWhere should i start looking?

 Setup:
 Server Intel  i7-4770, 32GB Ram, SSD disk
 Reviewboard 1.7.21
 Ubuntu 12.04.4 64bit
 Apache/2.2.22 (Ubuntu), Worker
 Reviewboard is mapped via WSGI (default config)
 Using memcache
 Postgresql database


  -- 
 Get the Review Board Power Pack at http://www.reviewboard.org/
 powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 --- 
 You received this message because you are subscribed to the Google 
 Groups reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to reviewboard...@googlegroups.com.

 For more options, visit https://groups.google.com/groups/opt_out.


  -- 
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 --- 
 You received this message because you are subscribed to the Google Groups 
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to reviewboard...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: Slow reviewboard?

2014-02-06 Thread Gytis


On Friday, February 7, 2014 8:15:47 AM UTC+2, Christian Hammond wrote:


 On the server, run:

 rb-site manage /path/to/site runserver 0.0.0.0:8080

 (Or pick another port if that is taken.)

 That's going to make use of Django's built-in single-threaded development 
 server. You can then repeat the request using that port and see if you 
 still get the 3 second delay.


Same results:

-2014-02-07 08:29:43--  http://localhost:8181/
Resolving localhost (localhost)... 127.0.0.1
Connecting to localhost (localhost)|127.0.0.1|:8181... connected.
HTTP request sent, awaiting response... 301 MOVED PERMANENTLY
Location: http://localhost:8181/dashboard/ [following]
--2014-02-07 08:29:46--  http://localhost:8181/dashboard/
Connecting to localhost (localhost)|127.0.0.1|:8181... connected.
HTTP request sent, awaiting response... 302 FOUND
Location: http://localhost:8181/account/login/?next_page=/dashboard/ 
[following]
--2014-02-07 08:29:49-- 
 http://localhost:8181/account/login/?next_page=/dashboard/

So .. database issue? I've tried connecting with psql, no problem there. My 
database config:

'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'reviewboard',
'USER': 'reviewboard',
'PASSWORD': 'xx',
'HOST': 'localhost',
'PORT': '',
},

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: Slow reviewboard?

2014-02-06 Thread Christian Hammond
Glad it's working! Mystery solved.

We'll be out at an event the next few days, so I'll be largely unavailable,
but if you have any further issues, I'll try to back to you when I have a
free moment.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com



On Thu, Feb 6, 2014 at 11:12 PM, Gytis gy...@fmu1.net wrote:

 Ok, it seems that i had misconfiguration with memcache.

 I've tried generating new site with sqlite, and it was fast. So then i
 looked at the configs, and saw that on my current config memcache was set
 to NONE

 This was because i have ran rb-site with --noinput and
 specified --cache-type='memcached' without --cache-info. So memache was
 partialy configured. I saw that yesterday on the interface (System Settings
 - General) and changed Cache Host to localhost:11211. But it seems that
 did not make any difference, and only manually changing settings_local.py
 helped.

 Thanks for help :)


 On Friday, February 7, 2014 8:40:01 AM UTC+2, Gytis wrote:



 On Friday, February 7, 2014 8:15:47 AM UTC+2, Christian Hammond wrote:


 On the server, run:

 rb-site manage /path/to/site runserver 0.0.0.0:8080

 (Or pick another port if that is taken.)

 That's going to make use of Django's built-in single-threaded
 development server. You can then repeat the request using that port and see
 if you still get the 3 second delay.


 Same results:

 -2014-02-07 08:29:43--  http://localhost:8181/
 Resolving localhost (localhost)... 127.0.0.1
 Connecting to localhost (localhost)|127.0.0.1|:8181... connected.
 HTTP request sent, awaiting response... 301 MOVED PERMANENTLY
 Location: http://localhost:8181/dashboard/ [following]
 --2014-02-07 08:29:46--  http://localhost:8181/dashboard/
 Connecting to localhost (localhost)|127.0.0.1|:8181... connected.
 HTTP request sent, awaiting response... 302 FOUND
 Location: 
 http://localhost:8181/account/login/?next_page=/dashboard/[following]
 --2014-02-07 08:29:49--  http://localhost:8181/account/login/?next_page=/
 dashboard/

 So .. database issue? I've tried connecting with psql, no problem there.
 My database config:

 'default': {
 'ENGINE': 'django.db.backends.postgresql_psycopg2',
 'NAME': 'reviewboard',
 'USER': 'reviewboard',
 'PASSWORD': 'xx',
 'HOST': 'localhost',
 'PORT': '',
 },

  --
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 ---
 You received this message because you are subscribed to the Google Groups
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to reviewboard+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.