Hi! On Feb 24, Tobias Lind wrote: > Hello! > I never got any comment on this one... > Have noone else observed this behavior? > I'm a bit worried to use this in my production site without knowing if it's > and indication of some problem with FULLTEXT indexes... :) > > Regards, > Tobias Lind
It's ok, as "cardinality" is meaningless for FULLTEXT indexes. > Hi! > I have a question regarding "Cardinality" for FULLTEXT-indexes. > > I have a table with 9 indexes - the last 3 indexes are FULLTEXT. > When I run "show index from <table>", the last index (FULLTEXT) always shows > cardinality=NULL... > Is this normal? ...everything seems to work ok when I do selects using the > index... > > I ran "analyze table" and got the response "Table is already up to date" > I shut down mysqld, ran "myisamchk -a" and it went througt the first 8 > indexes quickly, but on the last one it did a "check record links", going > through all rows in the table. > After I started mysqld up again and ran "show index from <table>", I still > got cardinality=NULL for the last index. > Ran "myisamchk -a" again, and it behaved just like the first time - passed > the first 8 indexes quickly, and went through all rows on the last index. > > I'm running MySQL 4.0.10, rpm-binary version. > Red Hat Linux 8.0 > Dual P3400 MHz, 768 Mb RAM. > > On other tables (with less number on indexes), I have always got a > cardinality after running "analyze table" also on fulltext-indexes. > > Could this be a bug? Something to worry about? > > Regards, > Tobias Lind 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
