Size of MySQL database

The optimal answer of course is to move hosts.
In the db that matters are you only running the basic tables? No stats, spam collection type code? There’s nothing you can cull from a normal install- it’s all needed.

Both sites are hosted by the same place. And the plugins are similar.

The oversize db has these two large tables: wp_sk2_logs running at 1.1MB and wp_sk2_spams at 512k.

Is it possible to delete these two tables and start again? If so how?

Login > manage > Spam Karma 2
Scroll to the bottom of that page and the reset options are there. If you keep phpmyadmin open in one window and that in another you can check effects. Much easier than messing with tables ??

Thanks Podz, what would we do without you!

The database has dropped to 2.77MB and I now have a teensy bit of breathing space.

Isn’t it possible to also clean up the tables where comments have been deleted and old posts/links/ whatever are stored? Old as in things you aren’t using anymore. It might be piece by piece but you could clear up a bit more space.

Look here:
https://codex.www.ads-software.com/WordPress_Site_Maintenance

Thanks Brittanie, that looks like a useful page of reminders.

Hi one of my database size 127mb and 15mb zipped. The questions is: what things that are incessary I can delete to reduce the size.

stats? On your experience… what could be a razonable size for one database?

Regards
@

They both sound quite large unless you have LOTS of posts.
If you want a comparison I have ~2300 posts and ~7000 comments and my exported non-zipped db is just over 11MB.

Stats you can reduce, you can empty the bad_behavior_log if you have one…

I have other tables in mine but the only ones I back up are the core tables because should things go wrong they are the only ones that matter to me.

Wow… well I backup everthing. I have 400posts & 50comments. The size total are 127mb non-zipped are 15mn zipped.

What could be wrong? A post too large? Backup only the core?

I gone a follow your advice.

@ndrés

Well, I know what it’s the problem. The size of table for stats. Ther are too bigger.

The plugin that cause this, are wp-shorstats.