From: Johan De Meersman Date: February 4 2011 7:06am Subject: Re: How do increase memory allocated to MySQL? List-Archive: http://lists.mysql.com/mysql/224301 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cdfff3c3c395d049b6f8732 --000e0cdfff3c3c395d049b6f8732 Content-Type: text/plain; charset=ISO-8859-1 2011/2/4 Yannis Haralambous > 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 --000e0cdfff3c3c395d049b6f8732--