mysql: managing memory usage
- by every_answer_gets_a_point
i am doing a delete with a LIKE statement
my keybuffer is 25m, the sort buffer size is 256k
the delete has been taking over 2 hours
should i increase memory usage? there are about 50 megs of data in the table from which i am deleting, thats about 500,000 rows
is there anything else i can do on the adminsitration size to speed up this delete?