Re: just messed up my index on my table....ugh

2003-10-03 Thread Matt Babineau
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

Re: just messed up my index on my table....ugh

2003-10-03 Thread Jeremy Zawodny
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

just messed up my index on my table....ugh

2003-10-03 Thread Matt Babineau
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

just messed up my index on my table....ugh

2003-10-03 Thread Matt Babineau
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