Can you elaborate how can cron cause database locking issues (apart
from such issues being caused by child processes)?
The content of the crontab is irrelevant, whether you only have
@reboot or more makes no difference. If there would be no check, you
could not change cron parameters without restarting.
On Apr 5, 7:46 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Since you have the problem with both cherrypy and rocket I suspect
> that this may be a database locking issues caused by cron. Even it you
> only have @reboot, still cron runs and every minute it check what
> needs to be done. I suggest try disable it completely and see what
> happens. In web2py.py replace
>
> gluon.widget.start(cron=True)
>
> with
>
> gluon.widget.start(cron=False)
>
> Let us know.
>
> Massimo
>
> On Apr 4, 11:47 pm, Michael Toomim <too...@gmail.com> wrote:
>
> > I started using apache with mod_wsgi, and now it's fast! So this
> > indicates it's a problem that only occurs when using rocket or
> > cherrypy, but again I'm only measuring it with firebug in my browser.
>
> > I have 768MB of ram, ~500MB free. I use cron for @reboot only.
>
> > I only run it on a remote machine (on slicehost VPS). I do not think
> > it is network problems because it is fast in my web browser until I
> > get hit by a bunch of users. Of course I'd like to eliminate the
> > network from my measurements, but for that I need webserver processing-
> > time logs.
>
> > On Apr 4, 9:08 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > Some more questions:
>
> > > how much ram?
> > > can you check memory usage? A memory leak may cause slowness.
> > > are you using cron? when cron starts it may spike memory usage.
> > > are you experience the slowness from localhost or from remote
> > > machines?
>
> > > On Apr 4, 6:46 pm, Michael Toomim <too...@gmail.com> wrote:
>
> > > > You are both right that I do not know where the slowness is coming
> > > > from. My goal is to measure it so that I can narrow in on the
> > > > problem. So far I know that it is external to web2py because it does
> > > > not show up in httpserver.log, so my reasoning is to look at rocket
> > > > which wraps the web2py part.
>
> > > > On Apr 4, 4:44 pm, Michael Toomim <too...@gmail.com> wrote:
>
> > > > > I see, thank you. I want to measure the web server's response time
> > > > > when I deploy this on turk... Unfortunately the rocket log does not
> > > > > report time to serve a request. Do you think it is easy to get that
> > > > > information from rocket? Do you store the start and stop times for
> > > > > each request? I see start times stored in "connections", but I'm not
> > > > > sure that's the right object.
>
> > > > > On Mar 30, 6:09 am, Timothy Farrell <tfarr...@swgen.com> wrote:
>
> > > > > > I don't think upgrading will help much since Cherrypy was also
> > > > > > slow.
> > > > > > However, doing so would help cover all your bases.
>
> > > > > > If you want to use the http log from Rocket you can do this. I'm
> > > > > > assuming you invoke web2py.py from a bash script or just run it
> > > > > > manually. Paste the following code into the top of web2py.py
>
> > > > > > import logging
> > > > > > import logging.handlers
> > > > > > log = logging.getLogger('Rocket.Requests')
> > > > > > log.setLevel(logging.INFO)
> > > > > > log.addHandler(logging.handlers.FileHandler('rocket.log')
>
> > > > > > I, like Yarko, do think this has more to do with something else.
> > > > > > At one
> > > > > > point web2py had a profiler built-in. That could be a good tool for
> > > > > > finding slow spots.
>
> > > > > > -tim
>
> > > > > > On 3/29/2010 7:59 PM, MichaelToomimwrote:
>
> > > > > > > Yes, this is on linux! Do you recommend upgrading and trying
> > > > > > > again?
>
> > > > > > > mturk doesn't affect anything, I am just serving webpages that
> > > > > > > appear
> > > > > > > in iframes on the mturk website. From our perspective, I'm
> > > > > > > serving
> > > > > > > webpages.
>
> > > > > > > Do you have a method of logging how much time it takes to serve a
> > > > > > > page
> > > > > > > with rocket? Something that I can use instead of httpserver.log?
> > > > > > > It
> > > > > > > seems important for me to measure real-world performance, which ab
> > > > > > > does not do.
>
> > > > > > > My server has 768MB ram, and the only thing it does is run this
> > > > > > > web2py
> > > > > > > server. I assumed ram was not full, but did not check. I will
> > > > > > > check
> > > > > > > next time.
>
> > > > > > > On Mar 29, 12:10 pm, Timothy Farrell<tfarr...@swgen.com> wrote:
>
> > > > > > <snip/>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
