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)