Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Sorted index pages - physically reorder on disk? [message #1584] Mon, 13 August 2007 15:53 sean Messages: 6 Registered: January 2007 Junior Member This may apply to other engines but I'm primarily focused on myisam. When using optimize table or myisamchk --sort-index, the manual states "Sort index blocks. This speeds up 'read-next' in applications." During this process, does mysql physically sort the index pages on disk to improve sequential io? Ex: a range lookup on a single column index... it would be great if this was sequential and only required one seek. Thanks in advance. Report message to a moderator

	Sorted index pages - physically reorder on disk? By: sean on Mon, 13 August 2007 15:53
	Re: Sorted index pages - physically reorder on disk? By: Peter on Thu, 16 August 2007 05:25
	Re: Sorted index pages - physically reorder on disk? By: sean on Mon, 20 August 2007 12:01
	Re: Sorted index pages - physically reorder on disk? By: sterin on Mon, 20 August 2007 18:38
	Re: Sorted index pages - physically reorder on disk? By: sean on Mon, 20 August 2007 18:44
	Re: Sorted index pages - physically reorder on disk? By: sterin on Mon, 20 August 2007 19:14

Previous Topic:	Difference between Falcon's and InnoDB's row level locking/MVCC
Next Topic:	varchar vs char

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]