Only log mob data for named entities

[Thedysons]

Basically title, logging all mob data is saving a bunch of junk data that's bulking up the DB thanks to the large amount of mob farms on my server but there are a few cases where having mob data is valuable such as where villager halls and pets are concerned.

It would be ideal if only actions related to named entities were saved. I haven't searched for 3rd party solutions but I haven't seen any options in the config/wiki that would allow this nor did I get a response in the discord when I made an inquiry about it so I apologize if its already a feature/duplicate.

[tonyjamesstark]

I'd like to bump this. Our database needs regular purges every few months or so due to ballooning size, to the point where it's impeding server backups if we use sqlite, and is prohibitively expensive if using mysql.

I did a bit of digging: the vast majority of the space taken is by the entity table, largely due to the serialization of each entity's data being saved as a blob. In addition, nearly 40% of the space allocated is going unused, if I'm interpreting the unused leaf space correctly. I'm no database expert, but it seems there's room for improvement here. (sqlite-analyze table attached, excerpt inline with definitions below)

Whether the solution is adding features to filter entity logging in config (perhaps by whether they are nametagged e.g.), purge entity logs, or optimize the storage of entity data, I'd appreciate some guidance on what improvements might be best to look into.

        tblname        nentry       payload   leaf_unused compressed_size
0     co_entity   49.80 Mbyte   57.80 Gbyte   37.60 Gbyte     96.30 Gbyte
1  co_container  154.40 Mbyte   10.00 Gbyte  574.20 Mbyte     11.80 Gbyte
2      co_block  124.40 Mbyte    8.90 Gbyte  309.10 Mbyte     10.20 Gbyte
3       co_item   13.10 Mbyte    2.20 Gbyte  186.10 Mbyte      2.50 Gbyte
4    co_command    7.70 Mbyte  634.80 Mbyte    5.20 Mbyte    695.30 Mbyte
5       co_chat  971.50 kbyte   40.50 Mbyte  346.60 kbyte     46.90 Mbyte

space_used_202503191803.csv
analysis.sql

From analysis definitions:
leaf_unused int, -- Number of unused bytes on primary pages
Unused bytes on primary pages
The total number of bytes of unused space on all primary pages. The
percentage at the right is the number of unused bytes divided by the
total number of bytes on primary pages.

[DereC4]

second this

[DereC4]

Slightly related to #4

[tonyjamesstark]

take a peek at #839
finally had a chance to tinker a bit