Im not sure why my text contents taking too much DB storage, It is only pure text and 1 featured image. Currently I have 300k row in my DB, it is already optimized but its already about to reach 5GB. Im a total newbie with DB I only used customized theme. I think there is no issue with the current DB schema but i was wondering why text contents have so much size even i exported the whole wp\_post table it only took 160mb.
This is my website [https://maxlevelscan.com/]) im posting light novels.
DB size – [https://ibb.co/RhX1Bdn])
table structure-[https://ibb.co/zmMB4Ly])
exported wp\_post -[https://drive.google.com/file/d/1f\_dvjhKSKekCMsfq3cUE9F-eLwUhzYsV/view?usp=sharing])
The database storage files are in a binary format with more features than just UTF-8 text encodings. So your post content being “pure text” doesn’t necessarily mean these storage files will be “light weight” and be measured in MBs instead of GBs.
What is the size off a MySQL dump?
If your `wp_post` table is 4.9GB, it is what it is. The most viable options you have for reducing this is probably removing post revisions from the table, if you’re using them.