On Tue, Jan 07, 2003 at 10:41:07AM -0500, Adam Nelson wrote:
>
> If I'm getting copying to temp table often on some big queries, I
> usually increase tmp_table_size, but for innodb, is that variable
> used or is it innodb_buffer_pool_size?
I'm 63% sure it's still tmp_table_size.
--
Jeremy D. Zawo
Use fulltext indexes (http://www.mysql.com/doc/F/u/Fulltext_Search.html).
Queries with LIKE '%...%' will always be slow because they can't use
indexes, and you're doing SIX of them, of course it'll take a while. Only
drawback of fulltext indexes is (AFAIK) you can't match against fields in
separat
