Tagged Questions
0
votes
2answers
350 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 ...
3
votes
1answer
453 views
mysql, changing tables from myisam to ndb
Gents,
Converting a table from myisam to ndb via:
ALTER TABLE piwik_log_profiling ENGINE NDBCLUSTER;
This will fail with:
BLOB column 'query' can't be used in key specification with the used ...
