Hi,

I am trying to repair a MYISAM table with 3 million rows (REPAIR TABLE
customer -- without any QUICK etc). It takes over an hour, but after
that, the SELECTS work for a while but it still takes very long for
INSERTs and UPDATEs. What has happened? How can I diagnose this
problem?

Many thanks!

".ep" <erick.papa@gmail.com> schreef in bericht
news:1186753174.554445.5540@d30g2000prg.googlegrou ps.com...
> Hi,
>
> I am trying to repair a MYISAM table with 3 million rows (REPAIR TABLE
> customer -- without any QUICK etc). It takes over an hour, but after
> that, the SELECTS work for a while but it still takes very long for
> INSERTs and UPDATEs. What has happened? How can I diagnose this
> problem?
>
> Many thanks!
>

you should give more info on this table, like:
- how is it defined?
- which keys do exists?
- what version of mysql are you using?