Cant seem to reduce database size further

Hi kaitanium,

Are your photos saved in the database or wp-content/uploads folder?

wp content uploads. I just upload via the built in uploader.
how do you even go about saving into the database?

Hi kaitanium,

Your host is probably complaining about your disk usage.

You can use EWWW Image Optimizer Or WP Smush

Thanks.

somehow i doubt that is the case as that wouldnt be related to my database size right? Thats the literal hosting side which I am well below their limits for my contract.

I already optimize my images before uploading to wordpress.

email from the abuse team:

“Our Server Administration has found that your database dbxxxxxxxxx has exceeded the maximum allowed capacity of one gigabyte (1GB) in size. Our database server administrators have had to move your database to an auxiliary server so that it does not negatively impact other databases. As a result, your database may be inaccessible for a short time frame while the move is still ongoing. Once the move is complete, you database will be available again using the same credentials as before, but with limited resources and reduced performance. Please optimize your database, and website if necessary, so that it no longer exceeds the 1GB maximum limit. Once the database size has been reduced to within the acceptable limit, please contact us.”

checking my admin panel, it says that particular database is at 1183mb of the 1024 allotted. Goes up and down depending on the day even if I dont do anything. Yesterday was at 1195

I may just start deleting some old posts that i dont really need to see if that helps much.

just deleted about 40 posts and it didnt even make a single dent in the filesize. Bah.

Unless since they “moved” the db, i wonder if the db im cleaning up isnt reflected in my admin…

Hi kaitanium,

Use Better Delete Revision Manager. This would help. Let’s take for example, you have 200 posts and each post has 30 revisions; that means you are storing 6000 copies of data for just 200 posts in your database. Deleting the revisions will help.

Cheers.

I used it. Did nothing. Didn’t even save 1kb

Hmm really not sure what is going on. Deleted comments, deleted broken linked photos in the media folder, deleted comments. Not even a dent in the database size…

Hi kaitanium,

Do you have a plugin that stores large amount of data in the database?

That could be the problem.

I have 633 posts with 244 comments and my database size is 18.04 MB in size. I do use Revision Control to limit each post to 2 revisions.

If your webhost has phpMyAdmin accessible though cPanel or something, might want to look at the size of each table. View of mine for comparison: https://i.imgur.com/lPxcZ68.png

WOW ok that is VERY HELPFUL! Didnt know i could view all the tables like that within my phpMyAdmin. Saw that one of my plugins, as Ncej mentioned, was causing the high GB usage. The plugin that was eating up all the mem was WP Activity Monitor which I use to monitor the brute force attacks that come from time to time. I truncated that table and got 1.1gb back. Weird thing is that i cleared the plugin within the WP dashboard (no database optimizer could have cleared it) and I guess it did nothing.

Long story short. YES it was a plugin that was using alot of the database mem. This I suppose cant be cleared by any database cleaning plugin.

Thanks guys!

Glad you figured it out. This will certainly help others.