Using phpBB 3.08 with mysql DB.
Ive been working on 'fixing' one of my forums that seemed to have something wrong in a couple tables.
After fixing most of the problems and getting it from the bloated 13MB or so down to 1.8MB I then deleted some unneeded threads and posts to clear up more space.
But the DB size remained the same even though I deleted a large enough portion of threads that I should have seen some change.
So I used phpmyadmin to optimize the tables and I noticed that in a column called 'overhead' there were a few tables that had anywhere from a couple KB to over a hundred KB.
After optimizing this column was now empty and my DB lost another 2MB in size.
My question is this.
When I delete a thread does it really not actually GET DELETED but hangs around in the DB anyway ?
I mean, whats the point of deleting a bunch of old, unused threads from a forum if they are still attached to the DB anyway ?
My hosting company is very generous with DB size....2GB or something like that, so this wont be an issue, but I know people are are limited to 50MB and this could run out VERY quickly even if they are deleting older threads but the data isnt actually being 'deleted' from the database.
Other than using phpmyadmin is there some other way for a thread to BE deleted entirely....?
Secondly....is this a phpBB3 issue or is it a mysql issue ?
Is the data still being there and the tables needing to be optimized to get rid of it because of phpBB3 or simply an issue with mysql ?
If its mysql then I guess Im barking at the wrong people and need to go chew off some ears at the mysql boards instead