In mysql 4.0.24 on debian sarge (Hardware:Pentuim4 2.8MHz, RAM: 2GB),
I have a table with 4GB. One of the 3 fields is of type text, and, of
course, when I make
select * from <table> where <textfield> like '%keyword%';
I have to wait too much, sometimes 10 minutes!
Well, like good friends you are, you will say, "index it!". Yes, I
will, but on the same server run several other services, so I cannot
permit the indexing take much more resources.
I searched google, mysql.org, googlegroups and others and read about
"delay insert", "--delay-key-write" and others good tools, ...