core_achievements_log table too big.

[Donnie95]

Hello,

This is the largest table in my database (500MB), how can I clear or limit these logs?

Thank you.

[teraßyte]

There is a setting that allows you to prune the logs: ACP > Members > ACHIEVEMENTS > Settings > Clear activity log.

[Donnie95]

7 hours ago, teraßyte said:

There is a setting that allows you to prune the logs: ACP > Members > ACHIEVEMENTS > Settings > Clear activity log.

If I lower the value to 6 month, will this remove the "Earned" date for achievements or ranks? I don't really want that.

[teraßyte]

1 hour ago, Donnie95 said:

If I lower the value to 6 month, will this remove the "Earned" date for achievements or ranks? I don't really want that.

Badge and ranks are saved in another table so the date is kept there. Not sure about achievement and I can't check right now, but I don't recall a separate table from the core_achievements_log one so you might lose the date there.