Re: Any way to force sequential reading of index blocks?
I just found the IGNORE KEY command, and it solves my problem. So, when you have a large indexed MyIsam and you need to run a query that requires scanning of the entire table, you can force MySQL to scan the table reading the row data sequentially instead of reading it through the index, which results in fewer random seeks. This improved my running time 20 fold:
select max(value3) from test_table ignore key(primary)
(from the same test_table example in my original post)
Subject
Views
Written By
Posted
4518
August 19, 2009 02:21PM
Re: Any way to force sequential reading of index blocks?
2638
August 20, 2009 01:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.