We're running Trac through mod_python, roughly following the instructions at
http://trac.edgewall.org/wiki/TracInstall
It seems to be a combination of mod_python being a resource hog and Trac's
MySQL support still being "experimental". If you take a look at the slow
query log on the hp.o slice (it's logging non-indexed queries right now
too), there are a crapload of queries relating to Trac. Looking at them,
there are a bunch that just seem crazy too. They're either insanely
brilliant or insanely crazy. I haven't looked into some of the queries
enough to know which.
For example:
# u...@host: habari_trac[habari_trac] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 13520
use habari_trac;
SELECT rev FROM node_change WHERE CAST(rev AS signed) > 2828 AND
(path='branches/081011-errorhandling/htdocs/system/themes/charcoal/multiple.php'
OR path LIKE
'branches//081011-errorhandling//htdocs//system//themes//charcoal//multiple.php//%'
ESCAPE '/' OR (path in
('branches','branches/081011-errorhandling','branches/081011-errorhandling/htdocs','branches/081011-errorhandling/htdocs/system','branches/081011-errorhandling/htdocs/system/themes','branches/081011-errorhandling/htdocs/system/themes/charcoal','branches/081011-errorhandling/htdocs/system/themes/charcoal/multiple.php')
and change_type='D')) ORDER BY CAST(rev AS signed) LIMIT 1;
On Sun, Mar 29, 2009 at 9:19 PM, Sean Coates <[email protected]> wrote:
>
> > Trac is always slow... it sucks. I would say any SVN slowness is
> > probably as a result of this hook hitting Trac.
>
> Do you have any actual evidence of this, or is this just anecdotal?
> How are we running python? mod_python? fcgi? cgi?
>
> S
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at http://groups.google.com/group/habari-dev
-~----------~----~----~----~------~----~------~--~---
