DB too big?

[Xanthouos]

It's showing in my cpanel: SQL Disk usage: 83.87 Megabytes
The folder where s9y is installed uses: 40.32 Meg

Is there something wrong with m DB? It's been updated several times. I'd actually like to do a fresh install, (not sure if it would improve anything) but keep all the posts, stats, comments, etc.

Apparently it's version: 1.2-alpha2

Here's the mysql tables:

Code: Select all

butlers_sblog (40)

    * Browse sblog_access
    * Browse sblog_authorgroups
    * Browse sblog_authors
    * Browse sblog_category
    * Browse sblog_comments
    * Browse sblog_config
    * Browse sblog_entries
    * Browse sblog_entrycat
    * Browse sblog_entryproperties
    * Browse sblog_exits
    * Browse sblog_groupconfig
    * Browse sblog_groups
    * Browse sblog_images
    * Browse sblog_mediaproperties
    * Browse sblog_options
    * Browse sblog_permalinks
    * Browse sblog_photoblog
    * Browse sblog_plugincategories
    * Browse sblog_pluginlist
    * Browse sblog_plugins
    * Browse sblog_references
    * Browse sblog_referrers
    * Browse sblog_shoutbox
    * Browse sblog_spamblocklog
    * Browse sblog_staticpages
    * Browse sblog_staticpages_types
    * Browse sblog_suppress
    * Browse serendipity_authors
    * Browse serendipity_category
    * Browse serendipity_comments
    * Browse serendipity_config
    * Browse serendipity_entries
    * Browse serendipity_entrycat
    * Browse serendipity_entryproperties
    * Browse serendipity_exits
    * Browse serendipity_images
    * Browse serendipity_plugins
    * Browse serendipity_references
    * Browse serendipity_referrers
    * Browse serendipity_suppress

[Xanthouos]

I was browsing the DB and I noticed that the sblog_spamblocklog table has 49,213 Records and is 79,1 MB in size.....

Any thots????

[garvinhicking]

Hi!

Yes, the spamblocklog can grow to some size. You can EMPTY (NOT! Truncate/delete) that table, since it only contains logs you don't need for running s9y...

HTH,
Garvin

[Xanthouos]

It's just a log? It's not going to allow all the blocked spam back in?

I have cpanel, and went into phpmyadmin. when browsing that table, and clicking on the "Empty" tab at the top, it says: Do you really want to truncate table sblog_spamblocklog?

So how am I to properly do it?
Do I "check all" at the bottom and click on delete? ...but with over 50,000 entries, might take some time.....

[garvinhicking]

Hi!

Just a log, no spam will be inserted if you delete it. It's only for historical reasons, like an apache access_log.

Sorry, I meant to write "NOT! Remove/Delete". Truncate is the same as empty, so that's okay. Sorry for the confusion.

Best regards,
Garvin

[Xanthouos]

ahhh, ok. Thanks so much. Amazing how fast it fills up though...just a few minutes later, already had over 30 entries.

[Maynard]

I too have found out that I was logging blocked spam to my MySQL database (seems like an odd thing to have turned on by default... or did I turn it on?).

However I don't have phpmyadmin installed. Is there a hearty soul out there that might know the MySQL prompt commands used to clear the tables?

I'm still using 0.9 if it matters.


Thanks.

[garvinhicking]

Hi!

Via MySQL prompt you can use:

TRUNCATE TABLE serendipity_spamblocklog

to empty the spamblock logging stuff.

HTH,
Garvin

[Neut]

Best clean up tip ever!

I disabled the Spam-plugin logging and emptied the spambloglogging table. My 'localhost.sql' went from 275 MB (no typo) to 1.41 MB (both uncompressed files). Holy MegaBytes Batman!

You may want to add this to the S9Y FAQ.