I'm helping a friend with his phpbb 3.0.11 forum. We want to upgrade to 3.0.12 and from there to 3.1.x or maybe directly from 3.0.11 to 3.1.x.
However, I'm wondering about his database size. Its 466 MiB big and we would like to try and clean up as much as possible, before upgrading.
This I found under maintenance -> search index:
I've managed several forums but 466 MiB seems a little bit very big for the kind of forum my friend is running.Total number of indexed words: 287365 Total number of word to post relations indexed: 4908190
The cause is not the attachments, because they are already outside of the database in a directory, so they don't count for the size of the database.
Is there a way we can see what is causing this big size? Or a way to decrease the size?
PhpBB version 3.0.11
Php version 5.4.36
Mysql version 5.5.41