Re: query stopped working

2004-10-28 Thread J S
After I ran some database updates last night, it seems to be working OK again today. Not sure what happened! Thanks anyway. JS. Hi. Uncommon situation. Please tell me, what OS do you use, MySQL version and how was it compiled? Is there any clues at the end of .err file? "J S" <[EMAIL PROTECTED]>

Re: query stopped working

2004-10-28 Thread Gleb Paharenko
Hi. Uncommon situation. Please tell me, what OS do you use, MySQL version and how was it compiled? Is there any clues at the end of .err file? "J S" <[EMAIL PROTECTED]> wrote: > Hi, > > I have this query which used to work really fast but now it just seems to > lock up the tab

query stopped working

2004-10-27 Thread J S
Hi, I have this query which used to work really fast but now it just seems to lock up the tables. I tried running it with EXPLAIN but it just hangs at the command prompt. I also tried adding the USE INDEX directives but still no luck. I've run myisamchk -m on both tables involved and no errors w