hi all,
I've got a semantic mediawiki installation with about
100,000 pages and growing, 236k rows in smw_ids, and 646k rows in
pagelinks
running on Windows Server 2008,
MediaWiki 1.13.5
PHP 5.3.1
MySQL 5.1.41
SMW 1.4.2
SMWHalo 1.4.5
I'm getting to the point where page loads are starting to be pretty slow
sometimes, and occasionally timeout.
Granted,
I'm using lots of external data calls, and those calls cause new pages
to be created in the background, and those new pages beget more new
pages, etc etc. So there's a spidering growth going on as well. I'm
doing plenty of caching of my service calls, using memcached.
obviously
it's a sort of complicated setup, and I'm noticing that even normal
queries of the db (using phpmyadmin) are taking quite a while.
I don't have a lot of experience with db
optimization; I'm wondering if there's anything that you guys do to
your wiki to make it run better, any defaults I can change, indexes to
create, etc (I did add an index on a temp table being created in code,
and that helped in one area, so I know things like that can be done).
Also, if there's any good tools you use for profiling either the php or the
mysql?
I've used xdebug and wincachegrind for php profiling; has anyone tried MonYog:
http://www.webyog.com/en/
for mysql profiling? And other tools you like that I can use in a windows env?
Or maybe just some general pointers on what to look for when trying to improve
performance?
I know this is vague; maybe there's a good thread/link out there already for
this topic? I haven't seen it.
thanks for all your help and hard work!
don undeen
Metropolitan Museum of Art
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
