mysql: managing memory usage

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-05-21T21:28:14Z Indexed on 2010/05/21 21:30 UTC
Read the original article Hit count: 154

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql