Hi!
On Sep 13, Doug Poland wrote:
One question per line, please !
> Problems is knowning how many columns can be indexed in a table.
max 16 columns per index.
max 32 indexes per table.
so 16*32=512 columns can be indexed in a table, which is less then
max 3398 columns per table.
> Is that number including non-FULLTEXT indexes as well?
Yes.
> Is the 500 char/index limitation a compile-time option?
Probably, yes, but it may be not that easy to increase.
And, anyway, 500 char/index does NOT apply to FULLTEXT indexes.
> I've got some
> more questions about the behavoir of FULLTEXT but am leaving for
> the weekend and will ask on Monday. Thanks for your help so far!
you're welcome.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php