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 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 --------------------------------------------------------------------- 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
