On Mon, 04 Jan 2010 17:24:26 +0100 Johannes Ahlers <[email protected]> wrote:
> Now the questions: > 1. How can I speed up the first call of pootle-mainpage? > 2. Why does the refresh_stats-task have no effect on this? > 3. How can I obtain more log-output. We run pootle 1.2 in an > installed version without apache before and there many more > log-entries were created. you can have more verbose logs by editing the localsettings.py file and setting DEBUG = True, you'll need to restart apache after that. then check your apache error log, debug output should appear there. in theory if you are using memcached then after running refresh_stats everything needed for displaying the front page should be already in cache. the debug output will tell you what's going on. it might be that your dataset is too big for your current memcached setup. you can verify this using the memcached-tool command (if it's not installed on your system get it from http://code.sixapart.com/svn/memcached/trunk/server/scripts/memcached-tool it's a simple perl script) just run memcached-tool localhost stats the interesting values are get_misses and evictions but please send the whole output here. > 4. May changing from SQLite to MySQL bring > more performance. When I tried this some time ago only the pootle.db > was migrated to MySQL. The stats.db was left on SQLite. The last one > seems to cause the problem. yes only pootle.db can be replaced with a mysqldb, statsdb code is not portable across different database systems. moving the django database (pootle.db) to mysql improves concurrency but wouldn't speed up updating stats. and yes statsdb is the main performance bottleneck. but should be mitigated by memcached. cheers, Alaa ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
