Locking and Trimming about pulse HOT 2 CLOSED

Hi, @JulianMar, if performance is a concern in your application or you have amount of data in Pulse we recommend using the Redis ingest instead of writing directly to the database.

This means that the database trimming will happen in the pulse:work command and not during a request. It also means that inserts and deletes against the Pulse database are never happening at the same time.

Pulse will still trim the Redis stream within a request when the lottery triggers, but all if your pulse:work command is running the Redis stream is going to be empty and it will be unnoticeable to your application performance.

See: https://laravel.com/docs/11.x/pulse#performance

If you would like to keep writing directly to the database you could set the Lottery configuration to [0, 1]. This will stop the trimming within the request. You could then call Pulse::trim() in a scheduled command or elsewhere, but this doesn't necessarily fix the problem as it sounds like your tables are locking up when the trim is running and requests are writing to the DB.

I would recommend migrating to a Redis ingest, which should solve things and make your application performance even better. Hope that helps.

from pulse.

Thanks for the amazing comment! I will check it out :)

from pulse.