In the last episode (Jul 30), xuefer tinys said:
> i'm using mysql 4.x
> it is said the query result is cached by mysql for next query
> i have a forum, having "post" table post: postid, title, content,
> postdate, clickcount and clickcount is increased when the post is
> and a page to search post
> select * from post where title like "%word to match%"
> will this result cached by mysql ?
From the manual: http://www.mysql.com/doc/Q/u/Query_Cache_How.html
If a table changes (INSERT, UPDATE, DELETE, TRUNCATE, ALTER or DROP
TABLE|DATABASE), then all cached queries that used this table
(possibly through a MRG_MyISAM table!) become invalid and are
removed from the cache.
If you want searches on title or content to cache, you'll have to move
them to another table.