MySQL Forums
Forum List  »  Performance

Re: MySql select * performance
Posted by: James Day
Date: December 20, 2004 04:40PM

You might consider increasing read_buffer_size. A few megabytes (8 perhaps) may make a significant difference if you currently have it set very low and this is a common operation for you. You can do this for just this query instead of changing the global setting, by typing or sending "set read_buffer_size=8*1024*1024;".

If it's not common you might get better results overall by adjusting the key_buffer_size value if you're using the MyISAM engine, since that can increase or decrease the amount of RAM allocated for caching of the indexes. You can still adjust read_buffer_size for a single connection when you're doing a bulk read.

Options: ReplyQuote

Written By
December 20, 2004 02:34PM
Re: MySql select * performance
December 20, 2004 04:40PM

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.