• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1056
  • Last Modified:

issues with Nginx + Passenger Production setup - Loading time/request time delay

having a bit of an issue relating to request time. I have NGINX as a proxy server for a ruby on rails app running passenger. I also have a postgresql database server which is running on its own VM separate from my nginx/application server. My issue is that when I try and access my products page which does a lot of database queries, my query takes maybe 3-4 seconds. The second I flood the web server with requests, i will choke out the web server and have requests take almost 20-30 seconds to process. The rails server and database server do not crash, and the usage is not that high. Each server has more than enough memory, even cpu usage on the rails server isn't more than 85%, albeit thats high but its not maxing it out.

Is my problem related to my nginx proxy server?

I dont really know how to fully explain this so if you have a question please ask it and I can clarify what I mean.

EDIT: to see exactly what i mean relating to the database query, see

http://207.245.4.215/products
0
itmanager223
Asked:
itmanager223
  • 2
  • 2
1 Solution
 
arober11Commented:
How big is your connection pool?
0
 
itmanager223Author Commented:
right now it is 16
0
 
arober11Commented:
So that will permit 16 simultaneous connections from the App server to the DB.

How many concurrent users / threads where you simulating in your test, and how long between requests, from each thread did you use?

If the number > 16 and 4 sect then the requests will queue.
0
 
itmanager223Author Commented:
so my programmer ended up finding the issue using new relic. Turned out to be a few misbehaving lines of code relating to database queries.

Thanks a lot for your help arober11.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now