[Making this into a new thread]
I was already wondering when I would hear from Wikia ...
As you have noticed, running SMW and extensions on large sites (large in
Typically, we suggest to use more conservative settings for querying, so
that long and difficult queries do not occur. Similarly, some SMW
extensions have not been developed for large sites, and can be
problematic in their own right. But your users obviously want to keep
the features that they already have, so we need to find better ways of
addressing your problem.
But first we need to separate concerns a little bit. You mention the
following distinct problems:
(1) Too many DB writes (about 60% in total)
(2) Too many slow queries (about 90% from SMW)
Moreover, your problem is not caused by SMW alone but by a number of
SMW-related extensions. So there will be multiple issues that need
addressing to fix this, and maybe even in multiple extensions.
Let us first see how big the impact of the extensions you mention could
be. Semantic Forms mainly leads to some additional reads (apparently no
problem for you); the total number could possibly be reduced. It may
also have some effect on query activity if certain autocompletion
features are used. But otherwise I think it is unlikely to be the root
of the problem. Semantic Drilldown might be more of a problem regarding
complex queries. But it uses its own SQL queries, so it should be
possible to find out how much of (2) comes from this extension. Semantic
Drilldown should not contribute to (1).
Are there any other extensions that use SMW on your site?
Regarding SMW, I have some concrete ideas on what could be done for (1)
and (2) but this will need more careful consideration first. I am
grateful if you can help to track down the cause of the problem, but I
am afraid that the changes in SMW core will still need to be done or at
least reviewed carefully by myself -- which makes me kind of a
bottleneck for the SMW part of your problem. I need to think about the
required work a little further before I can promise anything.
On 22/02/2011 22:38, Krzysztof Krzyżaniak wrote:
> I think it's would be right place to jump in.
> Hello, my name is Krzysztof Krzyżaniak a.k.a. eloy and I work for Wikia
> Inc as backend team leader. We are probably (correct me if I am wrong)
> on of the biggest user of Semantic Mediawiki suite. We currently have
> enabled it on about 100 wikis for example on familypedia.wikia.com or
> yugioh.wikia.com or www.wowwiki.com (but also on wikis which you
> probably don't suspect for SMW interest like glee.wikia.com or
> madmen.wikia.com). We would like to expand existence of SMW on Wikia
> (for example lyrics would love it) but currently we cannot afford it
> because of performance reasons. For example, our first cluster contains
> about 30.000 wikis, mostly biggest ones. About 60% of writes in
> databases came from SMW extensions (SemanticMediawiki,
> SemanticDrilldown, SemanticForms), also about 90% queries from slow logs
> are from SMW.
> I am here to find a way for scaling SMW on our wikis. But also I think
> that it will be benefit for every SMW user because we want to help
> improve SMW.
> What you can expect:
> - "real world" cases, actually lot of them :)
> - bugs :) (filled in bugzilla of course)
> - bug fixes and patches (either as diff or direct svn commits if you
> prefer that way)
> - questions
> We can offer engineering hours and testbeds.
> For a start I have question for Roadmap: SMW light - how complete it is?
> What's missing? When you expect it will be ready? How can we help?
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
Semediawiki-devel mailing list