(David A. Wheeler <dwheeler(a)dwheeler.com>)m>):
However, if all wikitext is removed from MySQL and placed
in the filesystem, splitting out the MySQL database on a
separate machine may not buy much. Then, most of the work
would be then done by the filesystem, with only housekeeping
metainformation being accessed through MySQL, and only when
editing or accessing special pages.
You'd be surprized how much of Wikipedia's work is the
"housekeeping". There are 102 fields in the database; we're
talking about moving 2 of them ("cur_text" and "old_text") out
to the filesystem. Yes, that's the largest /quantity/ of data,
but it doesn't represent most of the work. It does, however,
represent big chunks of memory out of MySQL caches and lots
of data sent over the protocol.
--
Lee Daniel Crocker <lee(a)piclab.com> <http://www.piclab.com/lee/>
"All inventions or works of authorship original to me, herein and past,
are placed irrevocably in the public domain, and may be used or modified
for any purpose, without permission, attribution, or notification."--LDC