Juanma Barranquero wrote:
A few questions about database tables:
- It is safe to assume that, after a successful upgrade to 1.5, the
following tables are not needed and can be dropped: blobs,
brokenlinks, cur, links, linkscc and user_rights?
Yes (unless you've engaged the special blob mode of the upgrade in which
case cur entries may still be used for text storage. But chances are you
haven't done this, since you need to set a secret variable and use the
alternate upgrader script. :)
- maintenance/tables.sql specifically singles out
searchindex as
having to be MyISAM. What about trackbacks, transcache and
user_newtalk, whose create instructions do not specify an storage
engine?
searchindex must be MyISAM because InnoDB does not support the fulltext
index type. You may have deadlocking troubles with ipblocks on a busy
site on InnoDB; if you do try switching it to MyISAM.
Nothing else requires being MyISAM; the InnoDB forcing was probably just
left out.
- And speaking of transcache, it is needed for
day-to-day
operations, or it is an artifact of the updating procedure? (It is not
listed in maintenance/tables.sql.)
I'm not sure what exactly is the status of this... but it won't be used
unless you've enabled interwiki transclusions.
-- brion vibber (brion @
pobox.com)