List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:February 4 2011 7:06am
Subject:Re: How do increase memory allocated to MySQL?
View as plain text  
2011/2/4 Yannis Haralambous <yannis.haralambous@stripped>

> SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'
>

That won't use a regular index. Have a look at fulltext indexing.

For the phpmyadmin, I personally feel it's an abomination, not to mention a
disaster waiting to happen; but if you really want to keep using it, you'll
probably have to set the PHP script runtime timeout to something
appropriately high to accomodate the long query runtimes. This can be done
from within the script if neccesary, look at the PHP documentation for that.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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