Can anyone here please explain me how myisam performs a full text search. I read the reference manual and i know about how mysql parses the text or varchar fields marked as full text. But it doesnot explain how mysql indexes these full text words. Are these words stored in the key buffer and then the search on them is also based on B-tree like on any other index?
Please help me understand the internals of full text search engine.
When benchmarking the performance of my application, the speed for full text search on a table with 5billion rows was substantially better than the speed of search by using primary key. I am baffled as to why should this be?
Why is it that with increase in the database size the performance in speed of searches reduces?
Larger data always means slower performance, especially as the data gets too big to fit into memory anymore. Full-text is built as two B-trees as I recall.