Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Site disabled - DB running very slowly

edited October 2008 in Vanilla 1.0 Help
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.

Comments

  • edited October 2008
    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);
  • thanks dinoboff. i will give that a go.
  • fmimosofmimoso
    edited October 2008
    Check out this add-on: http://lussumo.com/addons/index.php?PostBackAction=AddOn&AddOnID=382 ;)
This discussion has been closed.