What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi guys what is the purpose of this table `spy_event_behavior_entity_change` ?

UM9F81RCP
UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

Hi guys
what is the purpose of this table spy_event_behavior_entity_change ?

Comments

  • UKEP86J66
    UKEP86J66 Posts: 208 πŸ§‘πŸ»β€πŸš€ - Cadet

    It's the cache of all events generated in a request. At the end of the request they are all fetched and pushed into the event queue. If this succeeds they are deleted.

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    i see

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    is there a way to disable them ?

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    actually lets discuss it from another point .. is it possible that this has an impact on performance ?

  • Kind of ... Responses will be sent back to the clients before executing this code (it's handled on kernel event). BUT ... the process stays alive until the events have been published into the queue. There's two problems with this:
    1.) If you use session locking, the lock will only be removed when the PHP process shuts down. This leads new requests waiting to acquire a session lock resulting in slow throughput from a client perspective
    2.) Since the processes keep on living after responses have been sent back, you might exhaust available FPM workers if you have lots of incoming requests. This will result in clients waiting for free resouces and eventually getting a timeout error.

  • On the other hand: Sending messages to the queue should be fairly quick so the scenarios I described are rare

  • UM9F81RCP
    UM9F81RCP Posts: 516 πŸ§‘πŸ»β€πŸš€ - Cadet

    thank you Thomas

  • You're very welcome