Thanks, Tim. I installed it and we'll see if it cures the problem.
Whether or not it does, I see an immediate improvement in performance
that's impressive. For any lurkers who are running MW on Mac OSX,
this site has a link to an installer shell script for some of the
prereqs.
http://www.lullabot.com/articles/setup-memcached-mamp-sandbox-environment
This allows you to avoid fink (which I don't like). I stopped after
the shell installer for memcached, as I understand it MW already has
the PHP part.
I confess that I had been scared off of memcached by some of the stuff
in the memcached.txt documentation about security, and the statement
about it not being worth it for a small site. I think I misread that
as small in terms of users rather than small in terms of pages. We've
grown the latter very quickly on our wikis.
Jim
On Jul 5, 2008, at 7:57 PM, Tim Starling wrote:
Jim Hu wrote:
We've been getting this a lot lately at
EcoliWiki:
> A database query syntax error has occurred. This may indicate a bug
> in the software. The last attempted database query was:
> INSERT IGNORE INTO `objectcache` (keyname,value,exptime) VALUES
> ('colipedia:sitenotice','U��N�0D�|
You should switch to memcached. That would avoid the query and improve
performance at the same time. It's quite plausible that the extra
locks
introduced into transactions by objectcache would cause deadlocks.
-- Tim Starling
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
=====================================
Jim Hu
Associate Professor
Dept. of Biochemistry and Biophysics
2128 TAMU
Texas A&M Univ.
College Station, TX 77843-2128
979-862-4054