[Mediawiki-l] patch-backlinkindexes.sql

[Greg Sabino Mullane]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> ... Specified key was too long. Max key length is 500

This is a MySQL bug related to the way indexes counts bytes 
and not characters. This in turn is because MySQL has a limitation 
on the number of total bytes one can use in an index. For more 
information, see:

http://bugzilla.wikimedia.org/show_bug.cgi?id=1322

> Any suggestions?

There are four things you can do, in order of ease:

1) Change the index definitions (see the bug above for examples)
2) Don't use UTF-8.
3) Use Postgres
4) Recompile a custom MySQL with a larger limit

- --
Greg Sabino Mullane greg at turnstep.com
PGP Key: 0x14964AC8 200703211008
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFGATynvJuQZxSWSsgRA0bnAJ9FpMAV+VED+EccARlLy+AJuGAElQCbBtZp
lpDX8MR3hajKwceaqBEmx+w=
=KUGG
-----END PGP SIGNATURE-----