MySQL Forums
Forum List  »  Memory Storage Engine

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

Hello,

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,

Christopher

Options: ReplyQuote


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