Wordpress LScache Plugin: My phpMyAdmin postmeta is very large
Last Updated on: Wed, 15 Apr 2026 00:00:02 `A few days ago I installed the LiteSpeed ??Cache plugin on my site. Since installing, I have noticed that the size of my SQL database is increasing abnormally. My SQL database has grown from 4gb to 10gb. I noticed a lot more size of postmeta in my phpMyAdmin. screenshot- https://i.imgur.com/oRWSMqL.jpeg In this case, I have deactivated the Light Speed ??plugin. My database is now under control since reactivating. Even now the size of my database is not increasing abnormally. But I dont know the process of reducing the abnormal size of old postmeta database. screenshot- https://i.imgur.com/ndUiBY4.jpg Please help me, how can I clean my unwanted postmeta database? Thanks. The page I need help with: http://www.fileour.com/ I checked. The size of the backup database in my cPanel is only 30 MB. Screenshot- https://i.imgur.com/nrvuw6N.jpg But the size of phpMyAdmin is 10 GB. Hello. Is your backup zipped? Yes. My backup is zipped and after unzipped my database is 10GB. But why did my database grow abnormally and now how do I get it back to its previous position? Hi, please try analyze the table , to see what is the content that uses such space do you have a lot of images and run the image optmization ? the only thing LSCWP will write into postmeta table is image optm information but it only stores like 100 Byte per image, you will have to have like hundreds millions images to get that much space Best regards, @CacheCrawler Thanks for the suggestion. No, I dont have many images on my site. My site has a total of 900 to 1000 images. Two or three images per post. Even all my images have been optimized. I gave two screenshots of my database table. 1st screen ? https://ibb.co/GRj9Xym 2nd screen ? https://ibb.co/h9hdL6F Hope you help me more. Thanks. Hi, these screenshot didnt provide any useful information please try to check what are the excessive rows in it Best regards, Hi, Im going to mark this topic Resolved , due to lack of activity. If you still need help, please feel free to re-open it. When re-open it, please also change the topic status to not solved Best regards,
LiteCache Rush: Speed comes from using less, not from doing it faster
Reference