[rt-users] One Performance problem identified

[Ruslan Zakirov]

It's possible that it's not query, but something else that don't allow
server to finish a request, but user already requested something else.

Oh, and that often happens when user opens many tickets at once in
several tabs(windows), so his requests stick in a queue waiting for
each other.

On 11/7/07, Mathew <theillien at yahoo.com> wrote:
> But the slow query log only lists the "SELECT GET_LOCK..." queries.  How do I get to the underlying query?
>
> Keep up with my goings on at http://theillien.blogspot.com
>
> Ruslan Zakirov wrote:
> > One possible reason is previous lock that is there from another
> > request, so you really have to look for other slow queries that take
> > too much time so users don't wait and click on links or restart
> > requests.
> >
> > On 11/7/07, Mathew Snyder <theillien at yahoo.com> wrote:
> >> The sessions table is a mess (well, *was* a mess).  Why this doesn't get cleaned
> >> out regularly by RT is beyond me.  That said, we had more than 21000 records in
> >> there.  I ran "DELETE * FROM sessions WHERE LastUpdated < (now() - INTERVAL 24
> >> HOUR)" as is laid out in the wiki-page for clearing sessions.  This cleaned out
> >> the table but, it still takes too long to load a ticket.  Looking at the slow
> >> queries log I see
> >>
> >> # Time: 071106 17:56:13
> >> # User at Host: rt_user[rt_user] @ localhost []
> >> # Query_time: 14  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
> >> SELECT GET_LOCK('Apache-Session-d279953494e7dcbbaca2e566a94002f2', 3600);
> >>
> >> Why is it taking so long to get a lock on a table?  I know it isn't taking
> >> forever to actually query the database because the page loaded almost
> >> immediately after the above query completed.  We're using InnoDB as opposed to
> >> MyISAM.  Might that have something to do with it?
> >>
> >> Any thoughts on this?
> >>
> >> Mathew
> >> --
> >> Keep up with me and what I'm up to: http://theillien.blogspot.com
> >> _______________________________________________
> >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >>
> >> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
> >>
> >> If you sign up for a new RT support contract before December 31, we'll take
> >> up to 20 percent off the price. This sale won't last long, so get in touch today.
> >>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
> >>
> >>
> >> Community help: http://wiki.bestpractical.com
> >> Commercial support: sales at bestpractical.com
> >>
> >>
> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >> Buy a copy at http://rtbook.bestpractical.com
> >>
> >
> >
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
>
> If you sign up for a new RT support contract before December 31, we'll take
> up to 20 percent off the price. This sale won't last long, so get in touch today.
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
>
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.