MySQL Forums
Forum List  »  Full-Text Search

Re: Err 1191 Can't find FULLTEXT .. need explanation please
Posted by: Rick James
Date: October 20, 2011 05:14AM

No advantage in having duplicate indexes:
FULLTEXT KEY `name_of_index` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle_2` (`pagetitle`,`longtitle`,`content`)
and a disadvantage: disk space.

> `deletedon` int(20) NOT NULL DEFAULT '0',
What are you hoping to put into that field? An INT can hold no more than 2 billion. Maybe you need BIGINT?

Indexing flags is usually useless:
> `uri_override` tinyint(1) NOT NULL DEFAULT '0',
> KEY `uri_override` (`uri_override`),

You may find that 255 is inadequate:
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`longtitle` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',

> I would like to know WHY ...
A SHOW CREATE TABLE _between_ the ALTER and the 'click' might a good clue.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Err 1191 Can't find FULLTEXT .. need explanation please
2506
October 20, 2011 05:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.