Hello
I have large forum ( 3m posts, 380k thread, 120k blog entries, 60k member, 1m visitor messages)
Database size before upgrade was 3.2GB
Database size After upgrade to vBulletin 5.1.6 are around 12G (excluding the old tables will be around 7G)
upgrade to 5.1.7 still processing something related to visitor messages notifications (since long time, through cli). it seems it will never finish
new closure table: ~ 21m records, 3.1GB
new text table: ~ 3.7m records, 2.9GB
new node table: ~ 3.8m records, 2.5GB
The upgrade is done on test copy of the database.
The problem, big database size will make it very difficult to backup, migrate, do everything regarding the database.
I cannot live with this increase of size, which I think it is unnecessary. In fact, this will make me refrain from upgrading my real forum ( though I really loved vBulletin 5)
otherwise. I need a solution (even if it required modification to vBulletin or whatever)
keep in mind that I am very well in technical side. I can even manage to create my own "import script" if that can resolve the problem)
thanks
I have large forum ( 3m posts, 380k thread, 120k blog entries, 60k member, 1m visitor messages)
Database size before upgrade was 3.2GB
Database size After upgrade to vBulletin 5.1.6 are around 12G (excluding the old tables will be around 7G)
upgrade to 5.1.7 still processing something related to visitor messages notifications (since long time, through cli). it seems it will never finish
new closure table: ~ 21m records, 3.1GB
new text table: ~ 3.7m records, 2.9GB
new node table: ~ 3.8m records, 2.5GB
The upgrade is done on test copy of the database.
The problem, big database size will make it very difficult to backup, migrate, do everything regarding the database.
I cannot live with this increase of size, which I think it is unnecessary. In fact, this will make me refrain from upgrading my real forum ( though I really loved vBulletin 5)
otherwise. I need a solution (even if it required modification to vBulletin or whatever)
keep in mind that I am very well in technical side. I can even manage to create my own "import script" if that can resolve the problem)
thanks
Comment