Closed GoogleCodeExporter closed 9 years ago
They really don't, actually. Your issue is that the version you're using uses
MySQL fulltext indexes for searching. This is really terrible and really
inefficient. On easymodo, I'm using Sphinx (sphinxsearch.com), it performs
amazingly well, I'm just finishing up some details before pushing it to SVN.
In addition, you can also make some MySQL tweaking. I recommend at least the
following two tweaks on my.cnf:
low_priority_updates = 1
concurrent_insert=2
I'm not really sure what to cache with memcached even if I were to use it,
though. MySQL's query cache does a good enough job of caching queries (as long
as its cache doesn't get ruined by searches, as it is in your case). Memcached
would only be useful if you had a dedicated MySQL server with a cluster of
memcached servers or something. I doubt anyone is ever going to set up anything
like that in order to archive 4chan.
I'll give you a bit to make your case for it, but otherwise, I'm leaning
towards WontFix.
Original comment by eksopl
on 17 Sep 2011 at 12:12
Suppose I don't have any.
Original comment by aa...@installgentoo.net
on 20 Oct 2011 at 12:55
Original comment by eksopl
on 1 Nov 2011 at 5:18
Original comment by eksopl
on 19 Feb 2012 at 1:39
Original issue reported on code.google.com by
aa...@installgentoo.net
on 16 Sep 2011 at 11:40