Which db-tables can I empty before migration?
Posted: Tue Nov 13, 2012 1:31 pm
As mentioned in another request http://board.s9y.org/viewtopic.php?f=4&t=19004 I'm preparing for moving my s9y installation to another server. During 4 years the database has grown quite a bit. I don't have the original size any more but in 2009 the db-dump was some 800 KB and now it is 272 MB.
I wonder if I can "downsize" it a little bit before migrating. For instance there are over 1 million datasets in the spamblock bayes, of which I could certainly delete some. I also noticed that every single visit from years ago can still be found in the database.
Where else could I look for tables that have grown too large and be either emptied altogether or where I can delete at least the oldest datasets without losing important information and withou destroying something that is essential for s9y to funktion?
I wonder if I can "downsize" it a little bit before migrating. For instance there are over 1 million datasets in the spamblock bayes, of which I could certainly delete some. I also noticed that every single visit from years ago can still be found in the database.
Where else could I look for tables that have grown too large and be either emptied altogether or where I can delete at least the oldest datasets without losing important information and withou destroying something that is essential for s9y to funktion?