Threads deleted by SQL database not shrinking

noobnewb · Post by **noobnewb** » Fri Sep 24, 2021 7:35 am

Hi there, running phpbb 3.2.9. Deleted multiple pages of threads (not multiple pages of a single thread, but several dozen threads). Have cleared cache, but the size of the SQL database is not shrinking. A random search using one of the thread IDs didn't show a result, so it does look like things were deleted successfully. What's going on? How can we get the DB size to go down when threads are deleted?

david63 · Post by **david63** » Fri Sep 24, 2021 8:10 am

What table type are toy using and if it is MyISAM have you optimised the database?

noobnewb · Post by **noobnewb** » Sun Sep 26, 2021 9:31 am

innodb v10. we have not optimized yet.

noobnewb · Post by **noobnewb** » Thu Sep 30, 2021 4:08 am

any other comments? when we search the tables, old threads do seem like they're gone.

warmweer · Post by **warmweer** » Thu Sep 30, 2021 9:44 am

noobnewb wrote: ↑Sun Sep 26, 2021 9:31 am innodb v10. we have not optimized yet.

Then "optimise" the tables (defragmenting) to see whether that reduces db-size.

rxu · Post by **rxu** » Sat Oct 02, 2021 4:13 am

noobnewb wrote: ↑Thu Sep 30, 2021 4:08 am any other comments?

Not only posts table can affect database size, it could also be for example sessions table or search index tables. Are they big for your DB?

Post by **thecoalman** » Sat Oct 02, 2021 6:24 am

A quick Google search tells me under certain configurations MySQL doesn't release the disk space. However it should not increase until that space is filled.