Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
in Q2A Core by
edited by

My site has 85 users, 112 questions, 141 answers, and 557 comments. Yesterday I moved All uploaded files from the database to disc. Despite all these low numbers, the Admin/Stats section shows that the database size is now 10.7 MB which seems to be a bit huge. 

Is this databse size normal? 

Q2A version: 1.6.3

1 Answer

0 votes

I have studied the movement of Q2A database in this matter. When you move blob data to disk, blob contents in database will be empty. But, depending on the server type and configuration, MySQL may not release the space that was reserved. And, your database might be a bit huge in other causes (e.g. index for search, etc). Try operation below after backup your DB.

  1. Optimize all tables with phpMyAdmin
  2. "Admin" > "Stats" > "Reindex content"

I have not seen your database, my advice may not be effective.

@sama55: Could you please give more details on how to "Optimize all tables with phpMyAdmin"?