Site disabled - DB running very slowly

circuit

My DB is really huge these days, and the cause seems to be the LUM_IPHistory table and the LUM_UserDiscussionWatch table. I've emptied LUM_IPHistory - is there anything i can do about the other one? It is running at about 60mb.

Dinoboff

You could delete the records for old discussion:
DELETE dw FROM LUM_UserDiscussionWatch as dw LEFT JOIN LUM_Discussion as d ON dw.DiscussionID = d.DiscussionID WHERE d.DateLastActive < DATE_SUB(NOW(), INTERVAL 365 DAY);

circuit

thanks dinoboff. i will give that a go.

fmimoso

Check out this add-on: http://lussumo.com/addons/index.php?PostBackAction=AddOn&AddOnID=382 ;)