MySQL Forums
Forum List  »  Memory Storage Engine

Memory load extremely high
Posted by: bastide christopge
Date: October 24, 2011 07:24AM


When I request SELECT * FROM dev_dwh.ods_ventes o on the table that contains 85 billion of rows, following message ‘The memory load of the system is extremely high. This is likely because of the current result being very large’ displays in about 1,5 billion of extracted rows.

How to do to extract the 85 millions of rows? Is it possible? Should it parameter anything in MYSQL Server? Or perhaps in RAM memory windows server?

Thank you very much for your help.

Best regards,


Options: ReplyQuote

Written By
Memory load extremely high
October 24, 2011 07:24AM
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.