MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: How to speed up query of indexed column with 5M rows?
Posted by: Björn Steinbrink
Date: October 12, 2006 07:57PM

Try to increase the myisam_sort_buffer_size and maybe the read_buffer_size.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to speed up query of indexed column with 5M rows?
24407
ryan zheng
October 09, 2006 06:34AM
Re: How to speed up query of indexed column with 5M rows?
8989
Larry Kagan
October 09, 2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?
7516
ryan zheng
October 10, 2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?
6842
Larry Kagan
October 10, 2006 08:45AM
Re: How to speed up query of indexed column with 5M rows?
6539
Björn Steinbrink
October 12, 2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?
6518
Toa Sty
October 09, 2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?
6116
ryan zheng
October 09, 2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?
5087
KimSeong Loh
October 09, 2006 07:54PM


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.