Tagged Questions
0
votes
2answers
351 views
MySQL how to release memory used up by SELECT
I executed an INSERT IGNORE combined with SELECT from large table. The SELECT took up 16GB of memory and went into SWAP before I terminated it with CTRL+C.
INSERT IGNORE INTO sid(sid)
SELECT sid ...
7
votes
4answers
2k views
MySQL Cluster RAM requirement
From MySQL 5.1, the data doesn't need to be entirely in memory anymore.
I've read that the indexed columns (I think the entire index structure) must still be in memory (MySQL High Availability, 2010, ...
