List:General Discussion« Previous MessageNext Message »
From:Kevin Spencer Date:February 4 2011 11:00pm
Subject:Re: How do increase memory allocated to MySQL?
View as plain text  
2011/2/3 Yannis Haralambous <yannis.haralambous@stripped>:
>
> what am I doing wrong?
>
> the query was just
>
> SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'

When you use a leading wildcard symbol, MySQL will do a full table
scan regardless of any indexes you've created.  If you've got a MyISAM
table, I recommend a FULLTEXT index.

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

--
Kevin.
Thread
How do increase memory allocated to MySQL?Yannis Haralambous4 Feb
  • RE: How do increase memory allocated to MySQL?David Brian Chait4 Feb
    • Re: How do increase memory allocated to MySQL?Yannis Haralambous4 Feb
      • Re: How do increase memory allocated to MySQL?Johan De Meersman4 Feb
      • RE: How do increase memory allocated to MySQL?Jerry Schwartz4 Feb
      • Re: How do increase memory allocated to MySQL?Kevin Spencer5 Feb
        • Re: How do increase memory allocated to MySQL?Feris Thia5 Feb
RE: How do increase memory allocated to MySQL?David Brian Chait4 Feb