Posted by Stefan Rybacki on 09/26/05 16:00

Bob Bedford wrote:
>> Did you try to optimize, repair, check or analyze table type? Don't
>> worry different sizes of tables on same data, this could happen
>> because of fragmentation because I guess you already worked on the
>> type table but didn't on the new tbltype table.
>>
> Hello Stefan,
>
> thanks for your help.
>
> I've tried everything. Now, I've dropped indexes from the tbltype (the
> copy of type table) and the error doesn't occur anymore.
> As soon as I add 2 indexes, then sometimes the error appear again.
>
> Why can't I add more than a Primary key and one index ?

Not sure about that. What kind of index was it? Are makecode and and modcode primary keys?
If yes you don't need indices on them. But consider mysql can only use one index per
table, so if you're often seraching or connecting by a non primary key attribute a
combined index makes sense.
But your problem is really odd and shouldn't appear. What are you specs (cpu, ram, mysql
version, os, hdd, configuration)?
It seems there is something wrong with your configuration since you told me its working
fine under winxp (same specs besides linux?).

Regards
Stefan


>
> Bob
>

[Back to original message]