Its weird, I dropped the indexes off that table, and re-added them but
the queries used to take 5 sections but now take much much longer.
I did a little reading on the EXPLAIN command and it looks like my query
without an index has 9427^15 rows to query. So thats where I am seeing
the huge timeout
On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote:
> now the query isn't finishing executing and its killing my cpu...
>
> any idea how to rebuild the index on a table?
>
> or how to get out of this mess?
Drop and re-add the index?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQ
now the query isn't finishing executing and its killing my cpu...
any idea how to rebuild the index on a table?
or how to get out of this mess?
:-)
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
now the query isn't finishing executing and its killing my cpu...
any idea how to rebuild the index on a table?
or how to get out of this mess?
:-)
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO