BubikolRamios
01-24-2010, 09:15 AM
1. two tables: master, detail , key = field id on both
2, select from each separately works fine
3.all looks ok , key are where they shold be
4. join on id, hangs (100% cpu) or takes at least 5-10 minutes to do something, didnt wait to the end rebotted machine
1.Repair says it is already all ok
2. join , again 100% cpu ...
3.copy both to test and test1 table with create table ... as, set keys on test, join on test tables OK
4.mysql query browser, delete keys on master and detail , save, set keys save, and join OK !!!
Expirinenced this twice in past few days. Is there something else besides REPAIR ?
2, select from each separately works fine
3.all looks ok , key are where they shold be
4. join on id, hangs (100% cpu) or takes at least 5-10 minutes to do something, didnt wait to the end rebotted machine
1.Repair says it is already all ok
2. join , again 100% cpu ...
3.copy both to test and test1 table with create table ... as, set keys on test, join on test tables OK
4.mysql query browser, delete keys on master and detail , save, set keys save, and join OK !!!
Expirinenced this twice in past few days. Is there something else besides REPAIR ?