SELECT * FROM big_federated_table causes OOM
Running
SELECT * FROM big_federated_table;
causes the server to OOM. Linux tries to kill mysqld and panics, but this is a different question.
It appears the federated storage is transferring the remote table entirely into virtual memory. Is this A) expected behavior, and B) a configurable? say, maybe transfer remote table into a local temporary file instead of into virtual memory?
The remote tables in this case was 10GB. Some are 100GB. We may be able to workaround this with hundreds of gigabytes of swap, but a temporary table option would be better...
Let me know if I should file a bug report for this issue.
CentOS release 5 (Final)
Server version: 5.1.22-rc-community-log MySQL Community Edition (GPL)
Linux db 2.6.18-8.el5 #1 SMP Thu Mar 15 19:46:53 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
Subject
Views
Written By
Posted
SELECT * FROM big_federated_table causes OOM
6867
December 06, 2007 11:27AM
4120
February 28, 2008 02:34AM
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.