MySQL Forums
Forum List  »  Memory Storage Engine

Re: Memory load extremely high
Posted by: Rick James
Date: October 30, 2011 03:54PM

(I doubt if this has anything to do with Engine=MEMORY.)

What is the context? Is the SELECT coming from Java, PHP, Perl, VB, commandline mysql, or something else? Which API are you using?

What will you do with 85M rows? Especially if you are getting them all at once?

SHOW CREATE TABLE.
I want to know what the PRIMARY KEY is. One solution may be to fetch only 100 rows at a time.

Options: ReplyQuote


Subject
Views
Written By
Posted
8588
October 24, 2011 07:24AM
Re: Memory load extremely high
3079
October 30, 2011 03: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.