Re: table hangs on a large query

[Randy Paries]

On 8/15/06, mos <[EMAIL PROTECTED]> wrote:

At 09:24 AM 8/15/2006, you wrote:
>Dan
>
>thanks for the help
>so i will remove the redundant keys
>below is the explain plans
>but here is the weird part.
>I exported the database and imported into a testDB to play with and
>the query that was giving me grief in the previous message returned
>immediately
>
>Thanks
>Randy

Randy,
         Then it could have been index corruption. You could do a back up
of the table  and then run a Repair Table on it (or MyISAMChk) and then
Optimize it.
See http://dev.mysql.com/doc/refman/5.0/en/repair.html

Mike

Mike

Thanks for the help,

I will try that this evening.

Is there some sort of maintenance i should be running on this db
routinely to help this?

Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]