I'm working on improving the performance of our 4-node MySQL cluster for a webapp with lots of DB writes. We've got a Solr index sitting 'on top' of the SQL in order to give us fast querying, and we ...
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 ...
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, ...