serendipity_spamblocklog

jaal · Post by **jaal** » Sat Jan 05, 2008 6:51 pm

Hi,

is there any way to deal automatically with the serendipity_spamblocklog table?
I'm currently moving to a bigger server and noticed that the serendipity_spamblocklog table does take over 150MB on the disk (and is still growing...)

Is there any switch to disable the writing to the database or an automatic retention time?

Thanks
Jan

P.S.: When the import is finished I will let you know how many entries are in the table...

Harald Weingaertner · Post by **Harald Weingaertner** » Sat Jan 05, 2008 7:32 pm

What about configuring the Spam-Protection Event Plugin? The second last entry should be set to "No logging" (or whatever it is called in english)

I have disabled the logging and everything is fine...

PS:
Protokollierung von fehlgeschlagenen Kommentaren
Die Protokollierung von fehlgeschlagenen Kommentaren und deren Gründen kann auf mehrere Arten durchgeführt werden.
(sprichst ja scheinbar deutsch)

jaal · Post by **jaal** » Sat Jan 05, 2008 7:55 pm

I knew there was something about not seeing the forest for the trees...

I'll give it a try. The db file is currently about 900 MB and still growing...

Thanks
Jan

jaal · Post by **jaal** » Sat Jan 05, 2008 8:22 pm

Just for the record: I killed the import after 2 hourse and > 2 Million lines...

Even the log can be disabled maybe there should be automatic retention time added.

Jan

Post by **garvinhicking** » Mon Jan 07, 2008 5:49 pm

Hi!

Even the log can be disabled maybe there should be automatic retention time added.

We follow the thought that if people enable logging, they want to log everything. So users should decide when to purge their logs. If they don't need logging, or need special retention times, they can use file logging and logrotate on the server's system.

Adding retention checks in a web application just leads to performance slowdowns, because on every pagerequest you'd have a query that would need to purge old records.

Regards,
Garvin