List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 30 1999 1:39am
Subject:myisamchk check is bad
View as plain text  
>>>>> "Ondrej" == Ondrej Koala Vacha <koala@stripped> writes:

Ondrej> Description:
Ondrej> I have two tables:

Ondrej> table			rows
Ondrej> polozky                 363157
Ondrej> doklady			16325

Ondrej> and sql statement:

Ondrej> select sum(polozky.cena) from polozky,doklady where
> polozky.doklad=doklady.faktura

Ondrej> after explain:

Ondrej> table   type    possible_keys   key     key_len ref     rows    Extra
Ondrej> doklady index   faktura faktura 10      NULL    16325   Using index
Ondrej> polozky ref     doklad  doklad  10      doklady.faktura 26

Ondrej> time of select:
Ondrej> sum(polozky.cena)
Ondrej> 30914400.90

Ondrej> real    0m12.694s
Ondrej> user    0m0.020s
Ondrej> sys     0m0.010s

Ondrej> $ myisamchk bondtest23/polozky
Ondrej> Checking MYISAM file: bondtest23/polozky
Ondrej> Data records:  363157   Deleted blocks:       0
Ondrej> - check file-size
Ondrej> - check key delete-chain
Ondrej> - check record delete-chain
Ondrej> - check index reference
Ondrej> - check data record references index: 1
Ondrej> - check data record references index: 2

Ondrej> $ myisamchk bondtest23/doklady
Ondrej> Checking MYISAM file: bondtest23/doklady
Ondrej> Data records:   16325   Deleted blocks:       0
Ondrej> - check file-size
Ondrej> - check key delete-chain
Ondrej> - check record delete-chain
Ondrej> - check index reference
Ondrej> - check data record references index: 1
Ondrej> - check data record references index: 2
Ondrej> - check data record references index: 3

Ondrej> explain:

Ondrej> table   type    possible_keys   key     key_len ref     rows    Extra
Ondrej> doklady index   faktura faktura 10      NULL    16325   Using index
Ondrej> polozky ALL     doklad  NULL    NULL    NULL    363157  where used

Ondrej> and time of select is now infinite


Hi!

Could you mail me the output of:

myisamchk -dvv bondtest23/polozky

I assume that the rec/key value is wrong (I just fixed this for 3.23.2)

You can probably fix this by doing:

myisamchk -a bondtest23/polozky

Regards,
Monty
Thread
myisamchk check is badOndrej Koala Vacha10 Jul
  • myisamchk check is badMichael Widenius30 Jul