Plex crashing multiple times per night, during peak usage

Do you delete it all the time?

It’s supposed to accumulate information

This is telling me you’ve got a fair amount, but not excessive media.
(time required)

2024-04-21 20.06.14 - Auto    - START
2024-04-21 20.06.32 - Check   - Check com.plexapp.plugins.library.db - PASS
2024-04-21 20.06.38 - Check   - Check com.plexapp.plugins.library.blobs.db - PASS
2024-04-21 20.06.38 - Check   - PASS

If you’re using ZFS, there is a blocksize / record size for your filesystem.
You can use DBRepair to make the DB use that same recordsize
This will improve ZFS performance.