On Mon, Oct 24, 2011 at 2:08 PM, Fred Zimmerman <zimzaz....@gmail.com>wrote:

> while we're on the subject, a question about MySQL: is it possible to make
> MW independent of MySQL innodb tables? Innodb tables have a number of
> attributes that can make set up a pain (e.g. file and log sizes).
>

There should be nothing relying specifically on InnoDB that I know of; we
default to InnoDB for everything possible because it's the only sane table
type widely available on standard MySQL installs (and it should fall back to
whetever the server default is if you don't have InnoDB).

If you do choose to use non-InnoDB tables, I recommend using something else
that is designed to work with transactions and survive server crashes (eg,
DO NOT USE MyISAM)

As noted in other replies, you can tweak $wgDBTableOptions to change the
default table type used when creating new tables; you can change existing
ones with an ALTER TABLE at any time.

-- brion
_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to