Re: Sudden drop in performance on MyISAM DB

[william Warwick]

ok i am now good and proper confused...

Ive been working with the collected evidence from a few people here, so i decided to put everything in the same place and see what comes out.

I reloaded the database form a dump and restarted MySQL and did the same SHOW CREATE TABLE's as my first post, and found that the indexing was on from the beginning. (Confusion point 1)
I then checked that i had the same settings in my my.cnf as per my first post, and restarted again.

I then checked the queries myself and found that the select in my posts so far IS in fact a de-hibernated version of the origional query we had issues with (confusion point 2)

I then checked the same query against the clients live database, and it took 30 secs to get 3 results (confusion point 3)

And finally, ran it against my own copy of the DB... 0.1secs for 0 results. (Confusion point 4).

... it seems to be gone.

... ive got to be missing something here