database cleaner?

[derwisz]

hi
does anyone have any tool to automatically clear database from long-time-not-used accounts
i mean deleting data in account db and automatically ereasing all bases related to this login; chars, their spells, bags etc
my game3g base is close to 300MB and every 6hours while backup is done, everybody get few seconds lag
thx

 

[TritoN]

300MB and get lag while backing it up? imagine a backup of like 40GB+ like we have on olymp
regarding ur question there isnt such tool afaik but u could create an sql script for doin this job

 

[derwisz]

well if don't find - i ask someone not related to mir
difference was strange to me and... .dat has 300mb, ldf: 24.5GB