How about going one step further and modify the accesslog table to not store data in the first place - execute this query through web config instead of as a db admin:

ALTER TABLE {accesslog} ENGINE = BLACKHOLE;

http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-engine.html

Comments

mfb’s picture

mfb
they or he
commented
Status: Active » Postponed (maintainer needs more info)

I'm not clear why this is useful.. why enable statistics module if you are not storing any statistics?

deekayen’s picture

deekayen commented
Status: Postponed (maintainer needs more info) » Active

It was meant as an example for the other ip_anon tables as well, though it hadn't occured to me at the time to disable statistics.

mfb’s picture

mfb
they or he
commented

for watchdog table simply disable dblog module.. comment table disable comment module.. the sessions table isn't really blackholeable unless you are somehow replacing the session subsystem.

deekayen’s picture

deekayen commented
Status: Active » Closed (works as designed)

I shouldn't post feature requests after 11pm.